I_CntrlPurOrderAcctAssgmt

Purchase Order Acc Assignment | view: IMMCPUROACCASS | TRAN | Extraction: Not supported | Component: Central Purchase Order
Tables used: MMPUR_EXT_EKKO, MMPUR_EXT_EKKN
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
ExtSourceSystem Connected System ID
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
PurgDocNetAmount Net Order Value in PO Currency
NonDeductibleInputTaxAmount Non-deductible input tax
Column Name Description
Quantity Quantity
Column Name Description
LastChangedDate Date on which the record was created
CreationDate Date on which the record was created
SettlementReferenceDate Reference date for settlement
ValidityDate null
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
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 Profitability Segment Number (CO-PA) RKEOBJNR
ProfitCenter Profit Center PRCTR
WBSElementInternalID Work Breakdown Structure Element (WBS Element) MMPUR_D_WBS_ELEMENT_ID
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
ChartOfAccounts Chart of Accounts KTOPL
EarmarkedFundsItem Earmarked Funds: Document Item KBLPOS
NetworkActivity Operation/Activity Number PS_S4_VORNR
OrderOperation Operation or Phase Number VDM_VORNR
Master Data Relations Join Conditions
Final Account Assignment Reason Code
  • Final Account Assignment Reason Code
  • Client
  • I_CNTRLPURORDERACCTASSGMT.ACCTLINEFINALREASON == T163RC.AA_FINAL_REASON
  • I_CNTRLPURORDERACCTASSGMT.MANDT == T163RC.MANDT
Business Area
  • Business Area
  • Client
  • I_CNTRLPURORDERACCTASSGMT.BUSINESSAREA == TGSB.GSBER
  • I_CNTRLPURORDERACCTASSGMT.MANDT == TGSB.MANDT
Business Process
  • Business Process
  • Client
  • ?
  • Controlling Area
  • I_CNTRLPURORDERACCTASSGMT.BUSINESSPROCESS == CBPR.PRZNR
  • I_CNTRLPURORDERACCTASSGMT.MANDT == CBPR.MANDT
  • I_CNTRLPURORDERACCTASSGMT.[column in domain "DATBI"] == CBPR.DATBI
  • I_CNTRLPURORDERACCTASSGMT.CONTROLLINGAREA == CBPR.KOKRS
Commitment Item
  • Commitment Item
  • ?
  • Client
  • Date on which the record was created
  • I_CNTRLPURORDERACCTASSGMT.COMMITMENTITEM == FMFPO.FIPOS
  • I_CNTRLPURORDERACCTASSGMT.[column in domain "FIKRS"] == FMFPO.FIKRS
  • I_CNTRLPURORDERACCTASSGMT.MANDT == FMFPO.MANDT
  • I_CNTRLPURORDERACCTASSGMT.CREATIONDATE == FMFPO.DATBIS
Company Code
  • Company Code
  • Client
  • I_CNTRLPURORDERACCTASSGMT.COMPANYCODE == T001.BUKRS
  • I_CNTRLPURORDERACCTASSGMT.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_CNTRLPURORDERACCTASSGMT.MANDT == TKA01.MANDT
  • I_CNTRLPURORDERACCTASSGMT.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • Controlling Area
  • Date on which the record was created
  • I_CNTRLPURORDERACCTASSGMT.COSTCENTER == CSKS.KOSTL
  • I_CNTRLPURORDERACCTASSGMT.MANDT == CSKS.MANDT
  • I_CNTRLPURORDERACCTASSGMT.CONTROLLINGAREA == CSKS.KOKRS
  • I_CNTRLPURORDERACCTASSGMT.CREATIONDATE == CSKS.DATBI
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • I_CNTRLPURORDERACCTASSGMT.MANDT == CSLA.MANDT
  • I_CNTRLPURORDERACCTASSGMT.[column in domain "DATBI"] == CSLA.DATBI
  • I_CNTRLPURORDERACCTASSGMT.CONTROLLINGAREA == CSLA.KOKRS
  • I_CNTRLPURORDERACCTASSGMT.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Asset Subnumber
  • Company Code
  • Client
  • Asset Subnumber
  • Main Asset Number
  • I_CNTRLPURORDERACCTASSGMT.COMPANYCODE == ANLA.BUKRS
  • I_CNTRLPURORDERACCTASSGMT.MANDT == ANLA.MANDT
  • I_CNTRLPURORDERACCTASSGMT.FIXEDASSET == ANLA.ANLN2
  • I_CNTRLPURORDERACCTASSGMT.MASTERFIXEDASSET == ANLA.ANLN1
G/L Account Number
  • Client
  • G/L Account Number
  • ?
  • I_CNTRLPURORDERACCTASSGMT.MANDT == SKA1.MANDT
  • I_CNTRLPURORDERACCTASSGMT.GLACCOUNT == SKA1.SAKNR
  • I_CNTRLPURORDERACCTASSGMT.[column in domain "KTOPL"] == SKA1.KTOPL
Order Number
  • Client
  • Order Number
  • I_CNTRLPURORDERACCTASSGMT.MANDT == AUFK.MANDT
  • I_CNTRLPURORDERACCTASSGMT.ORDERID == AUFK.AUFNR
Partner account number
  • Client
  • Partner account number
  • I_CNTRLPURORDERACCTASSGMT.MANDT == KNA1.MANDT
  • I_CNTRLPURORDERACCTASSGMT.PARTNERACCOUNTNUMBER == KNA1.KUNNR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_CNTRLPURORDERACCTASSGMT.PROJECTNETWORK == AUFK.AUFNR
  • I_CNTRLPURORDERACCTASSGMT.MANDT == AUFK.MANDT