C_PRForGoodsReceipt

Purchase Requisitions Open for GR | view: CPRFORGR | Extraction: Not supported | Component: Purchase Requisitions

Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, EBAN, EKKO, EKPO, EKET, USR21, FM01, T001W, T001K, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, MMPUR_C_BE_SYREG, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (10)
🔗 Relations (9)

Column Name	Description
PurchaseRequisition	Purchase requisition number
PurchaseOrder FK	Purchasing Document Number

Column Name	Description
💲 null (Currency):
TotalNetAmount	null

Column Name	Description

Column Name	Description
CreationDate	Requisition (request) date

Column Name	Description

Column Name	Description	Domain name
PurReqnDescription	null
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
PurchasingGroupName	null
NumberOfItems	null
ProcurementHubSourceSystem	Connected System ID
ProcmtHubPlant	Plant of External System	WERKS
CompanyCode	Company Code of External System	BUKRS
PurReqnSSPRequestor	Requestor
IsExtPurgScenario	null
SitnInstceAnchorObjectKey	Key to identify purchase requisition item	MM_PUR_PR_ITEM_KEY

Master Data Relations	Join Conditions
Plant Plant Plant Client	`C_PRFORGOODSRECEIPT.PURORDERITEMPLANT == T001W.WERKS` `C_PRFORGOODSRECEIPT.PLANT == T001W.WERKS` `C_PRFORGOODSRECEIPT.MANDT == T001W.MANDT`
Purchase Order Type Purchase Requisition Document Type Purchase Order Type ? Client	`C_PRFORGOODSRECEIPT.PURCHASEREQUISITIONTYPE == T161.BSART` `C_PRFORGOODSRECEIPT.PURCHASEORDERTYPE == T161.BSART` `C_PRFORGOODSRECEIPT.[column in domain "BSTYP"] == T161.BSTYP` `C_PRFORGOODSRECEIPT.MANDT == T161.MANDT`
Purchase Requisition Document Type Purchase Requisition Document Type Purchase Order Type ? Client	`C_PRFORGOODSRECEIPT.PURCHASEREQUISITIONTYPE == T161.BSART` `C_PRFORGOODSRECEIPT.PURCHASEORDERTYPE == T161.BSART` `C_PRFORGOODSRECEIPT.[column in domain "BSTYP"] == T161.BSTYP` `C_PRFORGOODSRECEIPT.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Purchasing Group Client	`C_PRFORGOODSRECEIPT.PURCHASINGGROUP == T024.EKGRP` `C_PRFORGOODSRECEIPT.PURORDPURCHASINGGROUP == T024.EKGRP` `C_PRFORGOODSRECEIPT.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Purchasing organization Client	`C_PRFORGOODSRECEIPT.PURORDPURCHASINGORGANIZATION == T024E.EKORG` `C_PRFORGOODSRECEIPT.PURCHASINGORGANIZATION == T024E.EKORG` `C_PRFORGOODSRECEIPT.MANDT == T024E.MANDT`
Plant Plant Plant Client	`C_PRFORGOODSRECEIPT.PURORDERITEMPLANT == T001W.WERKS` `C_PRFORGOODSRECEIPT.PLANT == T001W.WERKS` `C_PRFORGOODSRECEIPT.MANDT == T001W.MANDT`
Purchasing Group Purchasing Group Purchasing Group Client	`C_PRFORGOODSRECEIPT.PURCHASINGGROUP == T024.EKGRP` `C_PRFORGOODSRECEIPT.PURORDPURCHASINGGROUP == T024.EKGRP` `C_PRFORGOODSRECEIPT.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Purchasing organization Client	`C_PRFORGOODSRECEIPT.PURORDPURCHASINGORGANIZATION == T024E.EKORG` `C_PRFORGOODSRECEIPT.PURCHASINGORGANIZATION == T024E.EKORG` `C_PRFORGOODSRECEIPT.MANDT == T024E.MANDT`