C_PURDOCLISTGRQUANTITY

CDS View

GR Quantity

C_PURDOCLISTGRQUANTITY is a CDS View in S/4HANA. GR Quantity. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PurDocListInvoiceDetails view left_outer CONSUMPTION Invoice Details 
@AbapCatalog.sqlViewName: 'CDOCLGRQTY'
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'GR Quantity'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private : true


define view C_Purdoclistgrquantity as select from  C_Purdoclistgrreference as GR_MAP 
        inner join I_PurchaseOrderHistory as ekbe on GR_MAP.PurchaseOrder = ekbe.PurchaseOrder and GR_MAP.PurchaseOrderItem = ekbe.PurchaseOrderItem and 
                              ekbe.PurchaseOrderHistCategory = 'E' and GR_MAP.ReferenceDocument = ekbe.MaterialDocument and GR_MAP.ReferenceDocumentFiscalYear = ekbe.MaterialDocumentYear
                              and ekbe.MaterialDocumentItem = GR_MAP.AccountingDocumentItem1
         {
              key GR_MAP.InvoiceReference  as InvoiceReference,
              key GR_MAP.InvoiceReferenceFiscalYear as InvoiceReferenceFiscalYear,
              key cast(GR_MAP.MaterialDocumentItem as abap.char( 6 ) ) as AccountingDocumentItem,
              key GR_MAP.PurchaseOrder as PurchaseOrder,
              key GR_MAP.PurchaseOrderItem as PurchaseOrderItem ,
              sum(ekbe.Quantity) as GoodsMovementQuantity       
            } group by GR_MAP.InvoiceReference,GR_MAP.InvoiceReferenceFiscalYear,GR_MAP.MaterialDocumentItem,GR_MAP.PurchaseOrder,GR_MAP.PurchaseOrderItem

Learn More