2LIS_45_VDLST

null | #TRAN | Extraction method: F1 | Delta: ABR | Component: Agency Business

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

🔑 Keys (18)
💰 Amounts (17)
∑ Quantities (7)
📅 Dates (13)
☰ Categorical (23)
Other (44)
🔗 Relations (56)

Column Name	Description
BUKRS FK	Company Code
EKGRP FK	Purchasing Group
EKORG FK	Purchasing organization
KAPPL FK	Application
KKBER FK	Credit control area
LFART FK	Settlement Document Type
MANDT FK	Client
SPART FK	Division
VKORG FK	Sales Organization
VTWEG FK	Distribution Channel
WBELN	Document Number
WRART FK	Settlement Process Type
ZTERM	Terms of payment key
LFGRU FK	Activity Reason for Document Creation
LTSNR FK	Supplier Subrange
MATNR FK	Material Number
POSNR	Document Item
WERKS FK	Plant

Column Name	Description
💲 Currency of Settlement Document (WAERL):
BONBA	Rebate Basis 1
BRTWR	Gross Amount of the Item in Document Currency
EFFWR	Effective Amount of Item
KZWI1	Subtotal 1 from Pricing Procedure for Price Element
KZWI2	Subtotal 2 from Pricing Procedure for Price Element
KZWI3	Subtotal 3 from Pricing Procedure for Price Element
KZWI4	Subtotal 4 from Pricing Procedure for Price Element
KZWI5	Subtotal 5 from Pricing Procedure for Price Element
KZWI6	Subtotal 6 from Pricing Procedure for Price Element
MWSBP	Tax Amount in Document Currency
NAVNW	Non-deductible input tax
NETPR	Net Price in Document Currency
NETWR	Net Amount of the Item in Document Currency
SKFBP	Amount eligible for cash discount in document currency
💲 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
BRGEW_SINGLE	Gross weight
NTGEW	Net Weight
NTGEW_SINGLE	Net weight
📏 Unit of Measure of Settlement Management Doc Item Quantity (WFKME):
MENGE	Quantity of Settlement Management Document Item
📏 Volume unit (VOLEH):
VOLUM	Volume
VOLUM_SINGLE	Volume

Column Name	Description
ERDAT_L	Date on which the record was created
VALDT_L	Fixed Value Date (Supplier)
WFDAT_L	Posting Date
WKURS_DAT_L	Translation date
AEDAT	Last Changed On
BLDAT	Document Date in Settlement Management Document
VALDT	Fixed Value Date (Supplier)
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
ERZET	Entry time
PRSDT	Date for Pricing and Exchange Rate

Column Name	Description
ROCANCEL	Indicator: Cancel Data Record	Show values
ABART_L	Settlement Category	Show values
FKSTO_L	Billing document is canceled	Show values
FKSTO_PARTY_L	Reversed Partner	Show values
FKSTO_PART_L	Partial Reversal	Show values
RFBSK_L	Posting Status for Transfer to Financial Accounting	Show values
WDTYP_L	Settlement Management Document Category	Show values
ABART	Settlement Category	Show values
COLLECTION_TYPE	Document Summarization Category	Show values
FKSTO	Settlement Management Document is Reversed	Show values
KUFIX	Indicator for Fixed Exchange Rate	Show values
LFTYP	Settlement Document Category	Show values
POST_PARTY	Posting Partner	Show values
RFBSK	Posting Status for Transfer to Financial Accounting	Show values
SETTLE_CATEGORY	Settlement Classification 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
FTYPV_V	Document Category of Preceding Document	Show values
ITEMCAT	Item Category	Show values
KOWRR	Statistical Property of Settlement Management Item	Show values
SKTOF	Cash Discount Indicator	Show values
STATUS	Settlement Management Document Status for BW	Show values

Column Name	Description	Domain name
KIDNO_L	Payment Reference	CHAR30
POSNR_L	Item in List	WPOSNR_RL
VALTG_L	Additional Value Days (Supplier)	TAGE2
WBELN_L	Document Number	WBELN
WKURS_L	Exchange Rate	KURSP
WKURS_P1_L	Exchange Rate of Supplier Payment Currency	KURSP
XBLNR_L	Reference Document Number	XBLNR1
ZBD1P_L	Cash discount percentage 1	PRZ23
ZBD1T_L	Cash (Prompt Payment) Discount Days	ZBDXT
ZBD2P_L	Cash discount percentage 1	PRZ23
ZBD2T_L	Cash (Prompt Payment) Discount Days	ZBDXT
ZBD3T_L	Net Payment Terms Period	ZBDXT
ZTERM_L	Terms of payment key	ZTERM
ZUONR_L	Assignment number	ZUONR
DIEKZ	Service Indicator (Foreign Payment)	DIEKZ
KIDNO	Payment Reference	CHAR30
SETTLE_DOC	Settlement Document of planned Trading Expenses	WBELN
VALTG	Additional Value Days (Supplier)	TAGE2
WKURS	Exchange Rate	UKURS
WKURS_P1	Exchange Rate of Supplier Payment Currency	KURSP
XBLNR	Reference Document Number	XBLNR1
ZBD1P	Cash discount percentage 1	PRZ23
ZBD1T	Cash (Prompt Payment) Discount Days	ZBDXT
ZBD2P	Cash Discount Percentage 2	PRZ23
ZBD2T	Cash discount days 2	ZBDXT
ZBD3T	Net Payment Terms Period	ZBDXT
ZUONR	Assignment number	ZUONR
ARKTX	Short Text	TEXT40
BONUS	Settlement Group 1 (Purchasing)	EBONU
CONTRACT	Related Contract in the Settlement Management Doc.	WCONTRACT
ERNAM	Name of Person Responsible for Creating the Object	USNAM
FPUMN	Denominator for Converting Billing UoM to Billing Price UoM	UMBSZ
FPUMZ	Numerator for Converting Billing UoM to Billing Price UoM	UMBSZ
GJAHRV	Fiscal Year	GJAHR
IDNLF	Material Number Used by Supplier	IDNEX
KOSTL	Cost Center	KOSTL
MATBF	Material in Respect of Which Stock is Managed	MATNR
PEINH	Price Unit of Settlement Management Document Item	DEC5
POSNR_V	Preceding Document Item in the Settlement Management Doc.	NUMC6
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
UPDKZ	Update indicator	UPDKZ
WBELN_V	Preceding Document of the Settlement Management Document	CHAR10

Master Data Relations	Join Conditions
Promotion Promotion Client	`2LIS_45_VDLST.AKTNR == WAKH.AKTNR` `2LIS_45_VDLST.MANDT == WAKH.MANDT`
Company Code Company Code Client	`2LIS_45_VDLST.BUKRS == T001.BUKRS` `2LIS_45_VDLST.MANDT == T001.MANDT`
Valuation Type Valuation Type Client	`2LIS_45_VDLST.BWTAR == T149D.BWTAR` `2LIS_45_VDLST.MANDT == T149D.MANDT`
Valuation Category Valuation Category Client	`2LIS_45_VDLST.BWTTY == T149C.BWTTY` `2LIS_45_VDLST.MANDT == T149C.MANDT`
Batch Number Batch Number Client Material Number	`2LIS_45_VDLST.CHARG == MCH1.CHARG` `2LIS_45_VDLST.MANDT == MCH1.MANDT` `2LIS_45_VDLST.MATNR == MCH1.MATNR`
Address of One-Time Customer ? Address of One-Time Customer Client Posting Date Posting Date	`2LIS_45_VDLST.[column in domain "AD_NATION"] == ADRC.NATION` `2LIS_45_VDLST.CPDK_ADDR == ADRC.ADDRNUMBER` `2LIS_45_VDLST.MANDT == ADRC.CLIENT` `2LIS_45_VDLST.WFDAT == ADRC.DATE_FROM` `2LIS_45_VDLST.WFDAT_L == ADRC.DATE_FROM`
Purchasing Group Purchasing Group Client	`2LIS_45_VDLST.EKGRP == T024.EKGRP` `2LIS_45_VDLST.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`2LIS_45_VDLST.EKORG == T024E.EKORG` `2LIS_45_VDLST.MANDT == T024E.MANDT`
Application Status for a Settlement Management Document Application Status for a Settlement Management Document Application Status for a Settlement Management Document Client	`2LIS_45_VDLST.ESTATUS == TMPA2.ESTATUS` `2LIS_45_VDLST.ESTATUS_L == TMPA2.ESTATUS` `2LIS_45_VDLST.MANDT == TMPA2.MANDT`
Application Status for a Settlement Management Document Application Status for a Settlement Management Document Application Status for a Settlement Management Document Client	`2LIS_45_VDLST.ESTATUS == TMPA2.ESTATUS` `2LIS_45_VDLST.ESTATUS_L == TMPA2.ESTATUS` `2LIS_45_VDLST.MANDT == TMPA2.MANDT`
Settlement Management Document Item Price Unit Settlement Management Document Item Price Unit Client	`2LIS_45_VDLST.FPRME == T006.MSEHI` `2LIS_45_VDLST.MANDT == T006.MANDT`
Weight Unit Weight Unit Client	`2LIS_45_VDLST.GEWEI == T006.MSEHI` `2LIS_45_VDLST.MANDT == T006.MANDT`
Business Area Business Area Client	`2LIS_45_VDLST.GSBER == TGSB.GSBER` `2LIS_45_VDLST.MANDT == TGSB.MANDT`
Application	`2LIS_45_VDLST.KAPPL == T681A.KAPPL`
Credit control area Credit control area Client	`2LIS_45_VDLST.KKBER == T014.KKBER` `2LIS_45_VDLST.MANDT == T014.MANDT`
Controlling Area Controlling Area Client	`2LIS_45_VDLST.KOKRS == TKA01.KOKRS` `2LIS_45_VDLST.MANDT == TKA01.MANDT`
Prior Supplier Prior Supplier Client	`2LIS_45_VDLST.KOLIF == LFA1.LIFNR` `2LIS_45_VDLST.MANDT == LFA1.MANDT`
Bill-to Party Bill-to Party Client	`2LIS_45_VDLST.KUNRE == KNA1.KUNNR` `2LIS_45_VDLST.MANDT == KNA1.MANDT`
Payer Payer Client	`2LIS_45_VDLST.KUNRG == KNA1.KUNNR` `2LIS_45_VDLST.MANDT == KNA1.MANDT`
Exchange Rate Type Exchange Rate Type Client	`2LIS_45_VDLST.KURST == TCURV.KURST` `2LIS_45_VDLST.MANDT == TCURV.MANDT`
Supplying Country/Region Supplying Country/Region Client	`2LIS_45_VDLST.LANDL == T005.LAND1` `2LIS_45_VDLST.MANDT == T005.MANDT`
Settlement Document Type Settlement Document Type Settlement Document Type Client	`2LIS_45_VDLST.LFART == TMFK.LFART` `2LIS_45_VDLST.LFART_L == TMFK.LFART` `2LIS_45_VDLST.MANDT == TMFK.MANDT`
Settlement Document Type Settlement Document Type Settlement Document Type Client	`2LIS_45_VDLST.LFART == TMFK.LFART` `2LIS_45_VDLST.LFART_L == TMFK.LFART` `2LIS_45_VDLST.MANDT == TMFK.MANDT`
Activity Reason for Document Creation Activity Reason for Document Creation Activity Reason for Document Creation Client	`2LIS_45_VDLST.LFGRU == TMLFG.LFGRU` `2LIS_45_VDLST.LFGRU_L == TMLFG.LFGRU` `2LIS_45_VDLST.MANDT == TMLFG.MANDT`
Activity Reason for Document Creation Activity Reason for Document Creation Activity Reason for Document Creation Client	`2LIS_45_VDLST.LFGRU == TMLFG.LFGRU` `2LIS_45_VDLST.LFGRU_L == TMLFG.LFGRU` `2LIS_45_VDLST.MANDT == TMLFG.MANDT`
Different Invoicing Party Different Invoicing Party Different Invoicing Party Client	`2LIS_45_VDLST.LIFRE == LFA1.LIFNR` `2LIS_45_VDLST.LIFRE_L == LFA1.LIFNR` `2LIS_45_VDLST.MANDT == LFA1.MANDT`
Different Invoicing Party Different Invoicing Party Different Invoicing Party Client	`2LIS_45_VDLST.LIFRE == LFA1.LIFNR` `2LIS_45_VDLST.LIFRE_L == LFA1.LIFNR` `2LIS_45_VDLST.MANDT == LFA1.MANDT`
Payee Payee Payee Client	`2LIS_45_VDLST.LNRZB == LFA1.LIFNR` `2LIS_45_VDLST.LNRZB_L == LFA1.LIFNR` `2LIS_45_VDLST.MANDT == LFA1.MANDT`
Payee Payee Payee Client	`2LIS_45_VDLST.LNRZB == LFA1.LIFNR` `2LIS_45_VDLST.LNRZB_L == LFA1.LIFNR` `2LIS_45_VDLST.MANDT == LFA1.MANDT`
Supplier Subrange Prior Supplier Supplier Subrange Client	`2LIS_45_VDLST.KOLIF == WYT1.LIFNR` `2LIS_45_VDLST.LTSNR == WYT1.LTSNR` `2LIS_45_VDLST.MANDT == WYT1.MANDT`
State Central Bank Indicator State Central Bank Indicator Client	`2LIS_45_VDLST.LZBKZ == T015L.LZBKZ` `2LIS_45_VDLST.MANDT == T015L.MANDT`
Client	`2LIS_45_VDLST.MANDT == T000.MANDT`
Material Group	`2LIS_45_VDLST.MANDT == T023.MANDT` `2LIS_45_VDLST.MATKL == T023.MATKL`
Material Number	`2LIS_45_VDLST.MANDT == MARA.MANDT` `2LIS_45_VDLST.MATNR == MARA.MATNR`
Base Unit of Measure	`2LIS_45_VDLST.MANDT == T006.MANDT` `2LIS_45_VDLST.MEINS == T006.MSEHI`
Material type	`2LIS_45_VDLST.MANDT == T134.MANDT` `2LIS_45_VDLST.MTART == T134.MTART`
Tax Code (Input Tax) ? Client Tax Code (Input Tax)	`2LIS_45_VDLST.[column in domain "KALSM_D"] == T007A.KALSM` `2LIS_45_VDLST.MANDT == T007A.MANDT` `2LIS_45_VDLST.MWSKZ == T007A.MWSKZ`
Division	`2LIS_45_VDLST.MANDT == TSPA.MANDT` `2LIS_45_VDLST.SPART == TSPA.SPART`
Tax Jurisdiction ? Client Tax Jurisdiction	`2LIS_45_VDLST.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `2LIS_45_VDLST.MANDT == TTXJ.MANDT` `2LIS_45_VDLST.TXJCD == TTXJ.TXJCD`
Sales Organization	`2LIS_45_VDLST.MANDT == TVKO.MANDT` `2LIS_45_VDLST.VKORG == TVKO.VKORG`
Volume unit	`2LIS_45_VDLST.MANDT == T006.MANDT` `2LIS_45_VDLST.VOLEH == T006.MSEHI`
Distribution Channel	`2LIS_45_VDLST.MANDT == TVTW.MANDT` `2LIS_45_VDLST.VTWEG == TVTW.VTWEG`
Currency of Settlement Document Currency of Settlement Document Currency of Settlement Document	`2LIS_45_VDLST.MANDT == TCURC.MANDT` `2LIS_45_VDLST.WAERL == TCURC.WAERS` `2LIS_45_VDLST.WAERL_L == TCURC.WAERS`
Currency of Settlement Document Currency of Settlement Document Currency of Settlement Document	`2LIS_45_VDLST.MANDT == TCURC.MANDT` `2LIS_45_VDLST.WAERL == TCURC.WAERS` `2LIS_45_VDLST.WAERL_L == TCURC.WAERS`
Plant	`2LIS_45_VDLST.MANDT == T001W.MANDT` `2LIS_45_VDLST.WERKS == T001W.WERKS`
Unit of Measure of Settlement Management Doc Item Quantity	`2LIS_45_VDLST.MANDT == T006.MANDT` `2LIS_45_VDLST.WFKME == T006.MSEHI`
Supplier Payment Currency for Automatic Payment Supplier Payment Currency for Automatic Payment Supplier Payment Currency for Automatic Payment	`2LIS_45_VDLST.MANDT == TCURC.MANDT` `2LIS_45_VDLST.WPYCUR_P1 == TCURC.WAERS` `2LIS_45_VDLST.WPYCUR_P1_L == TCURC.WAERS`
Supplier Payment Currency for Automatic Payment Supplier Payment Currency for Automatic Payment Supplier Payment Currency for Automatic Payment	`2LIS_45_VDLST.MANDT == TCURC.MANDT` `2LIS_45_VDLST.WPYCUR_P1 == TCURC.WAERS` `2LIS_45_VDLST.WPYCUR_P1_L == TCURC.WAERS`
Settlement Process Type Settlement Process Type Settlement Process Type	`2LIS_45_VDLST.MANDT == TMZR.MANDT` `2LIS_45_VDLST.WRART == TMZR.WRART` `2LIS_45_VDLST.WRART_L == TMZR.WRART`
Settlement Process Type Settlement Process Type Settlement Process Type	`2LIS_45_VDLST.MANDT == TMZR.MANDT` `2LIS_45_VDLST.WRART == TMZR.WRART` `2LIS_45_VDLST.WRART_L == TMZR.WRART`
Statistics Currency	`2LIS_45_VDLST.MANDT == TCURC.MANDT` `2LIS_45_VDLST.WSTWAE == TCURC.WAERS`
Payment Method ? Client Payment Method Payment Method	`2LIS_45_VDLST.[column in domain "LAND1"] == T042Z.LAND1` `2LIS_45_VDLST.MANDT == T042Z.MANDT` `2LIS_45_VDLST.ZLSCH == T042Z.ZLSCH` `2LIS_45_VDLST.ZLSCH_L == T042Z.ZLSCH`
Payment Method ? Client Payment Method Payment Method	`2LIS_45_VDLST.[column in domain "LAND1"] == T042Z.LAND1` `2LIS_45_VDLST.MANDT == T042Z.MANDT` `2LIS_45_VDLST.ZLSCH == T042Z.ZLSCH` `2LIS_45_VDLST.ZLSCH_L == T042Z.ZLSCH`