P_StkPostgHistCancelBasic

DDL: P_STKPOSTGHISTCANCELBASIC Type: view_entity COMPOSITE Package: ODATA_MM_IM_STOCKINDATERANGE
74 Fields 2 Data Sources

Stock posting history cancel documents

P_StkPostgHistCancelBasic is a Composite CDS View that provides data about "Stock posting history cancel documents" in SAP S/4HANA. It reads from 2 data sources (P_StkPostgHistCancelBasic01, P_StkPostgHistCancelBasic02) and exposes 74 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem, MaterialDocumentYear, MaterialDocumentItem. Part of development package ODATA_MM_IM_STOCKINDATERANGE.

Data Sources (2)

SourceAliasJoin Type
P_StkPostgHistCancelBasic01 P_StkPostgHistCancelBasic01 from
P_StkPostgHistCancelBasic02 P_StkPostgHistCancelBasic02 union_all

Parameters (2)

NameTypeDefault
P_StartDate sydate
P_EndDate sydate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Stock posting history cancel documents view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentRecordType MaterialDocumentRecordType
CostEstimate CostEstimate Cost EstimateNo
CompanyCode CompanyCode Receiver Company Code
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
Supplier Supplier Supplier
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
Customer Customer Sold-to Party
InventoryStockType InventoryStockType Stock Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner
ResourceID ResourceID Vehicle ID
InventoryValuationType InventoryValuationType Valuation Type
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementRefDocType GoodsMovementRefDocType Reference Doc. Type
GoodsReceiptType GoodsReceiptType
ConsumptionPosting ConsumptionPosting Consumption Posting
P_StartDate
P_EndDatekeyMaterialDocument
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentRecordType MaterialDocumentRecordType
CostEstimate CostEstimate Cost EstimateNo
CompanyCode CompanyCode Receiver Company Code
Material Material Vehicle Model
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
Supplier Supplier Supplier
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
Customer Customer Sold-to Party
InventoryStockType InventoryStockType Stock Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner
ResourceID ResourceID Vehicle ID
InventoryValuationType InventoryValuationType Valuation Type
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit
CompanyCodeCurrency CompanyCodeCurrency Local Currency
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementRefDocType GoodsMovementRefDocType Reference Doc. Type
GoodsReceiptType GoodsReceiptType
ConsumptionPosting ConsumptionPosting Consumption Posting
PostingDate PostingDate Posting Date for GR

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 P_StkPostgHistCancelBasic.
-- 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.
-- Parameters: P_StartDate : sydate, P_EndDate : sydate

CREATE VIEW P_StkPostgHistCancelBasic AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  MaterialDocumentRecordType,
  CostEstimate,
  CompanyCode,
  Material,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  Customer,
  InventoryStockType,
  InventorySpecialStockType,
  SpecialStockIdfgStockOwner,
  ResourceID,
  InventoryValuationType,
  MaterialBaseUnit,
  MatlStkChangeQtyInBaseUnit,
  CompanyCodeCurrency,
  GoodsMovementStkAmtInCCCrcy,
  PurchaseOrder,
  PurchaseOrderItem,
  ManufacturingOrder,
  ManufacturingOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  Reservation,
  ReservationItem,
  GoodsMovementType,
  GoodsMovementRefDocType,
  GoodsReceiptType,
  ConsumptionPosting,
  PostingDate AS P_StartDate,
  PostingDate
FROM P_StkPostgHistCancelBasic01
-- UNION ALL with additional select branch(es): P_StkPostgHistCancelBasic02
;

Learn More