CFIN_AV_PO_ROOT

Purchasing Document Header | #header | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
Column Name Description
Column Name Description
AEDAT Date on which the record was created
BEDAT Purchasing Document Date
KDATB Start of Validity Period
KDATE End of Validity Period
Column Name Description
BSTYP Purchasing Document Category Show values
BSAKZ Control indicator for purchasing document type Show values
KUFIX Indicator for Fixed Exchange Rate Show values
FRGRL Release Not Yet Completely Effected Show values
MEMORY Purchase order not yet complete Show values
PROCSTAT Purchasing document processing state Show values
IUUC_OPERAT_FLAG Delete/Archive Indicator Show values
ISEOPBLOCKED Business Purpose Completed Show values
ISAGED Document is aged Show values
Column Name Description Domain name
AV_CHANGEDTIME Accounting View Changed Time TZNTSTMPS
AV_CHANGEUSER Accounting View Change User UNAME
AV_CREATEDTIME Accounting View Created Time TZNTSTMPS
AV_CREATEUSER Accounting View Create User UNAME
EBELN Purchasing Document Number EBELN
LOEKZ Deletion Indicator in Purchasing Document ELOEK
ZTERM Terms of payment key ZTERM
ZBD1T Cash (Prompt Payment) Discount Days ZBDXT
ZBD2T Cash (Prompt Payment) Discount Days ZBDXT
ZBD3T Cash (Prompt Payment) Discount Days ZBDXT
ZBD1P Cash discount percentage 1 PRZ23
ZBD2P Cash Discount Percentage 2 PRZ23
WKURS Exchange Rate KURSP
KNUMV Number of the Document Condition KNUMV
REVNO Version number in Purchasing REVNO
ERNAM Name of Person Responsible for Creating the Object USNAM
DUMMY_AVPO_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • CFIN_AV_PO_ROOT.MANDT == T161.MANDT
  • CFIN_AV_PO_ROOT.BSTYP == T161.BSTYP
  • CFIN_AV_PO_ROOT.BSART == T161.BSART
Company Code
  • CFIN_AV_PO_ROOT.MANDT == T001.MANDT
  • CFIN_AV_PO_ROOT.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • CFIN_AV_PO_ROOT.EKGRP == T024.EKGRP
  • CFIN_AV_PO_ROOT.MANDT == T024.MANDT
Purchasing organization
  • CFIN_AV_PO_ROOT.MANDT == T024E.MANDT
  • CFIN_AV_PO_ROOT.EKORG == T024E.EKORG
Logical system CFIN_AV_PO_ROOT.FINS_LOGSYS == TBDLS.LOGSYS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • CFIN_AV_PO_ROOT.MANDT == T683.MANDT
  • CFIN_AV_PO_ROOT.[column in domain "KAPPL"] == T683.KAPPL
  • CFIN_AV_PO_ROOT.KALSM == T683.KALSM
  • CFIN_AV_PO_ROOT.[column in domain "KVEWE"] == T683.KVEWE
Country/Region for Tax Report
  • Country/Region for Tax Report
  • Client
  • CFIN_AV_PO_ROOT.LANDS == T005.LAND1
  • CFIN_AV_PO_ROOT.MANDT == T005.MANDT
Vendor's account number
  • CFIN_AV_PO_ROOT.MANDT == LFA1.MANDT
  • CFIN_AV_PO_ROOT.LIFNR == LFA1.LIFNR
Different Invoicing Party
  • CFIN_AV_PO_ROOT.MANDT == LFA1.MANDT
  • CFIN_AV_PO_ROOT.LIFRE == LFA1.LIFNR
Goods Supplier
  • CFIN_AV_PO_ROOT.MANDT == LFA1.MANDT
  • CFIN_AV_PO_ROOT.LLIEF == LFA1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • CFIN_AV_PO_ROOT.MANDT == T001W.MANDT
  • CFIN_AV_PO_ROOT.RESWK == T001W.WERKS
Currency Key
  • CFIN_AV_PO_ROOT.MANDT == TCURC.MANDT
  • CFIN_AV_PO_ROOT.WAERS == TCURC.WAERS