I_PurReqnAcctAssgmtWrkItmTP

Transactional view for Pur Reqn Acct Assgmt | view: IPRACCTWRKITMWD | TRAN | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EBKN, PRTE, SWWWIHEAD, SWWUSERWI, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, TKA01, KNA1, FM01, T001W, PROJ, T000, LFA1, USR21, T001K, PRPS, SWW_WI2OBJ, HRUS_D2, SWWWICOMMENT, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

🔑 Keys (4)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical (1)
Other (30)
🔗 Relations (21)

Column Name	Description
WorkflowTaskInternalID	Work item ID
PurReqnAcctAssgmtNmbr	Serial number for PReq account assignment segment
PurchaseRequisition	Purchase Requisition Number
PurchaseRequisitionItem FK	Item number of purchase requisition

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
AccountAssignmentIsAddable	Boolean Variable (X = True, - = False, Space = Unknown)	Show values

Column Name	Description	Domain name
PurReqnAcctAssgmtNmbrForEdit	Serial number for PReq account assignment segment
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	Profitability Segment Number (CO-PA)	RKEOBJNR
ProfitCenter	Profit Center	PRCTR
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
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
EarmarkedFundsDocumentItem	Earmarked Funds: Document Item	KBLPOS
GrantID	Grant	GM_GRANT_NBR
CompanyCode	Company Code	BUKRS
ProcurementHubSourceSystem	null
BudgetPeriod	Budget Period	FM_BUDGET_PERIOD
FundedProgram	Funded Program	FM_MEASURE
NetworkActivity	Operation/Activity Number	VORNR

Master Data Relations	Join Conditions
Purchase requisition unit of measure Client Purchase requisition unit of measure	`I_PURREQNACCTASSGMTWRKITMTP.MANDT == T006.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.BASEUNIT == T006.MSEHI`
Business Area Business Area Client	`I_PURREQNACCTASSGMTWRKITMTP.BUSINESSAREA == TGSB.GSBER` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == TGSB.MANDT`
Business Process Controlling Area Business Process ? Client	`I_PURREQNACCTASSGMTWRKITMTP.CONTROLLINGAREA == CBPR.KOKRS` `I_PURREQNACCTASSGMTWRKITMTP.BUSINESSPROCESS == CBPR.PRZNR` `I_PURREQNACCTASSGMTWRKITMTP.[column in domain "DATBI"] == CBPR.DATBI` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == CBPR.MANDT`
Chart of Accounts Client Chart of Accounts	`I_PURREQNACCTASSGMTWRKITMTP.MANDT == T004.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.CHARTOFACCOUNTS == T004.KTOPL`
Commitment Item Date on which the record was created ? Commitment Item Client	`I_PURREQNACCTASSGMTWRKITMTP.CREATIONDATE == FMFPO.DATBIS` `I_PURREQNACCTASSGMTWRKITMTP.[column in domain "FIKRS"] == FMFPO.FIKRS` `I_PURREQNACCTASSGMTWRKITMTP.COMMITMENTITEM == FMFPO.FIPOS` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == FMFPO.MANDT`
Controlling Area Controlling Area Client	`I_PURREQNACCTASSGMTWRKITMTP.CONTROLLINGAREA == TKA01.KOKRS` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == TKA01.MANDT`
Cost Center Date on which the record was created Controlling Area Cost Center Client	`I_PURREQNACCTASSGMTWRKITMTP.CREATIONDATE == CSKS.DATBI` `I_PURREQNACCTASSGMTWRKITMTP.CONTROLLINGAREA == CSKS.KOKRS` `I_PURREQNACCTASSGMTWRKITMTP.COSTCENTER == CSKS.KOSTL` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == CSKS.MANDT`
Activity Type Controlling Area Activity Type ? Client	`I_PURREQNACCTASSGMTWRKITMTP.CONTROLLINGAREA == CSLA.KOKRS` `I_PURREQNACCTASSGMTWRKITMTP.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `I_PURREQNACCTASSGMTWRKITMTP.[column in domain "DATBI"] == CSLA.DATBI` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == CSLA.MANDT`
G/L Account Number G/L Account Number G/L Account Number Client Chart of Accounts	`I_PURREQNACCTASSGMTWRKITMTP.COSTELEMENT == SKA1.SAKNR` `I_PURREQNACCTASSGMTWRKITMTP.GLACCOUNT == SKA1.SAKNR` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == SKA1.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.CHARTOFACCOUNTS == SKA1.KTOPL`
Asset Subnumber Main Asset Number ? Client Asset Subnumber	`I_PURREQNACCTASSGMTWRKITMTP.MASTERFIXEDASSET == ANLA.ANLN1` `I_PURREQNACCTASSGMTWRKITMTP.[column in domain "BUKRS"] == ANLA.BUKRS` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == ANLA.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.FIXEDASSET == ANLA.ANLN2`
G/L Account Number G/L Account Number G/L Account Number Client Chart of Accounts	`I_PURREQNACCTASSGMTWRKITMTP.COSTELEMENT == SKA1.SAKNR` `I_PURREQNACCTASSGMTWRKITMTP.GLACCOUNT == SKA1.SAKNR` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == SKA1.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.CHARTOFACCOUNTS == SKA1.KTOPL`
Order Number Order Number Order Number Client	`I_PURREQNACCTASSGMTWRKITMTP.ORDERID == AUFK.AUFNR` `I_PURREQNACCTASSGMTWRKITMTP.PROCESSORDER == AUFK.AUFNR` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == AUFK.MANDT`
Partner account number Client Partner account number	`I_PURREQNACCTASSGMTWRKITMTP.MANDT == KNA1.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.PARTNERACCOUNTNUMBER == KNA1.KUNNR`
Order Number Order Number Order Number Client	`I_PURREQNACCTASSGMTWRKITMTP.ORDERID == AUFK.AUFNR` `I_PURREQNACCTASSGMTWRKITMTP.PROCESSORDER == AUFK.AUFNR` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == AUFK.MANDT`
Network Number for Account Assignment Network Number for Account Assignment Client	`I_PURREQNACCTASSGMTWRKITMTP.PROJECTNETWORK == AUFK.AUFNR` `I_PURREQNACCTASSGMTWRKITMTP.MANDT == AUFK.MANDT`
Currency Key Client Currency Key	`I_PURREQNACCTASSGMTWRKITMTP.MANDT == TCURC.MANDT` `I_PURREQNACCTASSGMTWRKITMTP.PURREQNITEMCURRENCY == TCURC.WAERS`