Tables Of Sd, Mm, Fi

Sales and Distribution: Table Description Customers acct)

KNA1 General Data KNB1 Customer Master – Co. Code Data (payment method, reconciliation KNB4 KNB5 KNBK KNKA KNKK KNVV KNVI KNVP KNVD KNVS KLPA

Sales Documents VBUK VBAK VBKD VBUP VBAP VBPA VBFA VBEP VBBE

Customer Payment History Customer Master – Dunning info Customer Master Bank Data Customer Master Credit Mgmt. Customer Master Credit Control Area Data (credit limits) Sales Area Data (terms, order probability) Customer Master Tax Indicator Partner Function key Output type Customer Master Ship Data Customer/Vendor Link VBAKUK VBAK + VBUK Header Status and Administrative Data Sales Document - Header Data Sales Document - Business Data Item Status Sales Document - Item Data Partners Document Flow Sales Document Schedule Line Sales Requirements: Individual Records

SD Delivery Document LIPS Delivery Document item data, includes referencing PO LIKP Delivery Document Header data Billing Document VBRK Billing Document Header VBRP Billing Document Item SD Shipping Unit VEKP Shipping Unit Item (Content) VEPO Shipping Unit Header

Common Tables used by SAP MM Below are few important Common Tables used in Materials Management Modules: EINA Purchasing Info Record- General Data EINE Purchasing Info Record- Purchasing Organization Data MAKT Material Descriptions MARA General Material Data MARC Plant Data for Material MARD Storage Location Data for Material MAST Material to BOM Link MBEW Material Valuation MKPF Header- Material Document MSEG Document Segment- Material MVER Material Consumption

MVKE Sales Data for materials RKPF Document Header- Reservation T023 Mat. groups T024 Purchasing Groups T156 Movement Type T157H Help Texts for Movement Types MOFF Lists what views have not been created A501 Plant/Material EBAN Purchase Requisition EBKN Purchase Requisition Account Assignment EKAB Release Documentation EKBE History per Purchasing Document EKET Scheduling Agreement Schedule Lines EKKN Account Assignment in Purchasing Document EKKO Purchasing Document Header EKPO Purchasing Document Item IKPF Header- Physical Inventory Document ISEG Physical Inventory Document Items LFA1 Vendor Master (General section) LFB1 Vendor Master (Company Code) NRIV Number range intervals RESB Reservation/dependent requirements T161T Texts for Purchasing Document Types

SAP MM Tips by : Bahadur Following are the list of Important MM tables. Please check if its useful.

What is the table name for G/L Master data, when we create centrally (T.Code - FS00)? As far as general ledger master data is concerned, the following tables are involved : Table name : SKB1 : G/L Account Master ( Company Code) Fields: BUKRS : Company Code SAKNR : G/L Account Table name : SKA1 : G/L Account Master ( Chart of Accounts )

Fields: KTOPL : Char of Accounts SAKNR : G/L Account Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description ) Fields: SPRAS : Language KTOPL : Char of Accounts SAKNR : G/L Account *-- Viji Balakrishnan