2LIS_02_ACC

Purchasing Data (Account Level) | #TRAN | Extraction method: F1 | Delta: ABR | Component: Materials Management
Tables used: EKPO, EKKN, BSEG, QALS, VBRP ... +188 more
Column Name Description
BUKRS FK Company Code
EBELN FK Purchasing Document Number
EKGRP FK Purchasing Group
EKORG FK Purchasing organization
LIFNR FK Vendor's account number
STATU Status of Purchasing Document Show values
EBELP Item Number of Purchasing Document
MATNR FK Material Number
WERKS FK Plant
AUFNR FK Order Number
VBELN Sales and Distribution Document Number
ZEKKN Sequential Number of Account Assignment
Column Name Description
💲 Purchase order currency (WAERS):
NETPR Net Price
EFFWR Effective order value
NAVNW Non-deductible input tax
NETWR Net Order Value in PO Currency
💲 Local Currency (HWAER):
EFFHW Effective order value in local currency
NETHW Net purchase local value (base unit)
Column Name Description
📏 Purchase Order Unit of Measure (MEINS):
MENGE Quantity
Column Name Description
BEDAT Purchasing Document Date
KDATB Start of Validity Period
KDATE End of Validity Period
SYDAT Date on which the purchasing document was entered
AEDAT Date on which the record was created
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
BSTYP Purchasing Document Category Show values
STATU Status of Purchasing Document Show values
ELIKZ "Delivery Completed" Indicator Show values
EREKZ Final Invoice Indicator Show values
TWRKZ Partial invoice indicator Show values
VRTKZ Distribution Indicator for Multiple Account Assignment Show values
WEBRE Indicator: GR-Based Invoice Verification Show values
XERSY Evaluated Receipt Settlement (ERS) Show values
XBAUF Post To Order Show values
XBKST Posting to cost center? Show values
XBPRO Post to project Show values
Column Name Description Domain name
LOGSY Logical System LOGSYS
ORGLOGSY Logical System LOGSYS
WKURS Exchange Rate KURSP
AFNAM Name of requisitioner/requester AFNAM
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
PEINH Price unit PACK3
TXZ01 Short Text TEXT40
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ
APLZL Internal counter CIM_COUNT
AUFPL Routing number of operations in the order AUFPL
FIKRS Financial Management Area FIKRS
FISTL Funds Center FISTL
FKBER Functional Area FKBER
GEBER Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
KBLNR Document Number for Earmarked Funds KBLNR
KBLPOS Earmarked Funds: Document Item KBLPOS
KSTRG Cost Object KSTRG
KTOPL Chart of Accounts KTOPL
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PRCTR Profit Center PRCTR
VBELP Sales Document Item POSNR
VPROZ Distribution percentage in the case of multiple acct assgt VPROZ
Master Data Relations Join Conditions
Promotion
  • Client
  • Promotion
  • 2LIS_02_ACC.MANDT == WAKH.MANDT
  • 2LIS_02_ACC.AKTNR == WAKH.AKTNR
Asset Subnumber
  • ?
  • Client
  • Main Asset Number
  • Asset Subnumber
  • 2LIS_02_ACC.[column in domain "BUKRS"] == ANLA.BUKRS
  • 2LIS_02_ACC.MANDT == ANLA.MANDT
  • 2LIS_02_ACC.ANLN1 == ANLA.ANLN1
  • 2LIS_02_ACC.ANLN2 == ANLA.ANLN2
Order Number
  • Client
  • Order Number
  • 2LIS_02_ACC.MANDT == AUFK.MANDT
  • 2LIS_02_ACC.AUFNR == AUFK.AUFNR
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • 2LIS_02_ACC.[column in domain "BSTYP"] == T161.BSTYP
  • 2LIS_02_ACC.MANDT == T161.MANDT
  • 2LIS_02_ACC.BSART == T161.BSART
Reason for Ordering
  • Client
  • Reason for Ordering
  • 2LIS_02_ACC.MANDT == TBSG.MANDT
  • 2LIS_02_ACC.BSGRU == TBSG.BSGRU
Company Code
  • Client
  • Company Code
  • 2LIS_02_ACC.MANDT == T001.MANDT
  • 2LIS_02_ACC.BUKRS == T001.BUKRS
Purchasing Group
  • Client
  • Purchasing Group
  • 2LIS_02_ACC.MANDT == T024.MANDT
  • 2LIS_02_ACC.EKGRP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • 2LIS_02_ACC.MANDT == T024E.MANDT
  • 2LIS_02_ACC.EKORG == T024E.EKORG
Material number
  • Client
  • Material number
  • 2LIS_02_ACC.MANDT == MARA.MANDT
  • 2LIS_02_ACC.EMATN == MARA.MATNR
Commitment Item
  • ?
  • ?
  • Client
  • Date on which the record was created
  • Commitment Item
  • 2LIS_02_ACC.[column in domain "FM_DATBIS"] == FMFPO.DATBIS
  • 2LIS_02_ACC.[column in domain "FIKRS"] == FMFPO.FIKRS
  • 2LIS_02_ACC.MANDT == FMFPO.MANDT
  • 2LIS_02_ACC.AEDAT == FMFPO.DATBIS
  • 2LIS_02_ACC.FIPOS == FMFPO.FIPOS
Business Area
  • Client
  • Business Area
  • 2LIS_02_ACC.MANDT == TGSB.MANDT
  • 2LIS_02_ACC.GSBER == TGSB.GSBER
Account Assignment Category
  • Client
  • Account Assignment Category
  • 2LIS_02_ACC.MANDT == T163K.MANDT
  • 2LIS_02_ACC.KNTTP == T163K.KNTTP
Controlling Area
  • Client
  • Controlling Area
  • 2LIS_02_ACC.MANDT == TKA01.MANDT
  • 2LIS_02_ACC.KOKRS == TKA01.KOKRS
Cost Center
  • Client
  • Date on which the record was created
  • Controlling Area
  • Cost Center
  • 2LIS_02_ACC.MANDT == CSKS.MANDT
  • 2LIS_02_ACC.AEDAT == CSKS.DATBI
  • 2LIS_02_ACC.KOKRS == CSKS.KOKRS
  • 2LIS_02_ACC.KOSTL == CSKS.KOSTL
Storage location
  • Client
  • Storage location
  • Plant
  • 2LIS_02_ACC.MANDT == T001L.MANDT
  • 2LIS_02_ACC.LGORT == T001L.LGORT
  • 2LIS_02_ACC.WERKS == T001L.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • 2LIS_02_ACC.MANDT == LFA1.MANDT
  • 2LIS_02_ACC.LIFNR == LFA1.LIFNR
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • 2LIS_02_ACC.MANDT == LFA1.MANDT
  • 2LIS_02_ACC.LIFRE == LFA1.LIFNR
Goods Supplier
  • Client
  • Goods Supplier
  • 2LIS_02_ACC.MANDT == LFA1.MANDT
  • 2LIS_02_ACC.LLIEF == LFA1.LIFNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_02_ACC.MANDT == T006.MANDT
  • 2LIS_02_ACC.LMEIN == T006.MSEHI
Material Group
  • Client
  • Material Group
  • 2LIS_02_ACC.MANDT == T023.MANDT
  • 2LIS_02_ACC.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • 2LIS_02_ACC.MANDT == MARA.MANDT
  • 2LIS_02_ACC.MATNR == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • 2LIS_02_ACC.MANDT == T006.MANDT
  • 2LIS_02_ACC.MEINS == T006.MSEHI
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • 2LIS_02_ACC.[column in domain "KALSM_D"] == T007A.KALSM
  • 2LIS_02_ACC.MANDT == T007A.MANDT
  • 2LIS_02_ACC.MWSKZ == T007A.MWSKZ
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • 2LIS_02_ACC.MANDT == AUFK.MANDT
  • 2LIS_02_ACC.NPLNR == AUFK.AUFNR
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • 2LIS_02_ACC.MANDT == T163.MANDT
  • 2LIS_02_ACC.PSTYP == T163.PSTYP
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • 2LIS_02_ACC.MANDT == T001W.MANDT
  • 2LIS_02_ACC.RESWK == T001W.WERKS
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • 2LIS_02_ACC.[column in domain "KTOPL"] == SKA1.KTOPL
  • 2LIS_02_ACC.MANDT == SKA1.MANDT
  • 2LIS_02_ACC.SAKTO == SKA1.SAKNR
Plant
  • Client
  • Plant
  • 2LIS_02_ACC.MANDT == T001W.MANDT
  • 2LIS_02_ACC.WERKS == T001W.WERKS