TABLES IDENTIFICATION

There are two types of Data in SAP

 1. Master data (GL accounts, customers, vendors, assets, cost elements, cost centers, profit centers etc.)

 2. Transactional Data (Open Items for customers and vendors, GL line items, Cost Center planning, profit center plan data load etc.)

 Therefore the tables are also different to store value.

 For Master Data, the data is stored in

•   A ->   Chart of Accounts
• B -> Company Code
• K -> Denotes Customer in Master Data
• L-> Denotes Vendor in Master Data
• S-> Denotes General in Master Data

 KNA1 -> Customer Master Data in Chart of Account

KNB1-> Customer Master Data in Company Code

 LFA1-> Vendor Master Data in Chart of Account

LFB1-> Vendor Master Data in Company Code

 SKA1-> GL Master Data in Chart of Account

SKB1->GL Master Data in Company Code

 For Transactional Data, the source structures are

•  BKPF – It stores Document header information
• BSEG – It stores line item level information

 BS -> This is common across all transactional Documents.

 I-> This is used for all open item.

A-> This is used for all cleared Item.

 BSID -> Table for open item for Debtor

BSIA -> Table for open item for Assets

BSIS -> Table for open item for General Ledger

BSIK -> Table for open item for Vendor

 BSAD -> Table for cleared items for Debtor

BSAS -> Table for cleared items for General Ledger

BSAK -> Table for cleared items for Vendor

 To check any table, you should check SE11

Paying by Payment Card

http://jsklavkumar.blogspot.com/2014/12/paying-by-payment-card.htmlUse

Payment card data is transferred to the Financial Accounting (FI) application component from the Sales and Distribution (SD) application component or from the SAP Retail industry solution via interfaces.

Payment card data is not entered or changed in the accounting document. When data is transferred from Sales and Distribution (SD) or SAP Retail, the system copies payment card information to the financial accounting document. Payment card data is transferred only to accounts receivable line items and to those G/L items that contain the receivables due to the payment card institute. Accounts payable line items are not affected.

Integration

The payment card processing chain starts in the Sales and Distribution application component. The following business transactions are entered here: 

Customer Order

 You enter a customer order in Sales and Distribution (SD). You enter payment card master data (card number, card type, card category, validity and so on) at the same time. The payment card institute then carries out an (automatic or manual) authorization check on the payment card. The result of this check is then saved.

 Delivery

 You enter a delivery in shipping. Authorization is checked once more.

 Billing

 When you bill orders, the system copies payment card data from the order to the bill.

Once you have entered the bill, this data is transferred to Financial Accounting via an interface. Meanwhile, the system copies the payment card information, the amount, and the authorization data to the Financial Accounting document.

The payment card accounting data is billed to the payment card institute within Financial Accounting.

Prerequisites

You must define the settings for payment cards in the Sales and Distribution section of the Implementation Guide (IMG). To do this, choose the Billing component. Here, you find the payment card settings.

Additional settings for payment cards can be made in the Accounts Receivable and Accounts Payable section of the IMG. Choose Business Transactions → Payments with Payment Cards.