2LIS_45_LST

Agency document: Remuneration list | #TRAN | Extraction method: F1 | Delta: ABR | Component: Agency Business
Tables used: WBRK, VBRP, WBRL, VBAP, VBRK ... +187 more
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
LFGRU FK Activity Reason for Document Creation
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
LOGSYS FK Logical system
POSNR Item in List
WBELN FK Document Number of Settlement Document List
Column Name Description
💲 Currency of Settlement Document (WAERL):
BRTWR Gross Settlement Amount in Document Currency
BRTWRD Gross Settlement Amount in Document Currency (Customer-Side)
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)
KWERT_RL Value of the Settlement Document List Conditions
MWSBP Tax Amount in Document Currency (Supplier-Side)
MWSBP_RL Tax of Settlement Document List Conditions
NAVNW Non-deductible input tax
NETWR New Value of the Item in a List
Column Name Description
Column Name Description
AEDAT Last Changed On
BLDAT Document Date in Settlement Management Document
ERDAT Date on which the record was created
WFDAT Posting Date
WFDAT_RL Posting Date for the Settlement Document List
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
ABART Settlement Category Show values
COLLECTION_TYPE Document Summarization Category Show values
CONTRACT_TYPE Contract Category of Related Contract Show values
FKSTO_PART Partial Reversal Show values
FKSTO_PARTY Reversed Partner 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
LFTYP Settlement Document Category Show values
Column Name Description Domain name
CONTRACT Related Contract in the Settlement Management Doc. WCONTRACT
LFART_RL Settlement Document Type for Settlement Document List WFART
SETTLE_DOC Settlement Document of planned Trading Expenses WBELN
WKURS Exchange Rate UKURS
PERIV Fiscal Year Variant PERIV
ANZVGRL Key Figure: No. of Documents in Remuneration Lists (Payment) MCZAEHLER
ANZVGLF Key figure: no. of documents in invoice lists (VBD) MCZAEHLER
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • 2LIS_45_LST.MANDT == T001.MANDT
  • 2LIS_45_LST.BUKRS == T001.BUKRS
Address of One-Time Customer
  • Client
  • ?
  • Address of One-Time Customer
  • Posting Date
  • 2LIS_45_LST.MANDT == ADRC.CLIENT
  • 2LIS_45_LST.[column in domain "AD_NATION"] == ADRC.NATION
  • 2LIS_45_LST.CPDK_ADDR == ADRC.ADDRNUMBER
  • 2LIS_45_LST.WFDAT == ADRC.DATE_FROM
Purchasing Group
  • Client
  • Purchasing Group
  • 2LIS_45_LST.MANDT == T024.MANDT
  • 2LIS_45_LST.EKGRP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • 2LIS_45_LST.MANDT == T024E.MANDT
  • 2LIS_45_LST.EKORG == T024E.EKORG
Credit control area
  • Client
  • Credit control area
  • 2LIS_45_LST.MANDT == T014.MANDT
  • 2LIS_45_LST.KKBER == T014.KKBER
Bill-to Party
  • Client
  • Bill-to Party
  • 2LIS_45_LST.MANDT == KNA1.MANDT
  • 2LIS_45_LST.KUNRE == KNA1.KUNNR
Payer
  • Client
  • Payer
  • 2LIS_45_LST.MANDT == KNA1.MANDT
  • 2LIS_45_LST.KUNRG == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_45_LST.MANDT == TCURV.MANDT
  • 2LIS_45_LST.KURST == TCURV.KURST
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • 2LIS_45_LST.MANDT == T005.MANDT
  • 2LIS_45_LST.LANDL == T005.LAND1
Settlement Document Type
  • Client
  • Settlement Document Type
  • 2LIS_45_LST.MANDT == TMFK.MANDT
  • 2LIS_45_LST.LFART == TMFK.LFART
Activity Reason for Document Creation
  • Client
  • Activity Reason for Document Creation
  • 2LIS_45_LST.MANDT == TMLFG.MANDT
  • 2LIS_45_LST.LFGRU == TMLFG.LFGRU
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • 2LIS_45_LST.MANDT == LFA1.MANDT
  • 2LIS_45_LST.LIFRE == LFA1.LIFNR
Payee
  • Client
  • Payee
  • 2LIS_45_LST.MANDT == LFA1.MANDT
  • 2LIS_45_LST.LNRZB == LFA1.LIFNR
Logical system 2LIS_45_LST.LOGSYS == TBDLS.LOGSYS
Division
  • Client
  • Division
  • 2LIS_45_LST.MANDT == TSPA.MANDT
  • 2LIS_45_LST.SPART == TSPA.SPART
Update Group for statistics update
  • Client
  • Update Group for statistics update
  • 2LIS_45_LST.MANDT == TMCB.MANDT
  • 2LIS_45_LST.STAFO == TMCB.STAFO
Check Sales Office
  • Client
  • Sales office
  • 2LIS_45_LST.MANDT == TVBUR.MANDT
  • 2LIS_45_LST.VKBUR == TVBUR.VKBUR
Check Sales Group
  • Client
  • Sales group
  • 2LIS_45_LST.MANDT == TVKGR.MANDT
  • 2LIS_45_LST.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_45_LST.MANDT == TVKO.MANDT
  • 2LIS_45_LST.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_45_LST.MANDT == TVTW.MANDT
  • 2LIS_45_LST.VTWEG == TVTW.VTWEG
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • 2LIS_45_LST.MANDT == TCURC.MANDT
  • 2LIS_45_LST.WAERL == TCURC.WAERS
Settlement Process Type
  • Client
  • Settlement Process Type
  • 2LIS_45_LST.MANDT == TMZR.MANDT
  • 2LIS_45_LST.WRART == TMZR.WRART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_45_LST.MANDT == TCURC.MANDT
  • 2LIS_45_LST.WSTWAE == TCURC.WAERS