All MM Tables and Fields and Links
All MM Tables and Fields and Links
All MM Tables and Fields and Links
1 LFA1 TABLE
2 EKKO TABLE
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
BNDDT-Binding period of quotation
INCO1-incoterms
INCO2-incoterms
REVNO-version number
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
ANFNR-Rfq number
BANFN-Purchase requisition number
4.EKBE (History per purchasing document)( it gives details like whether goods receipt is done or
invoice is done for aparticular po)
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
EBELP-Item code
ETENR-Delivery line counter
MENGE-Scheduled quantity
WEMNG-Quantity of goods received
WAMNG-Quantity issued
BANFN - Purchase requisition number
BNFPO-Item number in purchase requisition
GLMNG-Quantity deliverd
CHARG-Batch number
QUANTITY DELIVERED = EKET-MENGE
EKET-WEMNG
MATNR-Material code
ERSDA -Date of creation of material
PSTAT-Maintainence status
MTART-Material Type
MATKL-Material group
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
MATKL-Material group
MEINS-Unit of measure
BISMT-Old material number
BRGEW-Gross weight
NTGEW-Nett weight
SPART-Division
PRDHA-Product heirarichy
MAGRV-Material group(packing materials)
DATAB- Validity date
TAKLV-Tax classification
MATNR-Material code
LGORT- Storage location
LABST-stock in unrestricted use
WERKS-plant
LFGJA-Fiscal year
UMLME-Stock in transfer from one storage to another
INSME- stock in quality inspection
SPEME-Blocked stock
LGPBE-storage bin
9.MAKT(Material descriptions)
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
MATNR-Material code
MAKTX-Material description
SPRAS-Language key
11.MSEG
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
KUNNR-Customer
DMBTR-Amount in local currency
ERFMG-Quantity in unit entry
SMBLN-Number of material document
SMBLP-Item in material document
SGTXT-Item text
12.MBEW
MATNR-Material Code
LBKUM-Total valuated stock
VERPR-average price
STPRS-standard price
VMKUM-total valuated stock in previos stock
SALK3-value of total valuated stock
BWTAR-valuation area(plant)
BKLAS-valuation class
LVORM-deletion flag
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
EXDAT-excise document date
LIFNR-vendor number
EXBED-Basic excise duty
EXSED-special excise duty
EXAED-additional exsise duty
CESS-cess amount
REFDOC-internal reference document
KUNAG-sold to party
KUNWE-ship to party
EXCRN-excise registration number
NCCD-nccd value
ECS-ecs value
PANNO-Permanent account number
EXADDTAX1-additional value1
EXADDTAX2-additional value2
TRNTYP-Transaction type
DOCYR-document year
DOCNR-document number
MENGE-quantity
EXNUM-excise number
EXDAT-excise document date
LIFNR-vendor
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
MENGA-quantity received
RDOC1-reference document
STATUS-status of document
LICNO-internal license number
16.KONP(CONDITIONS ITEM)
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
BLART-document type(VENDOR INVOICE,INVOICE GROSS)
BLDAT-document date
TCODE-tcode
XBLNR-reference document
LIFNR-vendor number
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
SALK3-value of total valuated stock
LFBNR-document number of referenced document
LFGJA-fiscal year of current period
SGTXT-item text
FRBNR-bill of lading number
19.MCHB(BATCH STOCKS)
MATNR-Material code
WERKS-plant
LGORT-storage location
CHARG-batch number
CLABS-unrestricted stock
CUMLM-stock in transfer
CINSM-stock in quality inspection
CSPEM-blocked stock
CRETM-blocked stock returns
20.MARM(UNIT OF MEASURE)
MATNR-Material code
MEINH-unit of measure
MATNR-Material code
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
WERKS-plant
STLAN-Bom usage
STLAL-alternate bom
STLNR-bill of material
22.MVER(MATERIAL CONSUMPTION)
MATNR-Material code
WERKS-plant
GJAHR-year
GSV01,GSV01 TO GSV12-total consumption monthly
23.ADRC(ADDRESSES)
MATNR-materil code
BWKEY-valuation area(plant)
MENGE-quantity
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
SHKZG-debit/credit indicator
BUZEI-indicator of line item in accounting document
BUDAT-posting date
BELNR-accounting document number
DMBTR-amount in local currency
MATNR-Material code
WERKS-plant
CHARG-batch number
SOBKZ-special indicator
LIFNR-vendor number
LBLAB-value of unrestricted stock
LBINS-blocked stock
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
29.T159(MOVEMENT TYPES)
BWART(Movement types)
SHKZG(Debit/credit indicator)
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
LINKS BETWEEN TABLES
1.EKKO-EBELN
RSEG-EBELN
2.RBKP-BELNR
RSEG-BELNR
3.MKPF-MBLNR
RSEG-LFBNR
4.RSEG-EBELP
EKPO-EBELP
5.LFA1-LIFNR
EKKO-LIFNR
6.EKKO-EBELN
EKPO-EBELN
7.LFA1-ADDRNR
ADRC-ADDRNUMBER
8.MSEG-MBLNR
J_1IEXCHDR-RDOC
9.MBEW-BWKEY
MARD-WERKS
T001W-WERKS
10.MSLB-LFGJA
MSEG-MJAHR
11.RBCO-BELNR
EKBE-BELNR
12.KONV-KPOSN
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
EKPO-EBELP
13.J_1IGRXREF-MBLNR
RSEG-LFBNR
14.T685T-KSCHL
RSEG-KSCHL
15.KONV-KNUMV
KONP-KNUMH
16.MKPF-MBLNR
MSEG-MBLNR
17.KONV-KNUMV
EKKO-KNUMV
18.MSEG-EBELP
EKPO-EBELP
19.EKPO-BANFN
EBAN-BANFN
20.J_1IRG1-MATNR
MARA-MATNR
21.MKPF-MBLNR
VBFA-VBELN
22.RSEG-SGTXT
J_1IEXCHDR-EXNUM AND J_1IEXCDTL-EXNUM
23.VBRP-VBELN
J_1IEXCDTL-RDOC2
24.VBRK-VBELN
J_1IEXCDTL-RDOC2
25.VBRK-VBELN
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
J_1IEXCHDR-RDOC
26.RSEG-LFBNR
ESSR-LBLNI
27.BKPF-AWKEY
RSEG-BELNR
28.EKBE-BELNR
BKPF-BELNR
29.RSEG-EBELN
EKBE-EBELN
30.RBKP-LIFNR
LFA1-LIFNR
31.RBKP-BELNR
BKPF-AWKEY
32.J_1IEXCHDR-LIFNR
LFA1-LIFNR
33.EBAN-MATNR
MBEW-MATNR
34.EBAN-BANFN
EKPO-BANFN
35.EKPO-EBELN
MSEG-EBELN
36.MKPF-XBLNR
LIKP-VBELN
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
AUDAT-Document Date (Date Received/Sent)
AUART-Sales Document Type(STANDARD ORDER,AGI SCRAP SALES)
LIFSK-Delivery block (document header)
FAKSK-Billing block in SD document
NETWR-price
VKORG-sales organization(Hyderabad sales org,Chennai Sales Org)
VTWEG-distribution channel( Export ,Import,Deemed Export)
SPART-division(Amber Pharma,Flint Pharma)
VKGRP-sales group(HYD1,HYD2,HYD3)
VKBUR-sales office(Bhopal,Hyd-i,Hyd-ii,Hyd-iii)
KNUMV-document condition
BZIRK-Sales district(HYDARABAD -I,Cheanni,Hyd-ii,Bhopal)
KDGRP-SWAN DISTILLIRRIES,
APEX LABS
JHONSON & JHONSON
3.VBRK(SALES DOCUMENT:BILLING)
VBELN-Billing document
FKART-billing type
VBTYP-sd document category
WAERK-sd document currency
VKORG-sales organization
VTWEG-distribution channel
KNUMV-condition type
FKDAT-billing date
BZIRK-sales district
RFBSK-Status for transfer to accounting
CITYC-city code
KUNRG-payer
KDGRP-customer group
SPART-division
KURRF-exchange rate for fi postings
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
VBELV-preceding sales and distribution document
POSNV-preceding item of sd document
POSNN-subsequent item of sales document
VBELN-Sales document
VBELN-Sales document
BSTKD-customer purchase order number
BSTDK-customer purchase order date
LCNUM-internal financial document number
6.AKKB
VBELN-Delivery document
BZIRK-sales district
VSTEL-shipping point
LFART-document type
LFDAT-delivery date
LPRIO-delivery priority
TRAGR-transportation group
ANZPK-total number of packages in delivery
VBELN:Sales document
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
VEMNG:BASE QUANTITY PACKED
VBELN-billing document
POSNR-item code in billing document
FKIMG-actual invoiced quantity
MEINS-unit of measure
FKLMG-Billing quantity in stockkeeping unit
NTGEW-nett weight
BRGEW-gross weight
VOLUM-Actual Weight
GEWEI-weight unit
NETWR-price
AUBEL-sales document
MATNR-material code
ARKTX-item description
CHARG-batch number
WERKS-plant
SPARA-Division for order header
LGORT-storage location
VKORG_AUFT-Sales organization of sales order
VTWEG_AUFT-Distribution channel of sales order
MWSBP-tax code
MATKL-material group
10.VBPA(SALES DOCUMENT:PARTNER)
VBELN-Sales document
PARVW-partner function
LIFNR-vendor
VKORG-Sales organization
VTWEG-distribution channel
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
KUNNR-customer
MATNR-material code
KDMAT-material used by customer
POSTX-customer description of material
13.PGMI(PRODUCT GROUP)
14,T001W(PLANT/BRANCHES)
WERKS-plant
NAME1-name of plant
16.TPRIO(DELIVERY PRIORITIES)
LPRIO-Delivery Priority
APRIO-Order priority
J_1IEXCDCustomer Number
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
KUNNR-Customer Number
J_1IEXRN-Excise Registration Number
J_1IPANNO-Permanent Account Number
18.KONA(AGREEMENTS)
KUNNR-customer
KDGRP-sales group
VKORG-sales organization
VTWEG-distribution channel
SPART-division
BZIRK-sales district
20.TTGRT(TRANSPORTATION GROUPS)
TRAGR-transportation group
VTEXT-description
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
MWSKZ-Sales Tax Code
TEXT1-Name for value-added tax
23.T052(PAYMENT TERMS)
ZTERMS-Payment terms
24.NAST(MESSAGE STATUS)
KAPPL-Application for message conditions
OBJKY-Object key
KSCHL-Message type
PARNR-Message partner
PARVW-Partner function (for example SH for ship-to party)
25.VBOX(REBATE TABLE)
26.)VBBE(Sales requirement:Individual Requirements)
VBELN-Sales Document
POSNR-Item Number
ETENR-Delivery Schedule Line Number
MATNR-Material Number
WERKS-Plant
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
1.J_1IEXCHDR-RDOC
VBRK-VBELN
2.KNA1-KUNNR
VBRK-KUNRG
3.KNA1-KUNNR
J_1IEXCHDR-KUNAG
4.J_1IMOCUST-KUNNR
J_1IEXCHDR-KUNWE
5.VBKD-VBELN
VBFA-VBELV
6.LIKP-VBELN
VBRP-VGBEL
7.J_1IEXCDTL-RDOC1
LIKP-VBELN
8.VBRP-VBELN
EIKP-REFNR
9.VBFA-VBELN
VBRK-VBELN
10.VBAK-VBELN
VBAP-VBELN
11.AKKB-LCNUM
VBKD-LCNUM
12.LIKP-VBELN
VBFA-VBELN
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
13.VEPO-VBELN
LIKP-VBELV
14.T001W-WERKS
VBRP-WERKS
15.VBAK-VBELN
VBRP-AUBEL
16.VBPA-VBELN
VBRK-VBELN
17.LFA1-LIFNR
VBPA-LIFNR
18.VBRK-BELNR
BSEG-BELNR
19.LIKP-KUNNR
KNA1-KUNNR
20.VBRK-KNUMV
KONV-KNUMV
21.VBAP-AUGBL
J_1IEXCDTL-RDOC2
22.LIKP-VBELN
J_1IEXCDTL-RDOC1
23.VBFA-VBELV
J_1IEXCDTL-RDOC1 WHERE VBTYP_M = 'M'.
24.VBOX-VBELN
VBRK-VBELN
25.VBPA-VBELN
VBRK-VBELN
26.LIKP-VBELN
VBRP-VGBEL
27.VBPA-VBELN
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
VBRP-VGBEL
28.VBRK-VBELN
BSEG-ZUONR
29.J_1IEXCHDR-RDOC
BSEG-ZUONR
30.T171T-BZIRK
KNVV-BZIRK(Sales dist)
31.T151T-KDGRP
KNVV-KDGRP(Customer Grp)
32.TVKBT-VKBUR
KNVV-VKBUR(Sales Office)
33.TZONT-LZONE
KNA1-LZONE(Transporter Zone)
34.T016T-BRSCH(Industry Key)
KNA1-BRSCH
35.T005U-BLAND(Region)
KNA1-REGIO
35.TSPAT-SPART(Division)
VBRK-SPART
36.T023T-MATKL
VBRP-MATKL
37.VBRK-VBELN(For getting Fi document for a bill number) use fm FI_DOCUMENT_RECORD
BKPF-XBLNR
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES
EKKO - FRGKE (Release indicator)
EKKO - FRGZU Release status
T16FB
T16FC
Release Codes
T16FD
T16FE
T16FG
Release Groups
T16FH
T16FK
Release Statuses
NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG
LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES