2LIS_45_CDLST

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

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

🔑 Keys (19)
💰 Amounts (16)
∑ Quantities (7)
📅 Dates (12)
☰ Categorical (21)
Other (34)
🔗 Relations (55)

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
VKBUR FK	Sales office
VKGRP FK	Sales group
VKORG FK	Sales Organization
VTWEG FK	Distribution Channel
WBELN	Document Number
WRART FK	Settlement Process Type
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
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
VALDTD_L	Fixed Value Date (Customer)
WFDAT_L	Posting Date
WKURS_DAT_L	Translation date
AEDAT	Last Changed On
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
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_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
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
VALTGD_L	Additional Value Days (Customer)	TAGE2
WBELN_L	Document Number	WBELN
WKURS_L	Exchange Rate	KURSP
XBLNR_L	Reference Document Number	XBLNR1
ZBD1PD_L	Cash Discount Percentage 1 Customer	PRZ23
ZBD1TD_L	Cash Discount Period for Customer	ZBDXT
ZBD2PD_L	Cash Discount Percentage 2 Customer	PRZ23
ZBD2TD_L	Cash Discount Period 2 Customer	ZBDXT
ZBD3TD_L	Deadline for Customer Net Condition	ZBDXT
ZUONR_L	Assignment number	ZUONR
DIEKZ	Service Indicator (Foreign Payment)	DIEKZ
KIDNO	Payment Reference	CHAR30
SETTLE_DOC	Settlement Document of planned Trading Expenses	WBELN
WKURS	Exchange Rate	UKURS
XBLNR	Reference Document Number	XBLNR1
ZUONR	Assignment number	ZUONR
ARKTX	Short Text	TEXT40
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_CDLST.AKTNR == WAKH.AKTNR` `2LIS_45_CDLST.MANDT == WAKH.MANDT`
Company Code Company Code Client	`2LIS_45_CDLST.BUKRS == T001.BUKRS` `2LIS_45_CDLST.MANDT == T001.MANDT`
Batch Number Batch Number Client Material Number	`2LIS_45_CDLST.CHARG == MCH1.CHARG` `2LIS_45_CDLST.MANDT == MCH1.MANDT` `2LIS_45_CDLST.MATNR == MCH1.MATNR`
Address of One-Time Customer ? Address of One-Time Customer Client Posting Date Posting Date	`2LIS_45_CDLST.[column in domain "AD_NATION"] == ADRC.NATION` `2LIS_45_CDLST.CPDK_ADDR == ADRC.ADDRNUMBER` `2LIS_45_CDLST.MANDT == ADRC.CLIENT` `2LIS_45_CDLST.WFDAT == ADRC.DATE_FROM` `2LIS_45_CDLST.WFDAT_L == ADRC.DATE_FROM`
Purchasing Group Purchasing Group Client	`2LIS_45_CDLST.EKGRP == T024.EKGRP` `2LIS_45_CDLST.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`2LIS_45_CDLST.EKORG == T024E.EKORG` `2LIS_45_CDLST.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_CDLST.ESTATUS == TMPA2.ESTATUS` `2LIS_45_CDLST.ESTATUS_L == TMPA2.ESTATUS` `2LIS_45_CDLST.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_CDLST.ESTATUS == TMPA2.ESTATUS` `2LIS_45_CDLST.ESTATUS_L == TMPA2.ESTATUS` `2LIS_45_CDLST.MANDT == TMPA2.MANDT`
Settlement Management Document Item Price Unit Settlement Management Document Item Price Unit Client	`2LIS_45_CDLST.FPRME == T006.MSEHI` `2LIS_45_CDLST.MANDT == T006.MANDT`
Weight Unit Weight Unit Client	`2LIS_45_CDLST.GEWEI == T006.MSEHI` `2LIS_45_CDLST.MANDT == T006.MANDT`
Business Area Business Area Client	`2LIS_45_CDLST.GSBER == TGSB.GSBER` `2LIS_45_CDLST.MANDT == TGSB.MANDT`
Application	`2LIS_45_CDLST.KAPPL == T681A.KAPPL`
Credit control area Credit control area Client	`2LIS_45_CDLST.KKBER == T014.KKBER` `2LIS_45_CDLST.MANDT == T014.MANDT`
Controlling Area Controlling Area Client	`2LIS_45_CDLST.KOKRS == TKA01.KOKRS` `2LIS_45_CDLST.MANDT == TKA01.MANDT`
Prior Supplier Prior Supplier Client	`2LIS_45_CDLST.KOLIF == LFA1.LIFNR` `2LIS_45_CDLST.MANDT == LFA1.MANDT`
Bill-to Party Bill-to Party Bill-to Party Client	`2LIS_45_CDLST.KUNRE == KNA1.KUNNR` `2LIS_45_CDLST.KUNRE_L == KNA1.KUNNR` `2LIS_45_CDLST.MANDT == KNA1.MANDT`
Bill-to Party Bill-to Party Bill-to Party Client	`2LIS_45_CDLST.KUNRE == KNA1.KUNNR` `2LIS_45_CDLST.KUNRE_L == KNA1.KUNNR` `2LIS_45_CDLST.MANDT == KNA1.MANDT`
Payer Payer Payer Client	`2LIS_45_CDLST.KUNRG == KNA1.KUNNR` `2LIS_45_CDLST.KUNRG_L == KNA1.KUNNR` `2LIS_45_CDLST.MANDT == KNA1.MANDT`
Payer Payer Payer Client	`2LIS_45_CDLST.KUNRG == KNA1.KUNNR` `2LIS_45_CDLST.KUNRG_L == KNA1.KUNNR` `2LIS_45_CDLST.MANDT == KNA1.MANDT`
Exchange Rate Type Exchange Rate Type Client	`2LIS_45_CDLST.KURST == TCURV.KURST` `2LIS_45_CDLST.MANDT == TCURV.MANDT`
Supplying Country/Region Supplying Country/Region Client	`2LIS_45_CDLST.LANDL == T005.LAND1` `2LIS_45_CDLST.MANDT == T005.MANDT`
Settlement Document Type Settlement Document Type Settlement Document Type Client	`2LIS_45_CDLST.LFART == TMFK.LFART` `2LIS_45_CDLST.LFART_L == TMFK.LFART` `2LIS_45_CDLST.MANDT == TMFK.MANDT`
Settlement Document Type Settlement Document Type Settlement Document Type Client	`2LIS_45_CDLST.LFART == TMFK.LFART` `2LIS_45_CDLST.LFART_L == TMFK.LFART` `2LIS_45_CDLST.MANDT == TMFK.MANDT`
Activity Reason for Document Creation Activity Reason for Document Creation Activity Reason for Document Creation Client	`2LIS_45_CDLST.LFGRU == TMLFG.LFGRU` `2LIS_45_CDLST.LFGRU_L == TMLFG.LFGRU` `2LIS_45_CDLST.MANDT == TMLFG.MANDT`
Activity Reason for Document Creation Activity Reason for Document Creation Activity Reason for Document Creation Client	`2LIS_45_CDLST.LFGRU == TMLFG.LFGRU` `2LIS_45_CDLST.LFGRU_L == TMLFG.LFGRU` `2LIS_45_CDLST.MANDT == TMLFG.MANDT`
Different Invoicing Party Different Invoicing Party Client	`2LIS_45_CDLST.LIFRE == LFA1.LIFNR` `2LIS_45_CDLST.MANDT == LFA1.MANDT`
Payee Payee Payee Client	`2LIS_45_CDLST.LNRZB == LFA1.LIFNR` `2LIS_45_CDLST.LNRZB_L == LFA1.LIFNR` `2LIS_45_CDLST.MANDT == LFA1.MANDT`
Payee Payee Payee Client	`2LIS_45_CDLST.LNRZB == LFA1.LIFNR` `2LIS_45_CDLST.LNRZB_L == LFA1.LIFNR` `2LIS_45_CDLST.MANDT == LFA1.MANDT`
Supplier Subrange Prior Supplier Supplier Subrange Client	`2LIS_45_CDLST.KOLIF == WYT1.LIFNR` `2LIS_45_CDLST.LTSNR == WYT1.LTSNR` `2LIS_45_CDLST.MANDT == WYT1.MANDT`
State Central Bank Indicator State Central Bank Indicator Client	`2LIS_45_CDLST.LZBKZ == T015L.LZBKZ` `2LIS_45_CDLST.MANDT == T015L.MANDT`
Client	`2LIS_45_CDLST.MANDT == T000.MANDT`
Material Group	`2LIS_45_CDLST.MANDT == T023.MANDT` `2LIS_45_CDLST.MATKL == T023.MATKL`
Material Number	`2LIS_45_CDLST.MANDT == MARA.MANDT` `2LIS_45_CDLST.MATNR == MARA.MATNR`
Base Unit of Measure	`2LIS_45_CDLST.MANDT == T006.MANDT` `2LIS_45_CDLST.MEINS == T006.MSEHI`
Material type	`2LIS_45_CDLST.MANDT == T134.MANDT` `2LIS_45_CDLST.MTART == T134.MTART`
Tax Code (Input Tax) ? Client Tax Code (Input Tax)	`2LIS_45_CDLST.[column in domain "KALSM_D"] == T007A.KALSM` `2LIS_45_CDLST.MANDT == T007A.MANDT` `2LIS_45_CDLST.MWSKZ == T007A.MWSKZ`
Division	`2LIS_45_CDLST.MANDT == TSPA.MANDT` `2LIS_45_CDLST.SPART == TSPA.SPART`
Tax Jurisdiction ? Client Tax Jurisdiction	`2LIS_45_CDLST.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `2LIS_45_CDLST.MANDT == TTXJ.MANDT` `2LIS_45_CDLST.TXJCD == TTXJ.TXJCD`
Check Sales Office	`2LIS_45_CDLST.MANDT == TVBUR.MANDT` `2LIS_45_CDLST.VKBUR == TVBUR.VKBUR`
Check Sales Group	`2LIS_45_CDLST.MANDT == TVKGR.MANDT` `2LIS_45_CDLST.VKGRP == TVKGR.VKGRP`
Sales Organization	`2LIS_45_CDLST.MANDT == TVKO.MANDT` `2LIS_45_CDLST.VKORG == TVKO.VKORG`
Volume unit	`2LIS_45_CDLST.MANDT == T006.MANDT` `2LIS_45_CDLST.VOLEH == T006.MSEHI`
Distribution Channel	`2LIS_45_CDLST.MANDT == TVTW.MANDT` `2LIS_45_CDLST.VTWEG == TVTW.VTWEG`
Currency of Settlement Document Currency of Settlement Document Currency of Settlement Document	`2LIS_45_CDLST.MANDT == TCURC.MANDT` `2LIS_45_CDLST.WAERL == TCURC.WAERS` `2LIS_45_CDLST.WAERL_L == TCURC.WAERS`
Currency of Settlement Document Currency of Settlement Document Currency of Settlement Document	`2LIS_45_CDLST.MANDT == TCURC.MANDT` `2LIS_45_CDLST.WAERL == TCURC.WAERS` `2LIS_45_CDLST.WAERL_L == TCURC.WAERS`
Plant	`2LIS_45_CDLST.MANDT == T001W.MANDT` `2LIS_45_CDLST.WERKS == T001W.WERKS`
Unit of Measure of Settlement Management Doc Item Quantity	`2LIS_45_CDLST.MANDT == T006.MANDT` `2LIS_45_CDLST.WFKME == T006.MSEHI`
Customer Payment Currency for Automatic Payment	`2LIS_45_CDLST.MANDT == TCURC.MANDT` `2LIS_45_CDLST.WPYCUR_P2 == TCURC.WAERS`
Settlement Process Type Settlement Process Type Settlement Process Type	`2LIS_45_CDLST.MANDT == TMZR.MANDT` `2LIS_45_CDLST.WRART == TMZR.WRART` `2LIS_45_CDLST.WRART_L == TMZR.WRART`
Settlement Process Type Settlement Process Type Settlement Process Type	`2LIS_45_CDLST.MANDT == TMZR.MANDT` `2LIS_45_CDLST.WRART == TMZR.WRART` `2LIS_45_CDLST.WRART_L == TMZR.WRART`
Statistics Currency	`2LIS_45_CDLST.MANDT == TCURC.MANDT` `2LIS_45_CDLST.WSTWAE == TCURC.WAERS`
Customer Payment Method ? Client Customer Payment Method	`2LIS_45_CDLST.[column in domain "LAND1"] == T042Z.LAND1` `2LIS_45_CDLST.MANDT == T042Z.MANDT` `2LIS_45_CDLST.ZLSCHD_L == T042Z.ZLSCH`