[go: up one dir, main page]

0% found this document useful (0 votes)
1K views29 pages

All MM Tables and Fields and Links

Download as docx, pdf, or txt
Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1/ 29

NOTE:J_1IEXCHDR,MARA,MAKT,J_1IEXCDTL,KONV,KONP,EKBE,MKPF,MSEG

LFA1,KNA1,MARD exc are common tables between SD AND MM MODULES


IMPORTANT FIELDS IN MM MODULE

1 LFA1 TABLE

LIFNR -vendor a/c number


NAME1-name of vendor
ORT01- city of vendor
ADRNR-address

2 EKKO TABLE

EBELN-purchase order number


AEDAT-date of creation of purchase document
BSTYP-purchase document category(RFQ,PO,CONTRACT)
BSART-purchase document type(IMPORT ORDER,CAPITAL ORDER,SERVICE
ORDER,G.STORES INDENT)
STATU-status of purchasing document type
LIFNR-vendor a/c number
ZTERMS-payment terms
EKORG-purchase organization(HYD ORG,MUMBAI ORG,GPPL ORG)
EKGRP-purchasing group(RAVI KUMAR GROUP,PVSR GROUP)
WAERS-CURRENCY
WKURS-exchange rate
BEDAT-purchasing document date
ANGNR-quotation number
ANGDT-Deadline of submission of quotation

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

3 EKPO(PURCHASING DOCUMENT ITEM DATA)

EBELN-purchase order number


EBELP-item code
LOEKZ-rfq status
TXZ01-short text of material
MATNR - material code
NETPR - unit price
NETWR - total price
MENGE - quantity
MEINS-unit of measure
NTGEW - nett weight
BRGEW - gross weight
LGORT- storage location
WERKS -Plant
MATKL - Material group
MTART-material type
MWSKZ - Sales tax code
BWTAR-valuation type
ELIKZ - Delivery completed 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
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)

EBELN-purchasing document number


EBELP-Item code
GJAHR-Year of purchasing document
BELNR-Number of material document
BWART-Movement Type
BUDAT-Posting Date
SHKZG- Debit/Credit Indicator
XBLNR-Reference document Number
BWTAR-valuation type
LFBNR- Document number of reference document
CPUDT-date on which accounting document entered
WERKS-plant
MATNR-Material code
BAMNG-Quantity
CHARG-batch Number
ELIKZ- Delivery completed indicator
LFGJA-Fiscal Year

5.EKET (SCHEDULE AGREEMENT SCHEDULE LINES)

EBELN-Purchasing document 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
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

6.EKKN(PURCHASING DOCUMENT ACCOUNTING ASSIGNMENT)

EBELN-Purchasing document number


EBELP-Item code
MENGE-Quantity
ANLN1-Asset Number
SAKTO-G/L indicator

7.MARA(General material data)

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

8.MARD(Material and Storage location data)

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

10.MKPF(Material document:header data)

MBLNR-Material document number


MJAHR-year
BUDAT-posting date
BLART-document type
TCODE-Tcode
XBLNR-reference document number
FRBNR-bill of lading
BLDAT-Document date

11.MSEG

MBLNR-material document number


LGORT-storage location
BWART-movement type
WERKS-plant
MENGE-quantity
SHKZG-debit/credit indicator
MJAHR-fiscal year
XAUTO-item created
CHARG-Batch 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
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

13.J_IIEXCHDR(EXCISE TABLE USEFUL FOR MM AND SD MODULE)


TRNTYP-Excise transaction type
DOCNR-Internal excise document number
RDOC-reference document
DOCYR-document number
EXGRP-excise group
EXNUM-excise document 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
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

14.J_1IEXCDTL(EXCISE INVOICE LINE ITEMS)

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

15.KONV(CONDITIONS TABLE,FOR TAX DATA)

KNUMV-Number of condition document


KPOSN-item code
KSCHL-condition type
KDATU-condition pricing type
KAWRT-condition base value(TOTAL VALUE)
KBETR-rate(condition amount)(RATE 10%)
KNUMH-condition record number
KWERT-condition value(RESULTANT VALUE)

16.KONP(CONDITIONS ITEM)

KNUMH-Condition record number


KSCHL-condition type
KBETR-condition rate

17.RBKP(DOCMENT HEADER :INVOICE RECEIPT)

BELNR - accounting document number


RMWWR-invoice amount

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

18.RSEG(DOCUMENT ITEM:INCOMING INVOICE)

BELNR-Accounting document number


GJAHR-year
BUZEI-document item in invoice document
EBELN-purchase order
EBELP-item code
MATNR-material code
BWKEY-valuation area
BWTAR-valuation type
WERKS-plant
WRBTR-amount in document currency
SHKZG-debit/credit indicator
MWSKZ-tax code
MENGE-quantity
BPMNG-quantity in purchase order
LBKUM-valuated stock
BKLAS-valuation class
XBLNR-reference document number
KSCHL-condition type

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

21.MAST(MATERIAL TO BOM LINK)

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)

ADDRNUMBER-ADDRESS(NUMBER) ,LINKED WITH ADDRNR INLFA1 TABLE


NAME1-name of vendor
CITY1-city
POST_CODE1-postal code
STREET-street
COUNTRY-country

25.BSIM(SECONDARY INDEX ,DOCUMENTS OF MATERIALS)

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

26.J_1IMOVEND(VENDOR MASTER EXCISE ADDITIONAL DATA)

LIFNR -Vendor number


J_1IEXCD-ECC number
J_1IEXRN-excise registration number
J_1IPANNO-permanent account number

27.J_1IMOCOMP(COMPANY AND PLANT ADDITIONAL DATA)


J_1IEXCD-ECC number
J_1IEXRN-excise register number

28.MSLB(SPECIAL STOCKS WITH VENDOR)

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)

30.J_2IRG1BAL(EXCISE RG1 DETAILS)


EXGRP-Excise group
MATNR-material code
WERKS-plant
OP_FINISH
CB_FINISH

31.J_1IRG1(EXCISE REGISTER TABLE)


EXGRP-Excise group
BWART-movement type
MATNR-material code
MENGE-quantity
MAKTX-material description
WERKS-plant
LGORT-storage location
CHARG-batch number
RDOC1-reference document 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
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

SD MODULE TABLES AND FIELDS

Credit and risk mgt


Billing
Foreign trade /customs
Pricing and conditions
Shipping
transportation

1.KNA1(CUSTOMER MASTER DATA)

KUNNR-Customer a/c number


NAME1-name of customer
ORT01-city
PSTLZ-postal code
ADRNR-address number

2.VBAK(SALES DOCUMENT:HEADER DATA)


VBELN-sales order
KUNNR-customer
ERDAT-date of creation of sales order
ANGDT-Quotation/Inquiry is valid from
BNDDT-Date until which bid/quotation is binding (valid-to date)
VBTYP-SD document category(QUTOATION,INQUIRY,SALES ORDER,DEBIT
MEMO,CREDIT MEMO)

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

4.VBFA(SALES DOCUMENT FLOW)

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

5.VBKD(SALES DOCUMENT BUSINESS DATA)

VBELN-Sales document
BSTKD-customer purchase order number
BSTDK-customer purchase order date
LCNUM-internal financial document number

6.AKKB

LCNUM-internal financial document number


BAANR-external document number

7.LIKP(DELIVERY HEADER DATA)

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

8.VEPO(PACKING UNIT ITEM HANDLING)

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

9.VBRP(BILLING DOCUMENT:ITEM DATA)

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

11.BSEG(ACCOUNTING DOCUMENT SEGMENT)


BELNR-accounting document number
AUGBL-document number of clearing document
MWSKZ-tax code
KUNNR-customer number

12.KNMT( Customer-Material Info Record Data)

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)

PGTYP-Product group type


PRGRP-Name of the product group
WERKS-plant
NRMIT-Name of the product group
WEMIT-plant
DATUM-Valid-to date
VSNDA-production version

14,T001W(PLANT/BRANCHES)

WERKS-plant
NAME1-name of plant

15.EIKP(FOREIGN TRADE,IMPORT/EXPORT DATA)

REFNR-sales and distribution document number


IEVER-Domestic Mode of Transport for Foreign Trade
ALAND-country

16.TPRIO(DELIVERY PRIORITIES)

LPRIO-Delivery Priority
APRIO-Order priority

17.J_1IMOCUST(CUSTOMER MASTER EXCISE ADDITIONAL DATA)

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)

KNUMA-Agreement (various conditions grouped together)


BONEM-Rebate recipient
VKORG-Sales Organization
VTWEG-Distribution Channel
SPART-Division
DATAB-Agreement valid-from date
BOART-Agreement type
BOSTA-Status of the agreement

19.KNVV(CUSTOMER AND SALES AREA)

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

21.T007S(tax code names)

KALSM-Procedure (Pricing, Output Control, Acct. Det., Costing,...)

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

22.KNKK(on Customer master credit management: Control area)


KUNNR-Customer Number 1
KKBER-Credit control area
KLIMK-Customer's credit limit
KNKLI-Customer's account number with credit limit reference
SAUFT-Total of the sales values for the credit limit check

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

LINKS BETWEEN THE TABLES

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

EKKO - FRGGR (Release group)


EKKO - FRGSX (Release Strategy)

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

Release Indicator: Purchasing Document

T16FC

Release Codes

T16FD

Description of Release Codes

T16FE

Descriptions of Release Indicators: Purchasing documents.

T16FG

Release Groups

T16FH

Descriptions of Release Groups

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

You might also like