2LIS_45_ITM

Agency document: Item data | #TRAN | Extraction method: F1 | Delta: ABR | Component: Agency Business

Tables used: WBRP, WBRK, VBRP, VBAP, LIPS ... +187 more

🔑 Keys (19)
💰 Amounts (33)
∑ Quantities (4)
📅 Dates (6)
☰ Categorical (14)
Other (21)
🔗 Relations (41)

Column Name	Description
BUKRS FK	Company Code
EKGRP FK	Purchasing Group
EKORG FK	Purchasing organization
KKBER FK	Credit control area
LFART FK	Settlement Document Type
LOGSYS FK	Logical system
SPART FK	Division
VKBUR FK	Sales office
VKGRP FK	Sales group
VKORG FK	Sales Organization
VTWEG FK	Distribution Channel
WRART FK	Settlement Process Type
ZEITP	Event for which updating should take place
LFGRU FK	Activity Reason for Document Creation
LTSNR FK	Supplier Subrange
MATNR FK	Material Number
POSNR	Document Item
WBELN	Document Number
WERKS FK	Plant

Column Name	Description
💲 Currency of Settlement Document (WAERL):
GSKTO	Amount eligible for cash discount in document currency
GSKTOD	Amount eligible for cash discount in document currency
MWSBK	Tax Amount in Document Currency
MWSBKD	Tax Amount in Document Currency (Customer-Side)
NAVNK	Non-deductible input tax
BONBA	Rebate Basis 1
BONBAD	Rebate Basis 1
BRTWR	Gross Amount of the Item in Document Currency
BRTWRD	Gross Amount of Item in Document Currency (Customer-Side)
EFFWR	Effective Amount of Item
EFFWRD	Effective Value of the Item (Customer-Side)
KZWI1	Subtotal 1 from Pricing Procedure for Price Element
KZWI1D	Subtotal 1 from Pricing Procedure for Price Element
KZWI2	Subtotal 2 from Pricing Procedure for Price Element
KZWI2D	Subtotal 2 from Pricing Procedure for Price Element
KZWI3	Subtotal 3 from Pricing Procedure for Price Element
KZWI3D	Subtotal 3 from Pricing Procedure for Price Element
KZWI4	Subtotal 4 from Pricing Procedure for Price Element
KZWI4D	Subtotal 4 from Pricing Procedure for Price Element
KZWI5	Subtotal 5 from Pricing Procedure for Price Element
KZWI5D	Subtotal 5 from Pricing Procedure for Price Element
KZWI6	Subtotal 6 from Pricing Procedure for Price Element
KZWI6D	Subtotal 6 from Pricing Procedure for Price Element
MWSBP	Tax Amount in Document Currency
MWSBPD	Tax Amount in Document Currency (Customer-Side)
NAVNW	Non-deductible input tax
NETWR	Net Amount of the Item in Document Currency
NETWRD	Net Amount of the Item in Document Currency (Customer-Side)
SKFBP	Amount eligible for cash discount in document currency
SKFBPD	Amount Eligible for Cash Discount in Doc. Curr. (Cust.-Side)
💲 Local Currency (HWAER):
MWERT_IM	Inventory Value in Home Currency
MWERT_PR	Price Difference Value in Home Currency
MWERT_UM	Revaluation Value on Back-Posting to a Previous Period

Column Name	Description
📏 Weight Unit (GEWEI):
BRGEW	Gross Weight
NTGEW	Net Weight
📏 Unit of Measure of Settlement Management Doc Item Quantity (WFKME):
MENGE	Quantity of Settlement Management Document Item
📏 Volume unit (VOLEH):
VOLUM	Volume

Column Name	Description
BLDAT	Document Date in Settlement Management Document
WFDAT	Posting Date
WFDAT_RL	Posting Date for the Settlement Document List
WKURS_DAT	Exchange Rate Date in Settlement Management
ERDAT	Date on which the record was created
PRSDT	Date for Pricing and Exchange Rate

Column Name	Description
ROCANCEL	Indicator: Cancel Data Record	Show values
ABART	Settlement Category	Show values
FKSTO	Settlement Management Document is Reversed	Show values
FKSTO_PART	Partial Reversal	Show values
FKSTO_PARTY	Reversed Partner	Show values
LFTYP	Settlement Document Category	Show values
NARVF	Settlement Management Docment Rel. for Subsequent Settlement	Show values
POST_PARTY	Posting Partner	Show values
SETTLE_CATEGORY	Settlement Classification Category	Show values
WBTYP	Settlement Process Category	Show values
WDTYP	Settlement Management Document Category	Show values
WRTYP	Entry Category for Logistics Data	Show values
CONTRACT_TYPE	Contract Category of Related Contract	Show values
ITEMCAT	Item Category	Show values

Column Name	Description	Domain name
SETTLE_DOC	Settlement Document of planned Trading Expenses	WBELN
WKURS	Exchange Rate	UKURS
CONTRACT	Related Contract in the Settlement Management Doc.	WCONTRACT
EKKOL	Condition Group with Supplier	CHAR4
FPUMN	Denominator for Converting Billing UoM to Billing Price UoM	UMBSZ
FPUMZ	Numerator for Converting Billing UoM to Billing Price UoM	UMBSZ
KOSTL	Cost Center	KOSTL
MATBF	Material in Respect of Which Stock is Managed	MATNR
PEINH	Price Unit of Settlement Management Document Item	DEC5
PRCTR	Profit Center	PRCTR
UMREN	Denominator Converting Qty in Settlement Doc. to Base Unit	UMBSN
UMREZ	Numerator Converting Qty in Settlement Document to Base Unit	UMBSZ
WBELN_V	Preceding Document of the Settlement Management Document	CHAR10
PERIV	Fiscal Year Variant	PERIV
ANZRG	Key figure: Number of payment requests	MCZAEHLER
ANZLF	Key figure: Number of vendor billing documents	MCZAEHLER
ANZCS	Key Figure: Number of Customer Settlements	MCZAEHLER
ANZPOSRL	Key figure: Number of documents in request lists (payment)	MCZAEHLER
ANZPOSLF	Key figure: No. of vendor billing document items	MCZAEHLER
ANZPOSRG	Key figure: Number of payment request items	MCZAEHLER
ANZPOSCS	Key Figure: Number of Line Items in Customer Settlement	MCZAEHLER

Master Data Relations	Join Conditions
Promotion Client Promotion	`2LIS_45_ITM.MANDT == WAKH.MANDT` `2LIS_45_ITM.AKTNR == WAKH.AKTNR`
Company Code Client Company Code	`2LIS_45_ITM.MANDT == T001.MANDT` `2LIS_45_ITM.BUKRS == T001.BUKRS`
Batch Number Client Batch Number Material Number	`2LIS_45_ITM.MANDT == MCH1.MANDT` `2LIS_45_ITM.CHARG == MCH1.CHARG` `2LIS_45_ITM.MATNR == MCH1.MATNR`
Address of One-Time Customer Client ? Address of One-Time Customer Posting Date	`2LIS_45_ITM.MANDT == ADRC.CLIENT` `2LIS_45_ITM.[column in domain "AD_NATION"] == ADRC.NATION` `2LIS_45_ITM.CPDK_ADDR == ADRC.ADDRNUMBER` `2LIS_45_ITM.WFDAT == ADRC.DATE_FROM`
Purchasing Group Client Purchasing Group	`2LIS_45_ITM.MANDT == T024.MANDT` `2LIS_45_ITM.EKGRP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`2LIS_45_ITM.MANDT == T024E.MANDT` `2LIS_45_ITM.EKORG == T024E.EKORG`
Settlement Management Document Item Price Unit Client Settlement Management Document Item Price Unit	`2LIS_45_ITM.MANDT == T006.MANDT` `2LIS_45_ITM.FPRME == T006.MSEHI`
Weight Unit Client Weight Unit	`2LIS_45_ITM.MANDT == T006.MANDT` `2LIS_45_ITM.GEWEI == T006.MSEHI`
Business Area Client Business Area	`2LIS_45_ITM.MANDT == TGSB.MANDT` `2LIS_45_ITM.GSBER == TGSB.GSBER`
Credit control area Client Credit control area	`2LIS_45_ITM.MANDT == T014.MANDT` `2LIS_45_ITM.KKBER == T014.KKBER`
Controlling Area Client Controlling Area	`2LIS_45_ITM.MANDT == TKA01.MANDT` `2LIS_45_ITM.KOKRS == TKA01.KOKRS`
Prior Supplier Client Prior Supplier	`2LIS_45_ITM.MANDT == LFA1.MANDT` `2LIS_45_ITM.KOLIF == LFA1.LIFNR`
Bill-to Party Client Bill-to Party	`2LIS_45_ITM.MANDT == KNA1.MANDT` `2LIS_45_ITM.KUNRE == KNA1.KUNNR`
Payer Client Payer	`2LIS_45_ITM.MANDT == KNA1.MANDT` `2LIS_45_ITM.KUNRG == KNA1.KUNNR`
Exchange Rate Type Client Exchange Rate Type	`2LIS_45_ITM.MANDT == TCURV.MANDT` `2LIS_45_ITM.KURST == TCURV.KURST`
Supplying Country/Region Client Supplying Country/Region	`2LIS_45_ITM.MANDT == T005.MANDT` `2LIS_45_ITM.LANDL == T005.LAND1`
Settlement Document Type Client Settlement Document Type	`2LIS_45_ITM.MANDT == TMFK.MANDT` `2LIS_45_ITM.LFART == TMFK.LFART`
Activity Reason for Document Creation Client Activity Reason for Document Creation	`2LIS_45_ITM.MANDT == TMLFG.MANDT` `2LIS_45_ITM.LFGRU == TMLFG.LFGRU`
Different Invoicing Party Client Different Invoicing Party	`2LIS_45_ITM.MANDT == LFA1.MANDT` `2LIS_45_ITM.LIFRE == LFA1.LIFNR`
Payee Client Payee	`2LIS_45_ITM.MANDT == LFA1.MANDT` `2LIS_45_ITM.LNRZB == LFA1.LIFNR`
Logical system	`2LIS_45_ITM.LOGSYS == TBDLS.LOGSYS`
Supplier Subrange Client Prior Supplier Supplier Subrange	`2LIS_45_ITM.MANDT == WYT1.MANDT` `2LIS_45_ITM.KOLIF == WYT1.LIFNR` `2LIS_45_ITM.LTSNR == WYT1.LTSNR`
Material Group Client Material Group	`2LIS_45_ITM.MANDT == T023.MANDT` `2LIS_45_ITM.MATKL == T023.MATKL`
Material Number Client Material Number	`2LIS_45_ITM.MANDT == MARA.MANDT` `2LIS_45_ITM.MATNR == MARA.MATNR`
Base Unit of Measure Client Base Unit of Measure	`2LIS_45_ITM.MANDT == T006.MANDT` `2LIS_45_ITM.MEINS == T006.MSEHI`
Material type Client Material type	`2LIS_45_ITM.MANDT == T134.MANDT` `2LIS_45_ITM.MTART == T134.MTART`
Tax Code (Output Tax) ? Client Tax Code (Output Tax)	`2LIS_45_ITM.[column in domain "KALSM_D"] == T007A.KALSM` `2LIS_45_ITM.MANDT == T007A.MANDT` `2LIS_45_ITM.MWSK2 == T007A.MWSKZ`
Tax Code (Input Tax) ? Client Tax Code (Input Tax)	`2LIS_45_ITM.[column in domain "KALSM_D"] == T007A.KALSM` `2LIS_45_ITM.MANDT == T007A.MANDT` `2LIS_45_ITM.MWSKZ == T007A.MWSKZ`
Division Client Division	`2LIS_45_ITM.MANDT == TSPA.MANDT` `2LIS_45_ITM.SPART == TSPA.SPART`
Update Group for statistics update Client Update Group for statistics update	`2LIS_45_ITM.MANDT == TMCB.MANDT` `2LIS_45_ITM.STAFO == TMCB.STAFO`
Tax Jurisdiction ? Client Tax Jurisdiction	`2LIS_45_ITM.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `2LIS_45_ITM.MANDT == TTXJ.MANDT` `2LIS_45_ITM.TXJCD == TTXJ.TXJCD`
Check Sales Office Client Sales office	`2LIS_45_ITM.MANDT == TVBUR.MANDT` `2LIS_45_ITM.VKBUR == TVBUR.VKBUR`
Check Sales Group Client Sales group	`2LIS_45_ITM.MANDT == TVKGR.MANDT` `2LIS_45_ITM.VKGRP == TVKGR.VKGRP`
Sales Organization Client Sales Organization	`2LIS_45_ITM.MANDT == TVKO.MANDT` `2LIS_45_ITM.VKORG == TVKO.VKORG`
Volume unit Client Volume unit	`2LIS_45_ITM.MANDT == T006.MANDT` `2LIS_45_ITM.VOLEH == T006.MSEHI`
Distribution Channel Client Distribution Channel	`2LIS_45_ITM.MANDT == TVTW.MANDT` `2LIS_45_ITM.VTWEG == TVTW.VTWEG`
Currency of Settlement Document Client Currency of Settlement Document	`2LIS_45_ITM.MANDT == TCURC.MANDT` `2LIS_45_ITM.WAERL == TCURC.WAERS`
Plant Client Plant	`2LIS_45_ITM.MANDT == T001W.MANDT` `2LIS_45_ITM.WERKS == T001W.WERKS`
Unit of Measure of Settlement Management Doc Item Quantity Client Unit of Measure of Settlement Management Doc Item Quantity	`2LIS_45_ITM.MANDT == T006.MANDT` `2LIS_45_ITM.WFKME == T006.MSEHI`
Settlement Process Type Client Settlement Process Type	`2LIS_45_ITM.MANDT == TMZR.MANDT` `2LIS_45_ITM.WRART == TMZR.WRART`
Statistics Currency Client Statistics Currency	`2LIS_45_ITM.MANDT == TCURC.MANDT` `2LIS_45_ITM.WSTWAE == TCURC.WAERS`