C_Purdoclistgrreference

DDL: C_PURDOCLISTGRREFERENCE SQL: CDOCLGRREF Type: view CONSUMPTION
9 Fields 2 Data Sources

GR Reference

C_Purdoclistgrreference is a Consumption CDS View that provides data about "GR Reference" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrderHistory, C_Purdoclistinvoiceitem) and exposes 9 fields with key fields InvoiceReference, InvoiceReferenceFiscalYear, MaterialDocumentItem, PurchaseOrder, PurchaseOrderItem.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrderHistory ekbe inner
C_Purdoclistinvoiceitem rseg from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDOCLGRREF view
VDM.viewType #CONSUMPTION view
EndUserText.label GR Reference view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InvoiceReference C_Purdoclistinvoiceitem InvoiceReference Invoice Reference
KEY InvoiceReferenceFiscalYear C_Purdoclistinvoiceitem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
KEY MaterialDocumentItem I_PurchaseOrderHistory MaterialDocumentItem Material Document Item
KEY PurchaseOrder C_Purdoclistinvoiceitem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem C_Purdoclistinvoiceitem PurchaseOrderItem Purchasing Document Item
ReferenceDocument I_PurchaseOrderHistory ReferenceDocument Reference Document
ReferenceDocumentFiscalYear I_PurchaseOrderHistory ReferenceDocumentFiscalYear Year Cur.Period
ReferenceDocumentItem I_PurchaseOrderHistory ReferenceDocumentItem Reference item
AccountingDocumentItem1

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Purdoclistgrreference.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CDOCLGRREF

CREATE VIEW C_Purdoclistgrreference AS
SELECT
  rseg.InvoiceReference AS InvoiceReference,
  rseg.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  ekbe.MaterialDocumentItem AS MaterialDocumentItem,
  rseg.PurchaseOrder AS PurchaseOrder,
  rseg.PurchaseOrderItem AS PurchaseOrderItem,
  ekbe.ReferenceDocument AS ReferenceDocument,
  ekbe.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  ekbe.ReferenceDocumentItem AS ReferenceDocumentItem,
  cast(ekbe.MaterialDocumentItem as abap.char( 6 )) AS AccountingDocumentItem1
FROM C_Purdoclistinvoiceitem AS rseg
INNER JOIN I_PurchaseOrderHistory AS ekbe ON /* join condition not captured in parsed metadata */
;

Learn More