2LIS_45_PDLST

null | #TRAN | Extraction method: F1 | Delta: ABR | Component: Agency Business
Tables used: WBRK, WBRP, VBRP, LIPS, VBAP ... +187 more
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):
BONBAD Rebate Basis 1
BRTWRD Gross Amount of Item in Document Currency (Customer-Side)
EFFWRD Effective Value of the Item (Customer-Side)
KZWI1D Subtotal 1 from Pricing Procedure for Price Element
KZWI2D Subtotal 2 from Pricing Procedure for Price Element
KZWI3D Subtotal 3 from Pricing Procedure for Price Element
KZWI4D Subtotal 4 from Pricing Procedure for Price Element
KZWI5D Subtotal 5 from Pricing Procedure for Price Element
KZWI6D Subtotal 6 from Pricing Procedure for Price Element
MWSBPD Tax Amount in Document Currency (Customer-Side)
NETPR Net Price in Document Currency
NETWRD Net Amount of the Item in Document Currency (Customer-Side)
SKFBPD Amount Eligible for Cash Discount in Doc. Curr. (Cust.-Side)
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
VALDTD Fixed Value Date (Customer)
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
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
VALTGD_L Additional Value Days (Customer) TAGE2
WBELN_L Document Number WBELN
WKURS_L Exchange Rate KURSP
WKURS_P2_L Exchange Rate of Customer Payment Currency 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
ZTERMD_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
VALTGD Additional Value Days (Customer) TAGE2
WKURS Exchange Rate UKURS
WKURS_P2 Exchange Rate of Customer Payment Currency KURSP
XBLNR Reference Document Number XBLNR1
ZBD1PD Cash Discount Percentage 1 Customer PRZ23
ZBD1TD Cash Discount Period for Customer ZBDXT
ZBD2PD Cash Discount Percentage 2 Customer PRZ23
ZBD2TD Cash Discount Period 2 Customer ZBDXT
ZBD3TD Deadline for Customer Net Condition ZBDXT
ZTERMD Terms of Payment Key for Customer ZTERM
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
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
Company Code
  • Company Code
  • Client
  • 2LIS_45_PDLST.BUKRS == T001.BUKRS
  • 2LIS_45_PDLST.MANDT == T001.MANDT
Batch Number
  • Batch Number
  • Client
  • Material Number
  • 2LIS_45_PDLST.CHARG == MCH1.CHARG
  • 2LIS_45_PDLST.MANDT == MCH1.MANDT
  • 2LIS_45_PDLST.MATNR == MCH1.MATNR
Address of One-Time Customer
  • ?
  • Address of One-Time Customer
  • Client
  • Posting Date
  • Posting Date
  • 2LIS_45_PDLST.[column in domain "AD_NATION"] == ADRC.NATION
  • 2LIS_45_PDLST.CPDK_ADDR == ADRC.ADDRNUMBER
  • 2LIS_45_PDLST.MANDT == ADRC.CLIENT
  • 2LIS_45_PDLST.WFDAT == ADRC.DATE_FROM
  • 2LIS_45_PDLST.WFDAT_L == ADRC.DATE_FROM
Purchasing Group
  • Purchasing Group
  • Client
  • 2LIS_45_PDLST.EKGRP == T024.EKGRP
  • 2LIS_45_PDLST.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • 2LIS_45_PDLST.EKORG == T024E.EKORG
  • 2LIS_45_PDLST.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_PDLST.ESTATUS == TMPA2.ESTATUS
  • 2LIS_45_PDLST.ESTATUS_L == TMPA2.ESTATUS
  • 2LIS_45_PDLST.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_PDLST.ESTATUS == TMPA2.ESTATUS
  • 2LIS_45_PDLST.ESTATUS_L == TMPA2.ESTATUS
  • 2LIS_45_PDLST.MANDT == TMPA2.MANDT
Settlement Management Document Item Price Unit
  • Settlement Management Document Item Price Unit
  • Client
  • 2LIS_45_PDLST.FPRME == T006.MSEHI
  • 2LIS_45_PDLST.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • 2LIS_45_PDLST.GEWEI == T006.MSEHI
  • 2LIS_45_PDLST.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • 2LIS_45_PDLST.GSBER == TGSB.GSBER
  • 2LIS_45_PDLST.MANDT == TGSB.MANDT
Application 2LIS_45_PDLST.KAPPL == T681A.KAPPL
Credit control area
  • Credit control area
  • Client
  • 2LIS_45_PDLST.KKBER == T014.KKBER
  • 2LIS_45_PDLST.MANDT == T014.MANDT
Controlling Area
  • Controlling Area
  • Client
  • 2LIS_45_PDLST.KOKRS == TKA01.KOKRS
  • 2LIS_45_PDLST.MANDT == TKA01.MANDT
Prior Supplier
  • Prior Supplier
  • Client
  • 2LIS_45_PDLST.KOLIF == LFA1.LIFNR
  • 2LIS_45_PDLST.MANDT == LFA1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • 2LIS_45_PDLST.KUNRE == KNA1.KUNNR
  • 2LIS_45_PDLST.MANDT == KNA1.MANDT
Payer
  • Payer
  • Client
  • 2LIS_45_PDLST.KUNRG == KNA1.KUNNR
  • 2LIS_45_PDLST.MANDT == KNA1.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • 2LIS_45_PDLST.KURST == TCURV.KURST
  • 2LIS_45_PDLST.MANDT == TCURV.MANDT
Settlement Document Type
  • Settlement Document Type
  • Settlement Document Type
  • Client
  • 2LIS_45_PDLST.LFART == TMFK.LFART
  • 2LIS_45_PDLST.LFART_L == TMFK.LFART
  • 2LIS_45_PDLST.MANDT == TMFK.MANDT
Settlement Document Type
  • Settlement Document Type
  • Settlement Document Type
  • Client
  • 2LIS_45_PDLST.LFART == TMFK.LFART
  • 2LIS_45_PDLST.LFART_L == TMFK.LFART
  • 2LIS_45_PDLST.MANDT == TMFK.MANDT
Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Client
  • 2LIS_45_PDLST.LFGRU == TMLFG.LFGRU
  • 2LIS_45_PDLST.LFGRU_L == TMLFG.LFGRU
  • 2LIS_45_PDLST.MANDT == TMLFG.MANDT
Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • Client
  • 2LIS_45_PDLST.LFGRU == TMLFG.LFGRU
  • 2LIS_45_PDLST.LFGRU_L == TMLFG.LFGRU
  • 2LIS_45_PDLST.MANDT == TMLFG.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • 2LIS_45_PDLST.LIFRE == LFA1.LIFNR
  • 2LIS_45_PDLST.MANDT == LFA1.MANDT
Payee
  • Payee
  • Client
  • 2LIS_45_PDLST.LNRZB == LFA1.LIFNR
  • 2LIS_45_PDLST.MANDT == LFA1.MANDT
Supplier Subrange
  • Prior Supplier
  • Supplier Subrange
  • Client
  • 2LIS_45_PDLST.KOLIF == WYT1.LIFNR
  • 2LIS_45_PDLST.LTSNR == WYT1.LTSNR
  • 2LIS_45_PDLST.MANDT == WYT1.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • 2LIS_45_PDLST.LZBKZ == T015L.LZBKZ
  • 2LIS_45_PDLST.MANDT == T015L.MANDT
Client 2LIS_45_PDLST.MANDT == T000.MANDT
Material Group
  • 2LIS_45_PDLST.MANDT == T023.MANDT
  • 2LIS_45_PDLST.MATKL == T023.MATKL
Material Number
  • 2LIS_45_PDLST.MANDT == MARA.MANDT
  • 2LIS_45_PDLST.MATNR == MARA.MATNR
Base Unit of Measure
  • 2LIS_45_PDLST.MANDT == T006.MANDT
  • 2LIS_45_PDLST.MEINS == T006.MSEHI
Material type
  • 2LIS_45_PDLST.MANDT == T134.MANDT
  • 2LIS_45_PDLST.MTART == T134.MTART
Tax Code (Output Tax)
  • ?
  • Client
  • Tax Code (Output Tax)
  • 2LIS_45_PDLST.[column in domain "KALSM_D"] == T007A.KALSM
  • 2LIS_45_PDLST.MANDT == T007A.MANDT
  • 2LIS_45_PDLST.MWSK2 == T007A.MWSKZ
Division
  • 2LIS_45_PDLST.MANDT == TSPA.MANDT
  • 2LIS_45_PDLST.SPART == TSPA.SPART
Check Sales Office
  • 2LIS_45_PDLST.MANDT == TVBUR.MANDT
  • 2LIS_45_PDLST.VKBUR == TVBUR.VKBUR
Check Sales Group
  • 2LIS_45_PDLST.MANDT == TVKGR.MANDT
  • 2LIS_45_PDLST.VKGRP == TVKGR.VKGRP
Sales Organization
  • 2LIS_45_PDLST.MANDT == TVKO.MANDT
  • 2LIS_45_PDLST.VKORG == TVKO.VKORG
Volume unit
  • 2LIS_45_PDLST.MANDT == T006.MANDT
  • 2LIS_45_PDLST.VOLEH == T006.MSEHI
Distribution Channel
  • 2LIS_45_PDLST.MANDT == TVTW.MANDT
  • 2LIS_45_PDLST.VTWEG == TVTW.VTWEG
Currency of Settlement Document
  • Currency of Settlement Document
  • Currency of Settlement Document
  • 2LIS_45_PDLST.MANDT == TCURC.MANDT
  • 2LIS_45_PDLST.WAERL == TCURC.WAERS
  • 2LIS_45_PDLST.WAERL_L == TCURC.WAERS
Currency of Settlement Document
  • Currency of Settlement Document
  • Currency of Settlement Document
  • 2LIS_45_PDLST.MANDT == TCURC.MANDT
  • 2LIS_45_PDLST.WAERL == TCURC.WAERS
  • 2LIS_45_PDLST.WAERL_L == TCURC.WAERS
Plant
  • 2LIS_45_PDLST.MANDT == T001W.MANDT
  • 2LIS_45_PDLST.WERKS == T001W.WERKS
Unit of Measure of Settlement Management Doc Item Quantity
  • 2LIS_45_PDLST.MANDT == T006.MANDT
  • 2LIS_45_PDLST.WFKME == T006.MSEHI
Customer Payment Currency for Automatic Payment
  • Customer Payment Currency for Automatic Payment
  • Customer Payment Currency for Automatic Payment
  • 2LIS_45_PDLST.MANDT == TCURC.MANDT
  • 2LIS_45_PDLST.WPYCUR_P2 == TCURC.WAERS
  • 2LIS_45_PDLST.WPYCUR_P2_L == TCURC.WAERS
Customer Payment Currency for Automatic Payment
  • Customer Payment Currency for Automatic Payment
  • Customer Payment Currency for Automatic Payment
  • 2LIS_45_PDLST.MANDT == TCURC.MANDT
  • 2LIS_45_PDLST.WPYCUR_P2 == TCURC.WAERS
  • 2LIS_45_PDLST.WPYCUR_P2_L == TCURC.WAERS
Settlement Process Type
  • Settlement Process Type
  • Settlement Process Type
  • 2LIS_45_PDLST.MANDT == TMZR.MANDT
  • 2LIS_45_PDLST.WRART == TMZR.WRART
  • 2LIS_45_PDLST.WRART_L == TMZR.WRART
Settlement Process Type
  • Settlement Process Type
  • Settlement Process Type
  • 2LIS_45_PDLST.MANDT == TMZR.MANDT
  • 2LIS_45_PDLST.WRART == TMZR.WRART
  • 2LIS_45_PDLST.WRART_L == TMZR.WRART
Statistics Currency
  • 2LIS_45_PDLST.MANDT == TCURC.MANDT
  • 2LIS_45_PDLST.WSTWAE == TCURC.WAERS
Customer Payment Method
  • ?
  • Client
  • Customer Payment Method
  • Customer Payment Method
  • 2LIS_45_PDLST.[column in domain "LAND1"] == T042Z.LAND1
  • 2LIS_45_PDLST.MANDT == T042Z.MANDT
  • 2LIS_45_PDLST.ZLSCHD == T042Z.ZLSCH
  • 2LIS_45_PDLST.ZLSCHD_L == T042Z.ZLSCH
Customer Payment Method
  • ?
  • Client
  • Customer Payment Method
  • Customer Payment Method
  • 2LIS_45_PDLST.[column in domain "LAND1"] == T042Z.LAND1
  • 2LIS_45_PDLST.MANDT == T042Z.MANDT
  • 2LIS_45_PDLST.ZLSCHD == T042Z.ZLSCH
  • 2LIS_45_PDLST.ZLSCHD_L == T042Z.ZLSCH