I_PurReqnAcctAssgmtAPI01

Account Assgmt in Purchase Requisition | view: IPRACCASMTAPI01 | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EBKN, PRTE, TKA01, FM01, T001W, PROJ, T000, T001K, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE
Column Name Description
PurchaseRequisition Purchase Requisition Number
PurchaseRequisitionItem FK Item number of purchase requisition
PurchaseReqnAcctAssgmtNumber Serial number for PReq account assignment segment
Column Name Description
💲 Currency Key (PurReqnItemCurrency):
PurReqnNetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase requisition unit of measure (BaseUnit):
Quantity Purchase requisition quantity
Column Name Description
CreationDate Date on which the record was created
SettlementReferenceDate Reference date for settlement
ValidityDate null
Column Name Description
Column Name Description Domain name
MultipleAcctAssgmtDistrPercent Distribution percentage in the case of multiple acct assgt VPROZ
IsDeleted Deletion Indicator in Purchasing Document ELOEK
SDDocument Sales and Distribution Document Number VBELN
SalesOrder Sales and Distribution Document Number VBELN
SalesDocumentItem Sales Document Item POSNR
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
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
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
GrantID Grant GM_GRANT_NBR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations Join Conditions
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • I_PURREQNACCTASSGMTAPI01.BASEUNIT == T006.MSEHI
  • I_PURREQNACCTASSGMTAPI01.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • I_PURREQNACCTASSGMTAPI01.BUSINESSAREA == TGSB.GSBER
  • I_PURREQNACCTASSGMTAPI01.MANDT == TGSB.MANDT
Business Process
  • Controlling Area
  • Business Process
  • Client
  • ?
  • I_PURREQNACCTASSGMTAPI01.CONTROLLINGAREA == CBPR.KOKRS
  • I_PURREQNACCTASSGMTAPI01.BUSINESSPROCESS == CBPR.PRZNR
  • I_PURREQNACCTASSGMTAPI01.MANDT == CBPR.MANDT
  • I_PURREQNACCTASSGMTAPI01.[column in domain "DATBI"] == CBPR.DATBI
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PURREQNACCTASSGMTAPI01.CHARTOFACCOUNTS == T004.KTOPL
  • I_PURREQNACCTASSGMTAPI01.MANDT == T004.MANDT
Commitment Item
  • Date on which the record was created
  • Commitment Item
  • Client
  • ?
  • I_PURREQNACCTASSGMTAPI01.CREATIONDATE == FMFPO.DATBIS
  • I_PURREQNACCTASSGMTAPI01.COMMITMENTITEM == FMFPO.FIPOS
  • I_PURREQNACCTASSGMTAPI01.MANDT == FMFPO.MANDT
  • I_PURREQNACCTASSGMTAPI01.[column in domain "FIKRS"] == FMFPO.FIKRS
Controlling Area
  • Controlling Area
  • Client
  • I_PURREQNACCTASSGMTAPI01.CONTROLLINGAREA == TKA01.KOKRS
  • I_PURREQNACCTASSGMTAPI01.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Date on which the record was created
  • Controlling Area
  • Client
  • I_PURREQNACCTASSGMTAPI01.COSTCENTER == CSKS.KOSTL
  • I_PURREQNACCTASSGMTAPI01.CREATIONDATE == CSKS.DATBI
  • I_PURREQNACCTASSGMTAPI01.CONTROLLINGAREA == CSKS.KOKRS
  • I_PURREQNACCTASSGMTAPI01.MANDT == CSKS.MANDT
Activity Type
  • Controlling Area
  • Activity Type
  • Client
  • ?
  • I_PURREQNACCTASSGMTAPI01.CONTROLLINGAREA == CSLA.KOKRS
  • I_PURREQNACCTASSGMTAPI01.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PURREQNACCTASSGMTAPI01.MANDT == CSLA.MANDT
  • I_PURREQNACCTASSGMTAPI01.[column in domain "DATBI"] == CSLA.DATBI
G/L Account Number
  • Chart of Accounts
  • Client
  • G/L Account Number
  • G/L Account Number
  • I_PURREQNACCTASSGMTAPI01.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_PURREQNACCTASSGMTAPI01.MANDT == SKA1.MANDT
  • I_PURREQNACCTASSGMTAPI01.GLACCOUNT == SKA1.SAKNR
  • I_PURREQNACCTASSGMTAPI01.COSTELEMENT == SKA1.SAKNR
Asset Subnumber
  • Asset Subnumber
  • ?
  • Main Asset Number
  • Client
  • I_PURREQNACCTASSGMTAPI01.FIXEDASSET == ANLA.ANLN2
  • I_PURREQNACCTASSGMTAPI01.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_PURREQNACCTASSGMTAPI01.MASTERFIXEDASSET == ANLA.ANLN1
  • I_PURREQNACCTASSGMTAPI01.MANDT == ANLA.MANDT
G/L Account Number
  • Chart of Accounts
  • Client
  • G/L Account Number
  • G/L Account Number
  • I_PURREQNACCTASSGMTAPI01.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_PURREQNACCTASSGMTAPI01.MANDT == SKA1.MANDT
  • I_PURREQNACCTASSGMTAPI01.GLACCOUNT == SKA1.SAKNR
  • I_PURREQNACCTASSGMTAPI01.COSTELEMENT == SKA1.SAKNR
Order Number
  • Order Number
  • Order Number
  • Client
  • I_PURREQNACCTASSGMTAPI01.PROCESSORDER == AUFK.AUFNR
  • I_PURREQNACCTASSGMTAPI01.ORDERID == AUFK.AUFNR
  • I_PURREQNACCTASSGMTAPI01.MANDT == AUFK.MANDT
Partner account number
  • Client
  • Partner account number
  • I_PURREQNACCTASSGMTAPI01.MANDT == KNA1.MANDT
  • I_PURREQNACCTASSGMTAPI01.PARTNERACCOUNTNUMBER == KNA1.KUNNR
Plant
  • Client
  • Plant
  • I_PURREQNACCTASSGMTAPI01.MANDT == T001W.MANDT
  • I_PURREQNACCTASSGMTAPI01.PLANT == T001W.WERKS
Order Number
  • Order Number
  • Order Number
  • Client
  • I_PURREQNACCTASSGMTAPI01.PROCESSORDER == AUFK.AUFNR
  • I_PURREQNACCTASSGMTAPI01.ORDERID == AUFK.AUFNR
  • I_PURREQNACCTASSGMTAPI01.MANDT == AUFK.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_PURREQNACCTASSGMTAPI01.PROJECTNETWORK == AUFK.AUFNR
  • I_PURREQNACCTASSGMTAPI01.MANDT == AUFK.MANDT
Purchase Requisition Document Type
  • ?
  • Client
  • Purchase Requisition Document Type
  • I_PURREQNACCTASSGMTAPI01.[column in domain "BSTYP"] == T161.BSTYP
  • I_PURREQNACCTASSGMTAPI01.MANDT == T161.MANDT
  • I_PURREQNACCTASSGMTAPI01.PURCHASEREQUISITIONTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • I_PURREQNACCTASSGMTAPI01.PURCHASINGGROUP == T024.EKGRP
  • I_PURREQNACCTASSGMTAPI01.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_PURREQNACCTASSGMTAPI01.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURREQNACCTASSGMTAPI01.MANDT == T024E.MANDT
Currency Key
  • Client
  • Currency Key
  • I_PURREQNACCTASSGMTAPI01.MANDT == TCURC.MANDT
  • I_PURREQNACCTASSGMTAPI01.PURREQNITEMCURRENCY == TCURC.WAERS