C_Purdoclistgrreference

DDL: C_PURDOCLISTGRREFERENCE SQL: CDOCLGRREF Type: view CONSUMPTION

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.

2 data source(s) 9 fields

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
KEY InvoiceReferenceFiscalYear C_Purdoclistinvoiceitem InvoiceReferenceFiscalYear
KEY MaterialDocumentItem I_PurchaseOrderHistory MaterialDocumentItem
KEY PurchaseOrder C_Purdoclistinvoiceitem PurchaseOrder
KEY PurchaseOrderItem C_Purdoclistinvoiceitem PurchaseOrderItem
ReferenceDocument I_PurchaseOrderHistory ReferenceDocument
ReferenceDocumentFiscalYear I_PurchaseOrderHistory ReferenceDocumentFiscalYear
ReferenceDocumentItem I_PurchaseOrderHistory ReferenceDocumentItem
AccountingDocumentItem1 
@AbapCatalog.sqlViewName: 'CDOCLGRREF'
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'GR Reference'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private : true

define view C_Purdoclistgrreference as select from C_Purdoclistinvoiceitem  as rseg 
                  inner join I_PurchaseOrderHistory as ekbe on rseg.InvoiceReference = ekbe.MaterialDocument and rseg.InvoiceReferenceFiscalYear = ekbe.MaterialDocumentYear 
                  and rseg.PurchaseOrder = ekbe.PurchaseOrder and rseg.PurchaseOrderItem = ekbe.PurchaseOrderItem and ekbe.PurchaseOrderHistCategory = 'Q'
                  and rseg.AccountingDocumentItem1 = ekbe.MaterialDocumentItem 
         {
         
         key rseg.InvoiceReference,
         key rseg.InvoiceReferenceFiscalYear,
         key ekbe.MaterialDocumentItem,
         key rseg.PurchaseOrder,
         key rseg.PurchaseOrderItem,
         ekbe.ReferenceDocument,
         ekbe.ReferenceDocumentFiscalYear,
         ekbe.ReferenceDocumentItem,
         cast(ekbe.MaterialDocumentItem as abap.char( 6 )) as AccountingDocumentItem1
         } where ekbe.ReferenceDocument <> ''                 
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_PURDOCLISTINVOICEITEM",
"I_PURCHASEORDERHISTORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More