C_PurOrdAccountAssignmentDEX

Data Extraction for Purchase Order Account Assignments | view: CMMPURORDAADEX | TRAN | Extraction: Full or Incremental | Component: Reporting
Tables used: EKKO, EKPO, EKKN, EKKO, EKPO, TKA01, T000, PRPS
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Currency Key (DocumentCurrency):
PurgDocNetAmount Net Order Value in PO Currency
NonDeductibleInputTaxAmount Non-deductible input tax
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
Quantity Quantity
Column Name Description
SettlementReferenceDate Reference date for settlement
Column Name Description
IsDeleted Deletion Indicator: Purchasing Document Account Assignment Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
MultipleAcctAssgmtDistrPercent Distribution percentage in the case of multiple acct assgt VPROZ
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Sales Document Item POSNR
UnloadingPointName Unloading Point TEXT25
CostObject Cost Object KSTRG
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ProfitCenter Profit Center PRCTR
ProjectNetworkInternalID Routing number of operations in the order AUFPL
CommitmentItem null
FundsCenter Funds Center FISTL
Fund Fund BP_GEBER
FunctionalArea Functional Area FKBER
GoodsRecipientName Goods Recipient WEMPF
RealEstateObject Internal Key for Real Estate Object IMKEY
NetworkActivityInternalID Internal counter CIM_COUNT
JointVentureRecoveryCode Recovery Indicator JV_RECIND
OrderInternalID Routing number of operations in the order AUFPL
OrderIntBillOfOperationsItem General counter for order CO_APLZL
TaxCode Tax on sales/purchases code MWSKZ
TaxJurisdiction Tax Jurisdiction TXJCD
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == T163K.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Business Area
  • Client
  • Business Area
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == TGSB.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.BUSINESSAREA == TGSB.GSBER
Business Process
  • ?
  • Controlling Area
  • Client
  • Business Process
  • C_PURORDACCOUNTASSIGNMENTDEX.[column in domain "DATBI"] == CBPR.DATBI
  • C_PURORDACCOUNTASSIGNMENTDEX.CONTROLLINGAREA == CBPR.KOKRS
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == CBPR.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.BUSINESSPROCESS == CBPR.PRZNR
Controlling Area
  • Controlling Area
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.CONTROLLINGAREA == TKA01.KOKRS
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Cost Center
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.CONTROLLINGAREA == CSKS.KOKRS
  • C_PURORDACCOUNTASSIGNMENTDEX.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURORDACCOUNTASSIGNMENTDEX.COSTCENTER == CSKS.KOSTL
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == CSKS.MANDT
Activity Type
  • ?
  • Controlling Area
  • Client
  • Activity Type
  • C_PURORDACCOUNTASSIGNMENTDEX.[column in domain "DATBI"] == CSLA.DATBI
  • C_PURORDACCOUNTASSIGNMENTDEX.CONTROLLINGAREA == CSLA.KOKRS
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == CSLA.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Currency Key
  • Currency Key
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.DOCUMENTCURRENCY == TCURC.WAERS
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == TCURC.MANDT
Asset Subnumber
  • Asset Subnumber
  • Client
  • Main Asset Number
  • ?
  • C_PURORDACCOUNTASSIGNMENTDEX.FIXEDASSET == ANLA.ANLN2
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == ANLA.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.MASTERFIXEDASSET == ANLA.ANLN1
  • C_PURORDACCOUNTASSIGNMENTDEX.[column in domain "BUKRS"] == ANLA.BUKRS
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • C_PURORDACCOUNTASSIGNMENTDEX.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == SKA1.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.GLACCOUNT == SKA1.SAKNR
Order Number
  • Order Number
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.ORDERID == AUFK.AUFNR
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == AUFK.MANDT
Partner account number
  • Client
  • Partner account number
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == KNA1.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.PARTNERACCOUNTNUMBER == KNA1.KUNNR
Plant
  • Client
  • Plant
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == T001W.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.PLANT == T001W.WERKS
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.PROJECTNETWORK == AUFK.AUFNR
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == AUFK.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == T006.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.PURCHASEORDERTYPE == T161.BSART
  • C_PURORDACCOUNTASSIGNMENTDEX.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURORDACCOUNTASSIGNMENTDEX.PURCHASINGGROUP == T024.EKGRP
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURORDACCOUNTASSIGNMENTDEX.MANDT == T024E.MANDT
  • C_PURORDACCOUNTASSIGNMENTDEX.PURCHASINGORGANIZATION == T024E.EKORG