2LIS_45_HDR

Agency document header data | #TRAN | Extraction method: F1 | Delta: ABR | Component: Agency Business
Tables used: WBRK, VBRP, VBAP, VBRK, VBAK ... +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
LOGSYS FK Logical system
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
ZEITP Event for which updating should take place
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)
NETWR Net Settlement Amount in Document Currency
NETWRD Net Settlement Amount in Document Currency (Customer-Side)
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
LFTYP Settlement Document Category Show values
RFBSK Posting Status for Transfer to Financial Accounting Show values
WBTYP Settlement Process Category Show values
WDTYP Settlement Management Document Category Show values
WRTYP Entry Category for Logistics Data Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
LFART_RL Settlement Document Type for Settlement Document List WFART
PERIV Fiscal Year Variant PERIV
NOHDR Counter for Documents ZAEHL
ANZVGRL Key Figure: Number of Remuneration Lists (Payment) MCZAEHLER
ANZVGLF Key Figure: No. of Invoice Lists (Vendor Billing Document) MCZAEHLER
ANZRG Key figure: Number of payment requests MCZAEHLER
ANZLF Key figure: Number of vendor billing documents MCZAEHLER
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • 2LIS_45_HDR.MANDT == T001.MANDT
  • 2LIS_45_HDR.BUKRS == T001.BUKRS
Purchasing Group
  • Client
  • Purchasing Group
  • 2LIS_45_HDR.MANDT == T024.MANDT
  • 2LIS_45_HDR.EKGRP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • 2LIS_45_HDR.MANDT == T024E.MANDT
  • 2LIS_45_HDR.EKORG == T024E.EKORG
Credit control area
  • Client
  • Credit control area
  • 2LIS_45_HDR.MANDT == T014.MANDT
  • 2LIS_45_HDR.KKBER == T014.KKBER
Bill-to Party
  • Client
  • Bill-to Party
  • 2LIS_45_HDR.MANDT == KNA1.MANDT
  • 2LIS_45_HDR.KUNRE == KNA1.KUNNR
Payer
  • Client
  • Payer
  • 2LIS_45_HDR.MANDT == KNA1.MANDT
  • 2LIS_45_HDR.KUNRG == KNA1.KUNNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • 2LIS_45_HDR.MANDT == TCURV.MANDT
  • 2LIS_45_HDR.KURST == TCURV.KURST
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • 2LIS_45_HDR.MANDT == T005.MANDT
  • 2LIS_45_HDR.LANDL == T005.LAND1
Settlement Document Type
  • Client
  • Settlement Document Type
  • 2LIS_45_HDR.MANDT == TMFK.MANDT
  • 2LIS_45_HDR.LFART == TMFK.LFART
Activity Reason for Document Creation
  • Client
  • Activity Reason for Document Creation
  • 2LIS_45_HDR.MANDT == TMLFG.MANDT
  • 2LIS_45_HDR.LFGRU == TMLFG.LFGRU
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • 2LIS_45_HDR.MANDT == LFA1.MANDT
  • 2LIS_45_HDR.LIFRE == LFA1.LIFNR
Payee
  • Client
  • Payee
  • 2LIS_45_HDR.MANDT == LFA1.MANDT
  • 2LIS_45_HDR.LNRZB == LFA1.LIFNR
Logical system 2LIS_45_HDR.LOGSYS == TBDLS.LOGSYS
Division
  • Client
  • Division
  • 2LIS_45_HDR.MANDT == TSPA.MANDT
  • 2LIS_45_HDR.SPART == TSPA.SPART
Update Group for statistics update
  • Client
  • Update Group for statistics update
  • 2LIS_45_HDR.MANDT == TMCB.MANDT
  • 2LIS_45_HDR.STAFO == TMCB.STAFO
Check Sales Office
  • Client
  • Sales office
  • 2LIS_45_HDR.MANDT == TVBUR.MANDT
  • 2LIS_45_HDR.VKBUR == TVBUR.VKBUR
Check Sales Group
  • Client
  • Sales group
  • 2LIS_45_HDR.MANDT == TVKGR.MANDT
  • 2LIS_45_HDR.VKGRP == TVKGR.VKGRP
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_45_HDR.MANDT == TVKO.MANDT
  • 2LIS_45_HDR.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_45_HDR.MANDT == TVTW.MANDT
  • 2LIS_45_HDR.VTWEG == TVTW.VTWEG
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • 2LIS_45_HDR.MANDT == TCURC.MANDT
  • 2LIS_45_HDR.WAERL == TCURC.WAERS
Settlement Process Type
  • Client
  • Settlement Process Type
  • 2LIS_45_HDR.MANDT == TMZR.MANDT
  • 2LIS_45_HDR.WRART == TMZR.WRART
Statistics Currency
  • Client
  • Statistics Currency
  • 2LIS_45_HDR.MANDT == TCURC.MANDT
  • 2LIS_45_HDR.WSTWAE == TCURC.WAERS