P_STKPOSTGHISTCANCELBASIC

CDS View

Stock posting history cancel documents

P_STKPOSTGHISTCANCELBASIC is a CDS View in S/4HANA. Stock posting history cancel documents. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_StkPostgHistBasicNoReversal view_entity union_all COMPOSITE Stock posting history documents without reversal 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Stock posting history cancel documents'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM:
      {
        viewType: #COMPOSITE,
        private: true
      }
define view entity P_StkPostgHistCancelBasic
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_StartDate : sydate,
    @Environment.systemField: #SYSTEM_DATE
    P_EndDate   : sydate

  as select from P_StkPostgHistCancelBasic01( P_StartDate: $parameters.P_StartDate, P_EndDate: $parameters.P_EndDate )
{
  key    MaterialDocument,
  key    MaterialDocumentYear,
  key    MaterialDocumentItem,
         MaterialDocumentRecordType,

         CostEstimate,
         CompanyCode,

         // stock fields for filter

         Material,
         Plant,
         StorageLocation,
         Batch,
         Supplier,
         SalesOrder,
         SalesOrderItem,
         WBSElementInternalID,
         Customer,
         InventoryStockType,
         InventorySpecialStockType,
         SpecialStockIdfgStockOwner,
         ResourceID,
         InventoryValuationType,

         // stock quantity

         MaterialBaseUnit,
         @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
         MatlStkChangeQtyInBaseUnit,

         CompanyCodeCurrency,
         @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
         GoodsMovementStkAmtInCCCrcy,

         // reference documents

         PurchaseOrder,
         PurchaseOrderItem,
         ManufacturingOrder,
         ManufacturingOrderItem,
         DeliveryDocument,
         DeliveryDocumentItem,
         Reservation,
         ReservationItem,

         // other fields

         GoodsMovementType,
         GoodsMovementRefDocType,
         GoodsReceiptType,
         ConsumptionPosting,
         PostingDate
}

union all

select from P_StkPostgHistCancelBasic02( P_StartDate: $parameters.P_StartDate, P_EndDate: $parameters.P_EndDate )
{
  key    MaterialDocument,
  key    MaterialDocumentYear,
  key    MaterialDocumentItem,
         MaterialDocumentRecordType,

         CostEstimate,
         CompanyCode,

         // stock fields for filter

         Material,
         Plant,
         StorageLocation,
         Batch,
         Supplier,
         SalesOrder,
         SalesOrderItem,
         WBSElementInternalID,
         Customer,
         InventoryStockType,
         InventorySpecialStockType,
         SpecialStockIdfgStockOwner,
         ResourceID,
         InventoryValuationType,

         // stock quantity

         MaterialBaseUnit,
         MatlStkChangeQtyInBaseUnit,

         CompanyCodeCurrency,
         GoodsMovementStkAmtInCCCrcy,

         // reference documents

         PurchaseOrder,
         PurchaseOrderItem,
         ManufacturingOrder,
         ManufacturingOrderItem,
         DeliveryDocument,
         DeliveryDocumentItem,
         Reservation,
         ReservationItem,

         // other fields

         GoodsMovementType,
         GoodsMovementRefDocType,
         GoodsReceiptType,
         ConsumptionPosting,
         PostingDate
}

Learn More