1. Home
  2. Resources
  3. SAP Tables
  4. KOMLFP - Vendor billing document: billing document items

SAP Table KOMLFP

Vendor billing document: billing document items

KOMLFP (Vendor billing document: billing document items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KOMLFP to other SAP tables.

KOMLFP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WBELN Agency Business: Document Number WBELN_AG WBRK CHAR 10 0
POSNR Agency business: Document item WPOSNR_LF NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
MATKL Material Group MATKL T023 CHAR 9 0
WERKS Plant WERKS_D T001W CHAR 4 0
MWSKZ Agency business: Tax code (input tax) MWSKZ_LF T007A CHAR 2 0
MWSK2 Agency business: Tax code (output tax) MWSKZ_RB T007A CHAR 2 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
MENGE Vendor billing document: actual quantity billed WFIMG QUAN 13 3
NETPR Vendor billing document: net price in document currency WNETPR CURR 11 2
PEINH Price Unit of Vendor Billing Document Item WEINH DEC 5 0
WFKME Vendor billing document: unit of measure WFKME T006 UNIT 3 0
UMREZ Numerator converting qty in vendor bill.doc. to base unit UMWFZ DEC 5 0
UMREN Factor for converting qty in vendor bill. doc. to base unit UMWFN DEC 5 0
FPRME Billing price unit WFPRME T006 UNIT 3 0
FPUMZ Vendor billing doc.: numerator for converting BPUn to PBUn WPUMZ DEC 5 0
FPUMN Vendor billing doc.: denominator for converting BPUn to PBUn WPUMN DEC 5 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
NTGEW Net Weight WLF_NTGEW_15 QUAN 15 3
BRGEW Gross Weight WLF_BRGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume WLF_VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
MTART Material Type MTART T134 CHAR 4 0
NETWR Net value of the item in document currency NETWR_LFP CURR 15 2
BRTWR Gross value of the item in document currency BRTWR_LFP CURR 15 2
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
BONBA Rebate basis 1 BONBA CURR 13 2
EFFWR Effective Value of Item WLF_EFFWR CURR 13 2
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
KOWRR Statistical Values WKOWRR CHAR 1 0
NULL Item Transferred to Header Totals and Accounting
X Header Totals Adjusted, not Relevant to Accounting
Y Not Header Totals and not Relevant to Accounting
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
SKFBP Amount eligible for cash discount in document currency SKFBP CURR 13 2
NETWRD Net value of the item in document currency (customer-side) NETWRD_LFP CURR 15 2
BRTWRD Gross value of item in document currency (customer-side) BRTWRD_LFP CURR 15 2
KZWI1D Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2D Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3D Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4D Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5D Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6D Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
BONBAD Rebate basis 1 BONBA CURR 13 2
SKFBPD Amount qualifying for cash discount in doc. currency (cust.) SKFBPD CURR 13 2
EFFWRD Effective value of the item (customer-side) EFFWRD CURR 13 2
MWSBPD Tax amount in document currency (customer-side) MWSBPD CURR 13 2
WBELNV Agency business: Document number of the reference document WBELNV CHAR 10 0
POSNRV Item number of the reference document item WPOSNRV NUMC 6 0
LFTYPV Agency Business: Document Category of Preceding Document WFTYPV CHAR 2 0
01 External Document
02 External Delivery Note
03 External Sales Order
04 External Purchase Order
05 External Invoice
10 Trading Contract
11 Agency Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
40 Enterprise SOA Purchase Order
41 Enterprise SOA Sales Order
42 Enterprise SOA Inbound Delivery
43 Enterprise SOA Outbound Delivery
44 Enterprise SOA Original Invoice
45 Enterprise SOA Customer Invoice
46 Enterprise SOA Incoming Invoice
47 eSOA Basis Customer Invoice (Doc. in a Collective Invoice)
48 Enterprise SOA Original Credit Memo
49 Enterprise SOA Customer Credit Memo
50 Enterprise SOA Credit Memo
51 eSOA Basis Cust. Credit Memo (Doc. in a Collective Invoice)
60 Nomination
GJAHRV Fiscal Year GJAHR NUMC 4 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
LFGRU Agency business: Reason for activity WFGRU TMLFG CHAR 3 0
ARKTX Short Text TXZ01 CHAR 40 0
INFNR Number of Purchasing Info Record INFNR EINA CHAR 10 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
MWSBP Tax amount in document currency MWSBP CURR 13 2
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
EBONF Item Relevant to Subsequent (Period-End Rebate) Settlement EBONY CHAR 1 0
X Yes
NULL No
BONUS Settlement Group 1 (Purchasing) EBONU CHAR 2 0
EBON2 Settlement Group 2 (Rebate Settlement, Purchasing) EBON2 CHAR 2 0
EBON3 Settlement Group 3 (Rebate Settlement, Purchasing) EBON3 CHAR 2 0
LTSNR Vendor Subrange LTSNR WYT1 CHAR 6 0
EKKOL Condition Group with Vendor EKKOG CHAR 4 0
PUNEI Points unit PUNEI T006 UNIT 3 0
ANZPU Number of Points ANZPU QUAN 13 3
KOLIF Prior Vendor KOLIF LFA1 CHAR 10 0
NAVNW Non-deductible input tax NAVNW CURR 13 2
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BWTTY Valuation Category BWTTY_D T149C CHAR 1 0
GSBER Business Area GSBER TGSB CHAR 4 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
KOSTL Cost Center KOSTL CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
WUVPRS Agency business: Item incomplete re. price determination WUVPRS CHAR 1 0
X Yes
NULL No
WBELN_V Triggering document of the agency document WBELN_V CHAR 10 0
POSNR_V Triggering item in the agency document POSNR_V NUMC 6 0
FTYPV_V Agency Business: Document Category of Triggering Document WFTYP_V CHAR 2 0
01 Invoice
02 Invoice Reversal
03 Credit Memo
04 Credit Memo Reversal
05 Remuneration List
06 Credit Memo List
10 Trading Contract
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
11 Agency Business Document
60 Nomination
61 Nomination Item
70 Condition Contract
80 Freight Settlement
81 Freight Order
ITEMCAT Agency Business: Item Category WSHKZG CHAR 1 0
NULL Standard Item
1 Returns Item
2 Text Item
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
MWERT_IM Net Value in Document Currency NETWR CURR 15 2
MWERT_PR Net Value in Document Currency NETWR CURR 15 2
MWERT_UM Net Value in Document Currency NETWR CURR 15 2
CONTRACT Referencing Contract Number WCONTRACT CHAR 10 0
CONTRACT_TYPE Contract Type for Contract Number WCONTRACT_TYPE CHAR 1 0
1 Condition Contract
2 Trading Contract
3 Purchasing Document/Contract
CONTRACT_ITEM Referencing Contract Item Number WCONTRACT_ITEM NUMC 6 0
IDNLF_TYPE AB: Article Number Type - Vendor WLF_IDNLF_TYPE TMVMT CHAR 4 0
ITEM_STATUS Agency Business: Item Status WLF_ITEM_STATUS CHAR 1 0
NULL Item Is active
1 Item Is Inactive (Collective Document Has Been Generated)
2 Item Is Inactive (Settlement Document Has Been Generated)
ITEM_CANCELED Item Was Canceled WLF_ITEM_CANCELED CHAR 1 0
NULL is Active
1 Completed by Means of Item Cancellation
GUID_REF AB: GUID of Reference Document WLF_GUID_REFERENCE RAW 16 0
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
SETTL_STATUS_I_V AB: Settlement Status - Item - Vendor WLF_SETTLEMENT_STATUS_ITEM_V CHAR 1 0
NULL Not Relevant
1 Open
2 Blocked
3 Settled
6 Completed Through Cancellation
SETTL_STATUS_I_C AB: Settlement Status - Item - Customer WLF_SETTLEMENT_STATUS_ITEM_C CHAR 1 0
NULL Not Relevant
1 Open
2 Blocked
3 Settled
6 Completed Through Cancellation
SETTL_BLOCK_I_V AB: Settlement Block - Item - Vendor WLF_SETTLEMENT_BLOCK_ITEM_V TMSB CHAR 2 0
SETTL_BLOCK_I_C AB: Settlement Block - Item - Customer WLF_SETTLEMENT_BLOCK_ITEM_C TMSB CHAR 2 0
SETTL_ITEM_REL AB: Item Settlement Relevance WLF_SETTLEMENT_ITEM_RELEVANCE CHAR 1 0
NULL Standard
1 Only Vendor Side
2 Only Customer Side
3 None
CUOBJ Configuration CUOBJ_VA NUMC 18 0
FBUDA Date on which services rendered FBUDA DATS 8 0
J_1BNBM Brazilian NCM Code J_1BNBMCO1 T604F CHAR 16 0
J_1BMATUSE Usage of the material J_1BMATUSE CHAR 1 0
0 Resale
1 Industrialisation
2 Consumption
3 Asset
J_1BMATORG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
J_1BOWNPRO Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
J_1BINDUST Material CFOP category J_1BINDUS3 CHAR 2 0
00 material
01 electricity
02 communication
03 transportation
04 animal
J_1BCFOP CFOP Code and Extension J_1BCFOP J_1BAG CHAR 10 0
J_1BTXSDC SD tax code J_1BTXSDC_ J_1BTXSDC CHAR 2 0
J_1BTAXLW1 Tax law: ICMS J_1BTAXLW1 J_1BATL1 CHAR 3 0
J_1BTAXLW2 Tax law: IPI J_1BTAXLW2 J_1BATL2 CHAR 3 0
J_1BTAXLW3 ISS Tax Law J_1BTAXLW3 J_1BATL3 CHAR 3 0
J_1BTAXLW4 COFINS Tax Law J_1BTAXLW4 J_1BATL4A CHAR 3 0
J_1BTAXLW5 PIS Tax Law J_1BTAXLW5 J_1BATL5 CHAR 3 0
SAKTO G/L Account Number SAKNR SKA1 CHAR 10 0
SERVCONF_ITEM FSL: Service Confirmation Item FSL_SERVCONF_ITEM NUMC 10 0
STATUS FSL: User Status for Item FSL_STATUS FSL_STAT_CUST CHAR 4 0
IV_CHECK_TYPE_I Type of Check (Item) WLF_IV_CHECK_TYPE_ITEM CHAR 1 0
NULL Not Checked
1 Item Checked
REFSITE Reference Site For Purchasing WREFSITE CHAR 4 0
POSNR_MAIN Main Item for Item WLF_POSNR_MAIN NUMC 6 0
POSNR_SUB_EXIST Subitems Exist WLF_POSNR_SUB_EXIST CHAR 1 0
X Yes
NULL No
DISTRIB_STATUS AB: Status Distribution of Item WLF_DISTRIBUTION_STATUS CHAR 1 0
NULL Distribution Is Not Active
1 Relevant for Distribution
2 Not Relevant for Distribution
3 Distribution Incomplete
4 Distribution Carried Out
9 Item is Distribution Item
NO_TEXT_I No Texts Exist WLF_NO_TEXT CHAR 1 0
X Yes
NULL No
CWM_MENGE Quantity in Parallel Unit of Measure WLF_CWM_MENGE QUAN 13 3
CWM_MEINS AB: Parallel Unit of Measure WLF_CWM_MEINS UNIT 3 0
CWM_UOM_TYPE AB: Type of the Parallel Unit of Measure WLF_CWM_UOM_TYPE CHAR 1 0
NULL Base Unit of Measure is Valuation Unit of Measure
1 Parallel Unit of Measure is Valuation Unit of Measure
REF_NUMBER Reference Document for Agency Document WLF_REF_NUMBER CHAR 32 0
REF_ITEM_NUMBER Reference Document Item for Agency Document WLF_REF_ITEM_NUMBER NUMC 10 0
REF_TYPE Reference Document Category WLF_REF_TYPE CHAR 2 0
01 Invoice
02 Invoice Reversal
03 Credit Memo
04 Credit Memo Reversal
05 Remuneration List
06 Credit Memo List
10 Trading Contract
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
11 Agency Business Document
60 Nomination
61 Nomination Item
70 Condition Contract
80 Freight Settlement
81 Freight Order
ITEM_INTRA_REL Document Item is Relevant for Intrastat Declarations WLF_ITEM_INTRASTAT_RELEVANT CHAR 1 0
NULL Document item is not relevant
1 Document item is relevant
GRWRT Statistical value for foreign trade GRWRT CURR 13 2
GRWRTD Statistical Value for Foreign Trade (Customer-Side) GRWRTD CURR 13 2
POSTING_RULE_K_I AB: Creditor Posting Rule - Item WLF_POSTING_RULE_K_ITEM TMPR CHAR 2 0
POSTING_RULE_D_I AB: Debtor Posting Rule - Item WLF_POSTING_RULE_D_ITEM TMPR CHAR 2 0
WEIGHT_VOLUME Level on which You Enter Weight and Volume WLF_WEIGHT_VOLUME_LEVEL CHAR 1 0
NULL Billing Unit
1 Total Qty
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
INCO1_P Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2_P Incoterms (Part 2) INCO2 CHAR 28 0
KOKRSD Customer Controlling Area WLF_KOKRS_CUSTOMER TKA01 CHAR 4 0
PRCTRD Customer Profit Center WLF_PRCTR_CUSTOMER CEPC CHAR 10 0
KOSTLD Customer Cost Center WLF_KOSTL_CUSTOMER CSKS CHAR 10 0
PAOBJNRD Customer Profitability Segment Number (CO-PA) WLF_PAOBJNR_CUSTOMER NUMC 10 0
AUFNRD Customer Order Number WLF_AUFNR_CUSTOMER AUFK CHAR 12 0
PS_PSP_PNRD Customer Work Breakdown Structure Element (WBS Element) WLF_PS_PSP_PNR_CUSTOMER PRPS NUMC 8 0
GSBERD Customer Business Area WLF_GSBER_CUSTOMER TGSB CHAR 4 0
COLL_STATUS_I AB: Status for Collection of Settlement Request Item WLF_COLLECTION_STATUS_ITEM CHAR 1 0
NULL Not Relevant
1 Open
2 Locked
3 Settled
6 Completed Through Cancellation
COLL_BLOCK_I AB: Block Item for Collection of Settlement Requests WLF_COLLECTION_BLOCK_ITEM TMSB CHAR 2 0
COLL_REL AB: Relevance for Collection of Settlement Requests WLF_COLLECTION_RELEVANCE CHAR 1 0
NULL Standard
1 Exclude
CUSTOMER Customer WLF_CUSTOMER KNA1 CHAR 10 0
INVC_ITEM_ID BusinessTransactionDocumentItemID WLF_BTD_ITEM_ID CHAR 10 0
REFERENCE_ID BusinessTransactionDocumentID WLF_REF_ID CHAR 35 0
REF_ITEM_ID BusinessTransactionDocumentItemID WLF_REF_ITEM_ID CHAR 10 0
SCHEME_ID AB: Identifier for the ID Scheme WLF_SCHEME_ID CHAR 60 0
SCHEME_A_ID AB: ID of the Organization that Maintains the ID Scheme WLF_SCHEME_A_ID CHAR 60 0
AGENCY_ID_CODE AB: Agency of Standard ID for Invoice Document WLF_AGENCY_ID_CODE CHAR 3 0
REF_NUMBER_2 Additional Reference Document for Agency Document WLF_REF_NUMBER_2 CHAR 32 0
REF_ITEM_NUM_2 Additional Reference Document Item for Agency Document WLF_REF_ITEM_NUMBER_2 NUMC 10 0
REF_TYPE_2 Additional Reference Document Category WLF_REF_TYPE_2 CHAR 2 0
01 Invoice
02 Invoice Reversal
03 Credit Memo
04 Credit Memo Reversal
05 Remuneration List
06 Credit Memo List
10 Trading Contract
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
11 Agency Business Document
60 Nomination
61 Nomination Item
70 Condition Contract
80 Freight Settlement
81 Freight Order
UPDKZ Update indicator UPDKZ_D CHAR 1 0
WFKM1 Vendor billing document: unit of measure WFKME UNIT 3 0
FPRM1 Billing price unit WFPRME UNIT 3 0
MWSKZ_PR Checkbox XFELD CHAR 1 0
X Yes
NULL No
PNETWR Agency business: Net item amount in document currency WNETWP CURR 15 2
PBRTWR Agency business: Gross item amount in doc. currency WBRTWP CURR 15 2
PMWSBP Tax amount in document currency MWSBP CURR 13 2
DMWSBP Tax amount in document currency MWSBP CURR 13 2
KSTEU Condition control KSTEU CHAR 1 0
A Adjust for quantity variance
B Free
C Changed manually
D Fixed
E Condition value and basis fixed
F Condition value fixed (billed items)
G Condition basis fixed
H Condition value fixed (cost price)
I Scale Base Value and Condition Amount Fixed (for BYD only)
PRSOK Pricing is OK PRSOK CHAR 1 0
X Yes
NULL No
UVPRSD Agency business: Item incomplete re. price determination WUVPRS CHAR 1 0
X Yes
NULL No
FXMSGD Message number MSGNR CHAR 3 0
NETZU Checkbox XFELD CHAR 1 0
X Yes
NULL No
UVPRS Agency business: Item incomplete re. price determination WUVPRS CHAR 1 0
X Yes
NULL No
FXMSG Message number MSGNR CHAR 3 0
WARENWERT Net Value in Document Currency NETWR CURR 15 2
TAX Net Value in Document Currency NETWR CURR 15 2
VWERT Amount in Local Currency DMBTR CURR 13 2
VWERR Amount in Local Currency DMBTR CURR 13 2
VWALT Amount in Local Currency DMBTR CURR 13 2
BKLAS Valuation Class BKLAS CHAR 4 0
KOL_NAME1 Name 1 of an address NAME1_ADRS CHAR 40 0
BEZEI_KOLIF Address line LINES CHAR 80 0
KZBTR Amount in Group Currency KZBTR CURR 13 2
VOLUM_LF Volume VOLUM QUAN 13 3
NTGEW_LF Net Weight ENTGE QUAN 13 3
BRGEW_LF Gross Weight BRGEW QUAN 13 3
COND_PARTY Agency Business: Condition Determin. Level, Payment Docs WKOPAR CHAR 1 0
NULL Vendor-side
A Customer-side
B Vendor- and customer-side
WAART Indicates that material is a value-only material WAART CHAR 1 0
X Yes
NULL No
TAX_BASE_MM Net Value in Document Currency NETWR CURR 15 2
TAX_BASE_SD Net Value in Document Currency NETWR CURR 15 2
TAX_FROM_COND_MM Checkbox XFELD CHAR 1 0
X Yes
NULL No
TAX_FROM_COND_SD Checkbox XFELD CHAR 1 0
X Yes
NULL No
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
DMBTR_IM Amount in Local Currency DMBTR CURR 13 2
DMBTR_PR Amount in Local Currency DMBTR CURR 13 2
DMBTR_UM Amount in Local Currency DMBTR CURR 13 2
WAERL Currency of Agency Document WAERL CUKY 5 0
HWAER Local Currency HWAER CUKY 5 0
DMBTR_IM_UM Amount in Local Currency DMBTR CURR 13 2
WERKS_NAME Site WLF_WERKS CHAR 30 0
CONF_UPD Checkbox XFELD CHAR 1 0
X Yes
NULL No
NO_INCOTERM_DETERMINATION Agency Business: No Incoterm Determination WLF_NO_INCOTERM_DETERMINATION CHAR 1 0
X Yes
NULL No
PRED_NUMBER Causing Document of Trading Contract Item WB2_PRED_NUMBER CHAR 18 0
PRED_ITEM_NUMBER Causing Item of Trading Contract Item WB2_PRED_ITEM_NUMBER CHAR 10 0
PRED_DOC_TYPE Category of Causing Document WB2_PRED_DOC_TYPE CHAR 2 0
NULL Original Document
01 External Document
02 Purchase Order
03 Sales Order / Sales Contract
04 Trading Contract
LFTYPV_STD Agency Business: Document Category of Preceding Document WFTYPV CHAR 2 0
01 External Document
02 External Delivery Note
03 External Sales Order
04 External Purchase Order
05 External Invoice
10 Trading Contract
11 Agency Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
40 Enterprise SOA Purchase Order
41 Enterprise SOA Sales Order
42 Enterprise SOA Inbound Delivery
43 Enterprise SOA Outbound Delivery
44 Enterprise SOA Original Invoice
45 Enterprise SOA Customer Invoice
46 Enterprise SOA Incoming Invoice
47 eSOA Basis Customer Invoice (Doc. in a Collective Invoice)
48 Enterprise SOA Original Credit Memo
49 Enterprise SOA Customer Credit Memo
50 Enterprise SOA Credit Memo
51 eSOA Basis Cust. Credit Memo (Doc. in a Collective Invoice)
60 Nomination
REFTYP_SOA Agency Business: Document Category of Preceding Document WFTYPV CHAR 2 0
01 External Document
02 External Delivery Note
03 External Sales Order
04 External Purchase Order
05 External Invoice
10 Trading Contract
11 Agency Document
12 Sales Order/Contract
13 Delivery
14 Billing Document
15 Inbound Delivery
16 Goods Receipt
17 Purchase Order
18 Shipment Document
20 Pro Forma Customer Sales Document
30 Incoming Invoice
31 Service Entry Sheet
40 Enterprise SOA Purchase Order
41 Enterprise SOA Sales Order
42 Enterprise SOA Inbound Delivery
43 Enterprise SOA Outbound Delivery
44 Enterprise SOA Original Invoice
45 Enterprise SOA Customer Invoice
46 Enterprise SOA Incoming Invoice
47 eSOA Basis Customer Invoice (Doc. in a Collective Invoice)
48 Enterprise SOA Original Credit Memo
49 Enterprise SOA Customer Credit Memo
50 Enterprise SOA Credit Memo
51 eSOA Basis Cust. Credit Memo (Doc. in a Collective Invoice)
60 Nomination
ITEM_ACC_RELEVANCE_IND Item is Relevant for Accounting WLF_ITEM_ACC_RELEVANCE_IND CHAR 1 0
X Yes
NULL No
ITEM_RETURNS_IND Item is a Return Item WLF_ITEM_RETURNS_IND CHAR 1 0
X Yes
NULL No
DEFERRED_IND AB: Deferred Tax Code WLF_DEFERRED_IND CHAR 1 0
X Yes
NULL No
TAX_CATEGORY_CODE Tax type STGRP_007B CHAR 1 0
1 Output tax
2 Input tax
3 Additional tax
4 Not relevant to tax
REF_PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
REF_SAKTO G/L Account Number SAKNR CHAR 10 0
KNUMH Condition record number KNUMH KONH CHAR 10 0
KOPOS Sequential number of the condition KOPOS KONP NUMC 2 0
COCO_NUM Condition Contract Number WCB_COCO_NUM CHAR 10 0

KOMLFP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KOMLFP AKTNR KOMLFP MANDT WAKH Promotion Header Data, IS-R MANDT
KOMLFP AKTNR KOMLFP AKTNR WAKH Promotion Header Data, IS-R AKTNR
KOMLFP AUFNR KOMLFP MANDT AUFK Order master data MANDT
KOMLFP AUFNR KOMLFP AUFNR AUFK Order master data AUFNR
KOMLFP AUFNRD KOMLFP MANDT AUFK Order master data MANDT
KOMLFP AUFNRD KOMLFP AUFNRD AUFK Order master data AUFNR
KOMLFP BEMOT KOMLFP BEMOT TBMOT Accounting indicators BEMOT
KOMLFP BEMOT KOMLFP MANDT TBMOT Accounting indicators MANDT
KOMLFP BWTAR KOMLFP BWTAR T149D Global Valuation Types BWTAR
KOMLFP BWTAR KOMLFP MANDT T149D Global Valuation Types MANDT
KOMLFP BWTTY KOMLFP MANDT T149C Global Valuation Categories MANDT
KOMLFP BWTTY KOMLFP BWTTY T149C Global Valuation Categories BWTTY
KOMLFP CHARG KOMLFP MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
KOMLFP CHARG KOMLFP CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
KOMLFP CHARG KOMLFP MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
KOMLFP COLL_BLOCK_I KOMLFP MANDT TMSB AB: Settlement Blocks MANDT
KOMLFP COLL_BLOCK_I KOMLFP COLL_BLOCK_I TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
KOMLFP CUSTOMER KOMLFP CUSTOMER KNA1 General Data in Customer Master KUNNR
KOMLFP CUSTOMER KOMLFP MANDT KNA1 General Data in Customer Master MANDT
KOMLFP FPRME KOMLFP MANDT T006 Units of Measurement MANDT
KOMLFP FPRME KOMLFP FPRME T006 Units of Measurement MSEHI
KOMLFP GEWEI KOMLFP MANDT T006 Units of Measurement MANDT
KOMLFP GEWEI KOMLFP GEWEI T006 Units of Measurement MSEHI
KOMLFP GSBER KOMLFP MANDT TGSB Business Areas MANDT
KOMLFP GSBER KOMLFP GSBER TGSB Business Areas GSBER
KOMLFP GSBERD KOMLFP MANDT TGSB Business Areas MANDT
KOMLFP GSBERD KOMLFP GSBERD TGSB Business Areas GSBER
KOMLFP IDNLF_TYPE KOMLFP MANDT TMVMT AB: Article Number Type - Vendor MANDT
KOMLFP IDNLF_TYPE KOMLFP IDNLF_TYPE TMVMT AB: Article Number Type - Vendor IDNLF_TYPE
KOMLFP INCO1_P KOMLFP INCO1_P TINC Customers: Incoterms INCO1
KOMLFP INCO1_P KOMLFP MANDT TINC Customers: Incoterms MANDT
KOMLFP INFNR KOMLFP MANDT EINA Purchasing Info Record: General Data MANDT
KOMLFP INFNR KOMLFP INFNR EINA Purchasing Info Record: General Data INFNR
KOMLFP J_1BCFOP KOMLFP MANDT J_1BAG CFOP MANDT
KOMLFP J_1BCFOP KOMLFP J_1BCFOP J_1BAG CFOP CFOP
KOMLFP J_1BNBM KOMLFP MANDT T604F Import Processing: Control Code MANDT
KOMLFP J_1BNBM * T604F Import Processing: Control Code LAND1
KOMLFP J_1BNBM KOMLFP J_1BNBM T604F Import Processing: Control Code STEUC
KOMLFP J_1BTAXLW1 KOMLFP MANDT J_1BATL1 Tax Law ICMS MANDT
KOMLFP J_1BTAXLW1 KOMLFP J_1BTAXLW1 J_1BATL1 Tax Law ICMS TAXLAW
KOMLFP J_1BTAXLW2 KOMLFP MANDT J_1BATL2 Tax Law IPI MANDT
KOMLFP J_1BTAXLW2 KOMLFP J_1BTAXLW2 J_1BATL2 Tax Law IPI TAXLAW
KOMLFP J_1BTAXLW3 KOMLFP MANDT J_1BATL3 Tax Laws ISS MANDT
KOMLFP J_1BTAXLW3 KOMLFP J_1BTAXLW3 J_1BATL3 Tax Laws ISS TAXLAW
KOMLFP J_1BTAXLW4 KOMLFP MANDT J_1BATL4A Tax Laws COFINS MANDT
KOMLFP J_1BTAXLW4 KOMLFP J_1BTAXLW4 J_1BATL4A Tax Laws COFINS TAXLAW
KOMLFP J_1BTAXLW5 KOMLFP MANDT J_1BATL5 Tax Laws PIS MANDT
KOMLFP J_1BTAXLW5 KOMLFP J_1BTAXLW5 J_1BATL5 Tax Laws PIS TAXLAW
KOMLFP J_1BTXSDC KOMLFP MANDT J_1BTXSDC SD tax codes MANDT
KOMLFP J_1BTXSDC KOMLFP J_1BTXSDC J_1BTXSDC SD tax codes TAXCODE
KOMLFP KNUMH SYST MANDT KONH Conditions (Header) MANDT
KOMLFP KNUMH KOMLFP KNUMH KONH Conditions (Header) KNUMH
KOMLFP KOKRS KOMLFP MANDT TKA01 Controlling Areas MANDT
KOMLFP KOKRS KOMLFP KOKRS TKA01 Controlling Areas KOKRS
KOMLFP KOKRSD KOMLFP MANDT TKA01 Controlling Areas MANDT
KOMLFP KOKRSD KOMLFP KOKRSD TKA01 Controlling Areas KOKRS
KOMLFP KOLIF KOMLFP MANDT LFA1 Vendor Master (General Section) MANDT
KOMLFP KOLIF KOMLFP KOLIF LFA1 Vendor Master (General Section) LIFNR
KOMLFP KOPOS KOMLFP KOPOS KONP Conditions (Item) KOPOS
KOMLFP KOPOS SYST MANDT KONP Conditions (Item) MANDT
KOMLFP KOPOS KOMLFP KNUMH KONP Conditions (Item) KNUMH
KOMLFP KOSTLD KOMLFP KOSTLD CSKS Cost Center Master Data KOSTL
KOMLFP KOSTLD KOMLFP PRSDT CSKS Cost Center Master Data DATBI
KOMLFP KOSTLD KOMLFP MANDT CSKS Cost Center Master Data MANDT
KOMLFP KOSTLD KOMLFP KOKRSD CSKS Cost Center Master Data KOKRS
KOMLFP LFGRU KOMLFP MANDT TMLFG Agency Business: Transaction Reasons MANDT
KOMLFP LFGRU KOMLFP LFGRU TMLFG Agency Business: Transaction Reasons LFGRU
KOMLFP LTSNR KOMLFP MANDT WYT1 Vendor Subrange MANDT
KOMLFP LTSNR KOMLFP KOLIF WYT1 Vendor Subrange LIFNR
KOMLFP LTSNR KOMLFP LTSNR WYT1 Vendor Subrange LTSNR
KOMLFP MANDT KOMLFP MANDT T000 Clients MANDT
KOMLFP MATKL KOMLFP MANDT T023 Material Groups MANDT
KOMLFP MATKL KOMLFP MATKL T023 Material Groups MATKL
KOMLFP MATNR KOMLFP MANDT MARA General Material Data MANDT
KOMLFP MATNR KOMLFP MATNR MARA General Material Data MATNR
KOMLFP MEINS KOMLFP MANDT T006 Units of Measurement MANDT
KOMLFP MEINS KOMLFP MEINS T006 Units of Measurement MSEHI
KOMLFP MTART KOMLFP MANDT T134 Material Types MANDT
KOMLFP MTART KOMLFP MTART T134 Material Types MTART
KOMLFP MWSK2 KOMLFP MWSK2 T007A Tax Keys MWSKZ
KOMLFP MWSK2 KOMLFP MANDT T007A Tax Keys MANDT
KOMLFP MWSK2 T005 KALSM T007A Tax Keys KALSM
KOMLFP MWSKZ KOMLFP MANDT T007A Tax Keys MANDT
KOMLFP MWSKZ T005 KALSM T007A Tax Keys KALSM
KOMLFP MWSKZ KOMLFP MWSKZ T007A Tax Keys MWSKZ
KOMLFP POSTING_RULE_D_I KOMLFP POSTING_RULE_D_I TMPR AB: Posting Rules POSTING_RULE
KOMLFP POSTING_RULE_D_I KOMLFP MANDT TMPR AB: Posting Rules MANDT
KOMLFP POSTING_RULE_K_I KOMLFP MANDT TMPR AB: Posting Rules MANDT
KOMLFP POSTING_RULE_K_I KOMLFP POSTING_RULE_K_I TMPR AB: Posting Rules POSTING_RULE
KOMLFP PRCTRD KOMLFP MANDT CEPC Profit Center Master Data Table MANDT
KOMLFP PRCTRD KOMLFP PRCTRD CEPC Profit Center Master Data Table PRCTR
KOMLFP PRCTRD KOMLFP PRSDT CEPC Profit Center Master Data Table DATBI
KOMLFP PRCTRD KOMLFP KOKRSD CEPC Profit Center Master Data Table KOKRS
KOMLFP PS_PSP_PNR KOMLFP MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
KOMLFP PS_PSP_PNR KOMLFP PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
KOMLFP PS_PSP_PNRD KOMLFP PS_PSP_PNRD PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
KOMLFP PS_PSP_PNRD KOMLFP MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
KOMLFP PUNEI KOMLFP MANDT T006 Units of Measurement MANDT
KOMLFP PUNEI KOMLFP PUNEI T006 Units of Measurement MSEHI
KOMLFP SAKTO KOMLFP MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
KOMLFP SAKTO T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
KOMLFP SAKTO KOMLFP SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
KOMLFP SETTL_BLOCK_I_C KOMLFP SETTL_BLOCK_I_C TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
KOMLFP SETTL_BLOCK_I_C KOMLFP MANDT TMSB AB: Settlement Blocks MANDT
KOMLFP SETTL_BLOCK_I_V KOMLFP MANDT TMSB AB: Settlement Blocks MANDT
KOMLFP SETTL_BLOCK_I_V KOMLFP SETTL_BLOCK_I_V TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
KOMLFP STAFO KOMLFP MANDT TMCB Update groups MANDT
KOMLFP STAFO KOMLFP STAFO TMCB Update groups STAFO
KOMLFP STATUS KOMLFP STATUS FSL_STAT_CUST FSL: User Status for Item STATUS
KOMLFP STATUS SYST MANDT FSL_STAT_CUST FSL: User Status for Item MANDT
KOMLFP TXJCD KOMLFP MANDT TTXJ Check Table for Tax Jurisdiction MANDT
KOMLFP TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
KOMLFP TXJCD KOMLFP TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
KOMLFP VOLEH KOMLFP VOLEH T006 Units of Measurement MSEHI
KOMLFP VOLEH KOMLFP MANDT T006 Units of Measurement MANDT
KOMLFP WBELN KOMLFP MANDT WBRK Agency business: Header MANDT
KOMLFP WBELN KOMLFP WBELN WBRK Agency business: Header WBELN
KOMLFP WERKS KOMLFP MANDT T001W Plants/Branches MANDT
KOMLFP WERKS KOMLFP WERKS T001W Plants/Branches WERKS
KOMLFP WFKME KOMLFP MANDT T006 Units of Measurement MANDT
KOMLFP WFKME KOMLFP WFKME T006 Units of Measurement MSEHI