I_PurOrdAccountAssignment

Purchase Order Account Assignment | view: IMMPUROACCASS | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, EKPO, EKKN, TKA01, T000, PRPS

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (3)
Other (31)
🔗 Relations (24)

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 (OrderQuantityUnit):
Quantity	Quantity

Column Name	Description
LastChangedDate	Date on which the record was created
SettlementReferenceDate	Reference date for settlement
ValidityDate	null
CreationDate	Date on which the record was created

Column Name	Description
IsDeleted	Deletion Indicator: Purchasing Document Account Assignment	Show values
IsFinallyInvoiced	Final Invoice Indicator	Show values
IsAcctLineFinal	Final Account Assignment Indicator	Show values

Column Name	Description	Domain name
NetworkActivity	Operation/Activity Number	PS_S4_VORNR
MultipleAcctAssgmtDistrPercent	Distribution percentage in the case of multiple acct assgt	VPROZ
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR
OrderOperation	Operation or Phase Number	VDM_VORNR
UnloadingPointName	Unloading Point	TEXT25
CostObject	Cost Object	KSTRG
ProfitabilitySegment	Deprecated: Profitability Segment	RKEOBJNR_NUMC
ProfitabilitySegment_2	Profitability Segment	RKEOBJNR_CHAR
ProfitCenter	Profit Center	PRCTR
WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
ProjectNetworkInternalID	Routing number of operations in the order	AUFPL
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
EarmarkedFundsItem	Earmarked Funds: Document Item	KBLPOS
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
Final Account Assignment Reason Code Client Final Account Assignment Reason Code	`I_PURORDACCOUNTASSIGNMENT.MANDT == T163RC.MANDT` `I_PURORDACCOUNTASSIGNMENT.ACCTLINEFINALREASON == T163RC.AA_FINAL_REASON`
Business Area Client Business Area	`I_PURORDACCOUNTASSIGNMENT.MANDT == TGSB.MANDT` `I_PURORDACCOUNTASSIGNMENT.BUSINESSAREA == TGSB.GSBER`
Business Process Client ? Business Process Controlling Area	`I_PURORDACCOUNTASSIGNMENT.MANDT == CBPR.MANDT` `I_PURORDACCOUNTASSIGNMENT.[column in domain "DATBI"] == CBPR.DATBI` `I_PURORDACCOUNTASSIGNMENT.BUSINESSPROCESS == CBPR.PRZNR` `I_PURORDACCOUNTASSIGNMENT.CONTROLLINGAREA == CBPR.KOKRS`
Chart of Accounts Chart of Accounts Client	`I_PURORDACCOUNTASSIGNMENT.CHARTOFACCOUNTS == T004.KTOPL` `I_PURORDACCOUNTASSIGNMENT.MANDT == T004.MANDT`
Commitment Item Date on which the record was created Commitment Item Short ID Commitment Item Client ?	`I_PURORDACCOUNTASSIGNMENT.CREATIONDATE == FMFPO.DATBIS` `I_PURORDACCOUNTASSIGNMENT.COMMITMENTITEMSHORTID == FMFPO.FIPOS` `I_PURORDACCOUNTASSIGNMENT.COMMITMENTITEM == FMFPO.FIPOS` `I_PURORDACCOUNTASSIGNMENT.MANDT == FMFPO.MANDT` `I_PURORDACCOUNTASSIGNMENT.[column in domain "FIKRS"] == FMFPO.FIKRS`
Commitment Item Short ID Date on which the record was created Commitment Item Short ID Commitment Item Client ?	`I_PURORDACCOUNTASSIGNMENT.CREATIONDATE == FMFPO.DATBIS` `I_PURORDACCOUNTASSIGNMENT.COMMITMENTITEMSHORTID == FMFPO.FIPOS` `I_PURORDACCOUNTASSIGNMENT.COMMITMENTITEM == FMFPO.FIPOS` `I_PURORDACCOUNTASSIGNMENT.MANDT == FMFPO.MANDT` `I_PURORDACCOUNTASSIGNMENT.[column in domain "FIKRS"] == FMFPO.FIKRS`
Company Code Client Company Code	`I_PURORDACCOUNTASSIGNMENT.MANDT == T001.MANDT` `I_PURORDACCOUNTASSIGNMENT.COMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area	`I_PURORDACCOUNTASSIGNMENT.MANDT == TKA01.MANDT` `I_PURORDACCOUNTASSIGNMENT.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Date on which the record was created Client Cost Center Controlling Area	`I_PURORDACCOUNTASSIGNMENT.CREATIONDATE == CSKS.DATBI` `I_PURORDACCOUNTASSIGNMENT.MANDT == CSKS.MANDT` `I_PURORDACCOUNTASSIGNMENT.COSTCENTER == CSKS.KOSTL` `I_PURORDACCOUNTASSIGNMENT.CONTROLLINGAREA == CSKS.KOKRS`
Activity Type Activity Type Client ? Controlling Area	`I_PURORDACCOUNTASSIGNMENT.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `I_PURORDACCOUNTASSIGNMENT.MANDT == CSLA.MANDT` `I_PURORDACCOUNTASSIGNMENT.[column in domain "DATBI"] == CSLA.DATBI` `I_PURORDACCOUNTASSIGNMENT.CONTROLLINGAREA == CSLA.KOKRS`
Currency Key Client Currency Key	`I_PURORDACCOUNTASSIGNMENT.MANDT == TCURC.MANDT` `I_PURORDACCOUNTASSIGNMENT.DOCUMENTCURRENCY == TCURC.WAERS`
Asset Subnumber Asset Subnumber Client Main Asset Number Company Code	`I_PURORDACCOUNTASSIGNMENT.FIXEDASSET == ANLA.ANLN2` `I_PURORDACCOUNTASSIGNMENT.MANDT == ANLA.MANDT` `I_PURORDACCOUNTASSIGNMENT.MASTERFIXEDASSET == ANLA.ANLN1` `I_PURORDACCOUNTASSIGNMENT.COMPANYCODE == ANLA.BUKRS`
G/L Account Number Chart of Accounts Client G/L Account Number	`I_PURORDACCOUNTASSIGNMENT.CHARTOFACCOUNTS == SKA1.KTOPL` `I_PURORDACCOUNTASSIGNMENT.MANDT == SKA1.MANDT` `I_PURORDACCOUNTASSIGNMENT.GLACCOUNT == SKA1.SAKNR`
Order Number Client Order Number	`I_PURORDACCOUNTASSIGNMENT.MANDT == AUFK.MANDT` `I_PURORDACCOUNTASSIGNMENT.ORDERID == AUFK.AUFNR`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`I_PURORDACCOUNTASSIGNMENT.MANDT == T006.MANDT` `I_PURORDACCOUNTASSIGNMENT.ORDERQUANTITYUNIT == T006.MSEHI`
Partner account number Client Partner account number	`I_PURORDACCOUNTASSIGNMENT.MANDT == KNA1.MANDT` `I_PURORDACCOUNTASSIGNMENT.PARTNERACCOUNTNUMBER == KNA1.KUNNR`
Network Number for Account Assignment Client Network Number for Account Assignment	`I_PURORDACCOUNTASSIGNMENT.MANDT == AUFK.MANDT` `I_PURORDACCOUNTASSIGNMENT.PROJECTNETWORK == AUFK.AUFNR`