C_PurDocListPRDetails

Purchase Requisition Details | view: CDOCLPRDETAILS | Extraction: Not supported | Component: Purchasing

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EBKN, PRTE, LFA1, ADRC, LFA1, TKA01, CSKS, CSKT, FM01, T001W, PROJ, T024, T024E, T000, T001K, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE

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

Column Name	Description
PurchaseRequisition	Purchase requisition number
PurchaseRequisitionItem	Item number of purchase requisition
PurchaseReqnAcctAssgmtNumber	Serial number for PReq account assignment segment

Column Name	Description
💲 Currency Key (PurgDocTransactionCurrency):
MaterialComponentPrice	Price in Purchase Requisition

Column Name	Description
📏 Purchase requisition unit of measure (MaterialBaseUnit):
Quantity	Purchase requisition quantity
OrderedQuantity	Quantity ordered against this purchase requisition

Column Name	Description
PurReqCreationDate	Requisition (request) date
DeliveryDate	Item delivery date

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
ProcessingStatus	Processing status of purchase requisition	Show values
PurchaseRequisitionStatus	Requisition Processing State	Show values
IsEndOfPurposeBlocked	Business Purpose Completed	Show values

Column Name	Description	Domain name
IsDeleted	Deletion Indicator in Purchasing Document	ELOEK
PurchaseRequisitionItemText	Short Text	TEXT40
RequisitionerUser	Name of requisitioner/requester	AFNAM
SupplierAddressCity	City	TEXT40
SupplyingPlant	Supplying (issuing) plant in case of stock transport order	WERKS
SupplyingPlantName	Plant Name	TEXT30
CostCenterName	Cost Center Name	TEXT20
MaterialPriceUnitQty	Price unit	DEC5
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
SupplierName	Name 1	NAME
VendorSearchText	Sort field	CHAR10
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PlantName	Plant Name	TEXT30
ServicePerformer	null
ServicePerformerName	null
WorkItem	null
cntb	null
WBSElementExternalID	Work Breakdown Structure Element (WBS Element)	PS_POSID
WorkPackageFullName	null
SalesOrder	Sales and Distribution Document Number	VBELN
status	null
vendor	null
vendorName	Name 1	NAME

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_PURDOCLISTPRDETAILS.ACCTASSIGNMENTCATEGORY == T163K.KNTTP` `C_PURDOCLISTPRDETAILS.MANDT == T163K.MANDT`
Controlling Area Controlling Area Client	`C_PURDOCLISTPRDETAILS.CONTROLLINGAREA == TKA01.KOKRS` `C_PURDOCLISTPRDETAILS.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`C_PURDOCLISTPRDETAILS.[column in domain "DATBI"] == CSKS.DATBI` `C_PURDOCLISTPRDETAILS.CONTROLLINGAREA == CSKS.KOKRS` `C_PURDOCLISTPRDETAILS.COSTCENTER == CSKS.KOSTL` `C_PURDOCLISTPRDETAILS.MANDT == CSKS.MANDT`
Fixed Vendor Fixed Vendor Client	`C_PURDOCLISTPRDETAILS.FIXEDSUPPLIER == LFA1.LIFNR` `C_PURDOCLISTPRDETAILS.MANDT == LFA1.MANDT`
Material number corresponding to manufacturer part number Material number corresponding to manufacturer part number Client	`C_PURDOCLISTPRDETAILS.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURDOCLISTPRDETAILS.MANDT == MARA.MANDT`
Material Number Material Number Client	`C_PURDOCLISTPRDETAILS.MATERIAL == MARA.MATNR` `C_PURDOCLISTPRDETAILS.MANDT == MARA.MANDT`
Purchase requisition unit of measure Client Purchase requisition unit of measure	`C_PURDOCLISTPRDETAILS.MANDT == T006.MANDT` `C_PURDOCLISTPRDETAILS.MATERIALBASEUNIT == T006.MSEHI`
Material Group Material Group Client	`C_PURDOCLISTPRDETAILS.MATERIALGROUP == T023.MATKL` `C_PURDOCLISTPRDETAILS.MANDT == T023.MANDT`
Plant Plant Client	`C_PURDOCLISTPRDETAILS.PLANT == T001W.WERKS` `C_PURDOCLISTPRDETAILS.MANDT == T001W.MANDT`
Order Number Order Number Client	`C_PURDOCLISTPRDETAILS.PRODUCTIONORDER == AUFK.AUFNR` `C_PURDOCLISTPRDETAILS.MANDT == AUFK.MANDT`
Item category in purchasing document Item category in purchasing document Client	`C_PURDOCLISTPRDETAILS.PURCHASEORDERITEMCATEGORY == T163.PSTYP` `C_PURDOCLISTPRDETAILS.MANDT == T163.MANDT`
Purchase Requisition Document Type Purchase Requisition Document Type Purchasing Document Category Client	`C_PURDOCLISTPRDETAILS.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURDOCLISTPRDETAILS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `C_PURDOCLISTPRDETAILS.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`C_PURDOCLISTPRDETAILS.PURCHASINGGROUP == T024.EKGRP` `C_PURDOCLISTPRDETAILS.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`C_PURDOCLISTPRDETAILS.PURCHASINGINFORECORD == EINA.INFNR` `C_PURDOCLISTPRDETAILS.MANDT == EINA.MANDT`
Purchasing organization Purchasing organization Client	`C_PURDOCLISTPRDETAILS.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURDOCLISTPRDETAILS.MANDT == T024E.MANDT`
Currency Key Currency Key Client	`C_PURDOCLISTPRDETAILS.PURGDOCTRANSACTIONCURRENCY == TCURC.WAERS` `C_PURDOCLISTPRDETAILS.MANDT == TCURC.MANDT`
Desired Vendor Desired Vendor Client	`C_PURDOCLISTPRDETAILS.SUPPLIER == LFA1.LIFNR` `C_PURDOCLISTPRDETAILS.MANDT == LFA1.MANDT`
Country key Client Country/Region Key	`C_PURDOCLISTPRDETAILS.MANDT == T005.MANDT` `C_PURDOCLISTPRDETAILS.SUPPLIERADDRESSCOUNTRY == T005.LAND1`