AR & SD tables , their fileds

[Former Member]

Can some body tell me all the important AR & SD tables & their fields.

Thanks

Nik

[Former Member]

[SAP tables|http://www.sap-img.com/sap-download/sap-tables.zip]

[Former Member]

This is just an extract of tables

5 FI/CO :

5.1 FI :

5.1.1 Master data

SKA1 Accounts

SKB1 Accts per company

SKAT Accts description

BNKA Bank master record

LFA1 Vendor profile

LFB1 Vendor profile per company

KNA1 Customer profile

KNB1 Customer profile per company

ADRC Address per profile

5.1.2 Accounting documents // indices

BKPF Accounting documents

BSEG item level

BSID Accounting: Secondary index for customers

BSIK Accounting: Secondary index for vendors

BSIM Secondary Index, Documents for Material

BSIP Index for vendor validation of double documents

BSIS Accounting: Secondary index for G/L accounts

BSAD Accounting: Index for customers (cleared items)

BSAK Accounting: Index for vendors (cleared items)

BSAS Accounting: Index for G/L accounts (cleared items)

5.1.3 Payment run

REGUH Settlement data from payment program

REGUP Processed items from payment program

5.1.4 Control totals

LFC1 AP Summary total per fiscal year

KNC1 AR Summary total per fiscal year

GLT0 GL Summary total per fiscal year

ZZGLT1T FICO Structure GL combined summary total per fiscal year

5.2 CO :

TKA01 Controlling areas

TKA02 Controlling area assignment

KEKO Product-costing header

KEPH Cost components for cost of goods manuf.

KALO Costing objects

KANZ Sales order items - costing objects

5.2.1 Cost center master data

CSKS Cost Center Master Data

CSKT Cost center texts

CRCO Assignment of Work Center to Cost Center

5.2.2 Cost center accounting

COSP CO Object: Cost Totals for External Postings

COEP CO Object: Line Items (by Period)

. COBK CO Object: Document header

COST CO Object: Price Totals

6 Sales and Distribution (SD) :

VBFA Document flow (alg.)

VTFA Flow shipping documents

6.1 Sales order :

VBAK Header data

VBAP Item data

VBPA Partners in sales order

VBKD Sales district data

VBEP Data related to line items, delivery lines

6.2 Billing document :

VBRK header data

VBRP Item data

6.3 Shipping :

VTTK Shipment header

VTTP Shipment item

VTTS Stage in transport

VTSP Stage in transport per shipment item

VTPA Shipment partners

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

6.4 Delivery :

LIKP Delivery header

LIPS Delivery item

6.5 Pricing :

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

6.6 contracts :

VEDA Contract data