P_ACCGO_APPDOC_DTLS

Column Name Description
appldoc FK Application Document Number
item Application Document Item Number
side Side Show values
sub_item Application Document Item Number
Column Name Description
Column Name Description
📏 Unit of Measure (adj_uom):
full_ship_qty Full Shipment Quantity
tot_quantity_adj Quantity Adjustment
📏 Per Unit UoM (unit_uom):
unit_quantity Quantity in Base UoM
📏 Contract Units of Measurement (contract_uom):
contract_qty Quantity in Contract UoM
📏 Document Units of Measurement (document_uom):
document_qty Quantity in Document UoM
Column Name Description
Column Name Description
side Side Show values
appldoc_type Document Category Show values
appl_status Application Status Show values
delivery_type Pred Document Type 2 Show values
delivery_side Pred Document Number 2 Side Show values
order_type Pred Document Type 3 Show values
order_side Pred Document Number 3 Side Show values
contract_doc_type Document Type Show values
settl_cat Settlement Document Category Show values
settl_type Settlement Type Show values
settl_side Side Show values
settl_scenario Settlement Scenario Show values
Column Name Description Domain name
contract Trading Contract TKONN
contract_itm Item Number of Trading Contract TPOSN
contract_subitem Commodity Subitem Number TPOSN
REF_APP_DOC Application Document Number /ACCGO/D_APPLDOC
appl_status_objnr Object number J_OBJNR
stl_status_objnr Object number J_OBJNR
uis_evnt_id Load Data Capture Object ID /ACCGO/D_UIS_ID
uis_evnt_guid Load Data Capture Key SYSUUID_X16
OB_delivery CA Reference Document 2 WLF_GENERIC_DOC_NUM
delivery_item Pred Document Item Number 2 WLF_GENERIC_ITEM_NUM
order_no CA Reference Document 3 WLF_GENERIC_DOC_NUM
order_itm Pred Document Item Number 3 WLF_GENERIC_ITEM_NUM
po_item null
so_item null
item_qty Appdoc Item Quantity Raw (PO UoM) WLF_QUANTITY
applied_qty_raw Applied Quantity Raw
created_on Created On /ACCGO/D_TZNTSTMPS
changed_on Changed On /ACCGO/D_TZNTSTMPS
plant Plant WERKS
contract_side null
profit_center Profit Center PRCTR
supplier Account Number of Supplier LIFNR
sold_to_party Sold-to Party KUNNR
nomtk Nomination (technical) Key OIJ_NOMTK
nomnr Nomination number OIJ_NOMNR
nomit Nomination Key Item OIJ_ITEM
qrep_guid Application GUID SYSUUID_X16
qrep_version Version /ACCGO/D_QREP_ID
prcfx_asg_qty Assigned Quantity WLF_QUANTITY
assgd_quan_orig Original Assigned Quantity WLF_QUANTITY
assgmt_guid GUID of an assignment WLF_GUID
pricing_aspect_id Pricing Aspect WLF_PR_ASPECT
pricing_aspect_counter Pricing Aspect Counter TPOSN
price_fixation_number CPE Term - Number in Formula NUMC5
settl_doc Settlement Unit /ACCGO/D_SETTL_DOC
settl_yr Settlement Unit Year /ACCGO/D_SETTL_YR
settl_item Settlement Item
PrepaymentAgreement null
PrepaymentAgrmtRefDocument null
PrepaymentAgrmtRefDocItem Linking Document Number Item POSNR
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_ACCGO_APPDOC_DTLS.MANDT == T001.MANDT
  • P_ACCGO_APPDOC_DTLS.COMPANY_CODE == T001.BUKRS
Check Application Status
  • Client
  • Application Status of Trading Contract
  • P_ACCGO_APPDOC_DTLS.MANDT == TB2BA.MANDT
  • P_ACCGO_APPDOC_DTLS.CONTRACT_STATUS == TB2BA.BTBSTA
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACCGO_APPDOC_DTLS.MANDT == TB2BE.MANDT
  • P_ACCGO_APPDOC_DTLS.CONTRACT_TYPE == TB2BE.TCTYP
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • P_ACCGO_APPDOC_DTLS.MANDT == TVKOV.MANDT
  • P_ACCGO_APPDOC_DTLS.SALES_ORG == TVKOV.VKORG
  • P_ACCGO_APPDOC_DTLS.DIST_CHNL == TVKOV.VTWEG
Check Division
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • P_ACCGO_APPDOC_DTLS.MANDT == TVTA.MANDT
  • P_ACCGO_APPDOC_DTLS.DIVISION == TVTA.SPART
  • P_ACCGO_APPDOC_DTLS.SALES_ORG == TVTA.VKORG
  • P_ACCGO_APPDOC_DTLS.DIST_CHNL == TVTA.VTWEG
Currency Key
  • Client
  • Currency Key
  • P_ACCGO_APPDOC_DTLS.MANDT == TCURC.MANDT
  • P_ACCGO_APPDOC_DTLS.DOC_CURR == TCURC.WAERS
CAS Document Type
  • CAS Document Type
  • Client
UoM of the Assigned Quantity
  • UoM of the Assigned Quantity
  • Client
  • P_ACCGO_APPDOC_DTLS.PRXFX_ASG_UOM == T006.MSEHI
  • P_ACCGO_APPDOC_DTLS.MANDT == T006.MANDT
Check Purchasing Group
  • Client
  • Purchasing Group
  • P_ACCGO_APPDOC_DTLS.MANDT == T024.MANDT
  • P_ACCGO_APPDOC_DTLS.PURCH_GRP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • P_ACCGO_APPDOC_DTLS.MANDT == T024E.MANDT
  • P_ACCGO_APPDOC_DTLS.PURCH_ORG == T024E.EKORG
Application Document Type
  • Client
  • Application Document Type
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACCGO_APPDOC_DTLS.MANDT == TVKO.MANDT
  • P_ACCGO_APPDOC_DTLS.SALES_ORG == TVKO.VKORG