tables of sd, mm, fi

6
Sales and Distribution: Table Description Customers KNA1 General Data KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct) KNB4 Customer Payment History KNB5 Customer Master – Dunning info KNBK Customer Master Bank Data KNKA Customer Master Credit Mgmt. KNKK Customer Master Credit Control Area Data (credit limits) KNVV Sales Area Data (terms, order probability) KNVI Customer Master Tax Indicator KNVP Partner Function key KNVD Output type KNVS Customer Master Ship Data KLPA Customer/Vendor Link Sales Documents VBAKUK VBAK + VBUK VBUK Header Status and Administrative Data VBAK Sales Document - Header Data VBKD Sales Document - Business Data VBUP Item Status VBAP Sales Document - Item Data VBPA Partners VBFA Document Flow VBEP Sales Document Schedule Line VBBE 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

Upload: api-3708589

Post on 11-Apr-2015

1.202 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: Tables of SD, MM, Fi

Sales and Distribution:

                  Table Description

Customers         KNA1   General Data                  KNB1   Customer Master – Co. Code Data (payment method, reconciliation acct)                  KNB4   Customer Payment History                  KNB5   Customer Master – Dunning info                  KNBK   Customer Master Bank Data                  KNKA   Customer Master Credit Mgmt.                  KNKK   Customer Master Credit Control Area Data (credit limits)                  KNVV   Sales Area Data (terms, order probability)                  KNVI   Customer Master Tax Indicator                  KNVP   Partner Function key                  KNVD   Output type                  KNVS   Customer Master Ship Data                  KLPA   Customer/Vendor Link                                   Sales Documents   VBAKUK VBAK + VBUK                  VBUK   Header Status and Administrative Data                  VBAK   Sales Document - Header Data                  VBKD   Sales Document - Business Data                  VBUP   Item Status                  VBAP   Sales Document - Item Data                  VBPA   Partners                  VBFA   Document Flow                  VBEP   Sales Document Schedule Line                  VBBE   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 

Page 2: Tables of SD, MM, Fi

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.

Page 3: Tables of SD, MM, Fi
Page 4: Tables of SD, MM, Fi
Page 5: Tables of SD, MM, Fi

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 )

Page 6: Tables of SD, MM, Fi

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