C_PurDocListGRDetails

Goods Receipt Details | view: CDOCLGRDTL | Extraction: Not supported | Component: Purchasing

Tables used: MATDOC, EKKO, EKPO, EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, LFA1, ADRC, LFA1, BUT000, KNA1, T001W, LFA1, T163B, T024, T024E, LFA1, /CPD/FC_WRK_ID, T161M

🔑 Keys (4)
💰 Amounts
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (1)
Other (22)
🔗 Relations (16)

Column Name	Description
PurchasingDocument	Number of Material Document
MaterialDocumentYear	Material Document Year
PurchasingDocumentItem	Item in Material Document
AccountAssignmentNumber	Sequential Number of Account Assignment

Column Name	Description

Column Name	Description
PurchaseOrderQty	Purchase Order Quantity
Quantity	Quantity

Column Name	Description
DeliveryDate	Item delivery date
PostingDate	Posting Date in the Document

Column Name	Description
IsEndOfPurposeBlocked	Business Purpose Completed	Show values

Column Name	Description	Domain name
GoodsMovementType1	null
SupplyingPlantName	Plant Name	TEXT30
SupplierName	Name 1	NAME
SupplierAddressCity	City	TEXT40
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PlantName	Plant Name	TEXT30
PurchasingDocumentItemText	Short Text	TEXT40
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingDocumentCategory	null
PurchaseOrderItemCategory	null
AccountAssignmentCategory	null
WBSElementInternalID	null
WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
WorkPackageFullName	null
SalesOrder	Sales and Distribution Document Number	VBELN
CostCenter	Cost Center	KOSTL
CostCenterName	Cost Center Name	TEXT20
ControllingArea	Controlling Area	CACCD
cntg	null
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID
ServicePerformer	Service Performer	BU_PARTNER
ServicePerformerName	null

Master Data Relations	Join Conditions
Movement type (inventory management) Client Movement type (inventory management)	`C_PURDOCLISTGRDETAILS.MANDT == T156.MANDT` `C_PURDOCLISTGRDETAILS.GOODSMOVEMENTTYPE == T156.BWART`
Material number Client Material number	`C_PURDOCLISTGRDETAILS.MANDT == MARA.MANDT` `C_PURDOCLISTGRDETAILS.MANUFACTURERMATERIAL == MARA.MATNR`
Material Number Client Material Number	`C_PURDOCLISTGRDETAILS.MANDT == MARA.MANDT` `C_PURDOCLISTGRDETAILS.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_PURDOCLISTGRDETAILS.MANDT == T023.MANDT` `C_PURDOCLISTGRDETAILS.MATERIALGROUP == T023.MATKL`
Plant Client Plant	`C_PURDOCLISTGRDETAILS.MANDT == T001W.MANDT` `C_PURDOCLISTGRDETAILS.PLANT == T001W.WERKS`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PURDOCLISTGRDETAILS.MANDT == T006.MANDT` `C_PURDOCLISTGRDETAILS.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Client Purchase Order Type Purchase Order Type ?	`C_PURDOCLISTGRDETAILS.MANDT == T161.MANDT` `C_PURDOCLISTGRDETAILS.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURDOCLISTGRDETAILS.PURCHASEORDERTYPE == T161.BSART` `C_PURDOCLISTGRDETAILS.[column in domain "BSTYP"] == T161.BSTYP`
Item category in purchasing document Client Item category in purchasing document	`C_PURDOCLISTGRDETAILS.MANDT == T163.MANDT` `C_PURDOCLISTGRDETAILS.PURCHASINGDOCUMENTCATEGORY1 == T163.PSTYP`
Purchase Order Type Client Purchase Order Type Purchase Order Type ?	`C_PURDOCLISTGRDETAILS.MANDT == T161.MANDT` `C_PURDOCLISTGRDETAILS.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURDOCLISTGRDETAILS.PURCHASEORDERTYPE == T161.BSART` `C_PURDOCLISTGRDETAILS.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Client Purchasing Group	`C_PURDOCLISTGRDETAILS.MANDT == T024.MANDT` `C_PURDOCLISTGRDETAILS.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`C_PURDOCLISTGRDETAILS.MANDT == T024E.MANDT` `C_PURDOCLISTGRDETAILS.PURCHASINGORGANIZATION == T024E.EKORG`
Supplier Client Supplier	`C_PURDOCLISTGRDETAILS.MANDT == LFA1.MANDT` `C_PURDOCLISTGRDETAILS.SUPPLIER == LFA1.LIFNR`
Country key Client Country/Region Key	`C_PURDOCLISTGRDETAILS.MANDT == T005.MANDT` `C_PURDOCLISTGRDETAILS.SUPPLIERADDRESSCOUNTRY == T005.LAND1`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`C_PURDOCLISTGRDETAILS.MANDT == T001W.MANDT` `C_PURDOCLISTGRDETAILS.SUPPLYINGPLANT == T001W.WERKS`