C_WorkItemPurReqnHdrItemDetail

Consumption view for WI PR Hdr Item | view: CWIPRHDRITMDET | TRAN | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, SWWWIHEAD, SWWUSERWI, SWWWIHEAD, SWPSTEPLOG, SWWWIHEAD, CMD_PRDTYPE, CMD_PRDTYPE_T, T163I, T163K, FM01, T001W, WSI_DESCRIPTION, WSI_ENTITY, T024, T163Y, T001L, LFA1, USR21, T001K, SWW_WI2OBJ, HRUS_D2, SWWWICOMMENT, MMPUR_C_BE_SYREG, MMPUROCI_DETAILS, MMPUR_CAT_ATTRB, FINSC_FISC_DATE

🔑 Keys (3)
💰 Amounts (5)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (3)
Other (27)
🔗 Relations (15)

Column Name	Description
WorkflowTaskInternalID	Work item ID
PurchaseRequisition	Purchase Requisition Number
PurchaseRequisitionItem	Item number of purchase requisition

Column Name	Description
💲 Currency Key (Currency):
ItemNetAmount	null
💲 Currency Key (PurReqnItemCurrency):
NetPriceAmount	null
PurchaseRequisitionPrice	Price in Purchase Requisition
ExpectedOverallLimitAmount	Expected Value of Overall Limit
OverallLimitAmount	Overall Limit

Column Name	Description
📏 Purchase requisition unit of measure (BaseUnit):
RequestedQuantity	Purchase requisition quantity

Column Name	Description
PurchaseRequisitionReleaseDate	Purchase Requisition Release Date
DeliveryDate	Item delivery date
PurReqCreationDate	Requisition (request) date
PerformancePeriodStartDate	Start Date for Period of Performance
PerformancePeriodEndDate	End Date for Period of Performance

Column Name	Description
PurReqnReleaseStatus	Requisition Processing State	Show values
ConsumptionPosting	Consumption posting	Show values
AccountAssignmentIsAddable	Boolean Variable (X = True, - = False, Space = Unknown)	Show values

Column Name	Description	Domain name
PurReqnPriceQuantity	Price unit
PurchaseRequisitionItemText	Short Text
CnsldtnMaterialText	Material Number
SourceOfSupply	Number of principal purchase agreement
UserDescription	User Description
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
AcctAssignmentCategoryName	Account Assignment Category Description
Supplier	Desired Vendor
PurchasingGroupName	Purchasing Group Name	TEXT18
FixedSupplier	Fixed Supplier of External System
SupplierName	Name of Supplier	TEXT80
FixedSupplierName	Name of Supplier	TEXT80
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
MultipleAcctAssgmtDistrName	Short Text for Fixed Values	DDTEXT
ProcurementHubSourceSystem	Connected System ID
ExtPlantForPurg	Plant of External System	WERKS
ExtPurgOrgForPurg	Purchasing Organization
ExtMaterialForPurg	Material of External System	MATNR
PurReqnSSPCatalog	Technical Key of a Web Service (for Example - a Catalog)	BBP_WS_SERVICE_ID
OpnCtlgWebServiceName	Description for a Web Service	CHAR60K
PurReqnSSPRequestor	Requestor
PurReqnRequestor	null
RequisitionerName	Name of requisitioner/requester	AFNAM
PurgDocItemCategoryName	Text for Item Category	TEXT20
ProductTypeCode	Product Type Group	CHAR2
ProductTypeName	Product Type Group Description	TEXT40
StorageLocationName	Storage Location Name	TEXT16

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_WORKITEMPURREQNHDRITEMDETAIL.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T163K.MANDT`
Purchase requisition unit of measure Purchase requisition unit of measure Purchase requisition unit of measure Client	`C_WORKITEMPURREQNHDRITEMDETAIL.ITEMUOM == T006.MSEHI` `C_WORKITEMPURREQNHDRITEMDETAIL.BASEUNIT == T006.MSEHI` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T006.MANDT`
Company code Company Code Client	`C_WORKITEMPURREQNHDRITEMDETAIL.COMPANYCODE == T001.BUKRS` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T001.MANDT`
Currency Key Client Currency Key Currency Key	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == TCURC.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.CURRENCY == TCURC.WAERS` `C_WORKITEMPURREQNHDRITEMDETAIL.PURREQNITEMCURRENCY == TCURC.WAERS`
Purchase requisition unit of measure Purchase requisition unit of measure Purchase requisition unit of measure Client	`C_WORKITEMPURREQNHDRITEMDETAIL.ITEMUOM == T006.MSEHI` `C_WORKITEMPURREQNHDRITEMDETAIL.BASEUNIT == T006.MSEHI` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T006.MANDT`
Material Number Client Material Number	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == MARA.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T023.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T001W.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.PLANT == T001W.WERKS`
Purchase Requisition Document Type ? Client Purchase Requisition Document Type	`C_WORKITEMPURREQNHDRITEMDETAIL.[column in domain "BSTYP"] == T161.BSTYP` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T161.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.PURCHASEREQUISITIONTYPE == T161.BSART`
Item category in purchasing document Item category in purchasing document Client	`C_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T163.MANDT`
Purchasing Group Client Purchasing Group	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T024.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T024E.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.PURCHASINGORGANIZATION == T024E.EKORG`
Currency Key Client Currency Key Currency Key	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == TCURC.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.CURRENCY == TCURC.WAERS` `C_WORKITEMPURREQNHDRITEMDETAIL.PURREQNITEMCURRENCY == TCURC.WAERS`
Storage location Storage location Client Plant	`C_WORKITEMPURREQNHDRITEMDETAIL.STORAGELOCATION == T001L.LGORT` `C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == T001L.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.PLANT == T001L.WERKS`
Workflow: Recipient of Work Item Client Workflow: Recipient of Work Item	`C_WORKITEMPURREQNHDRITEMDETAIL.MANDT == USR02.MANDT` `C_WORKITEMPURREQNHDRITEMDETAIL.WORKFLOWTASKRECIPIENT == USR02.BNAME`