P_ProductStorageLocationNoPost

DDL: P_PRODUCTSTORAGELOCATIONNOPOST Type: view_entity COMPOSITE Package: MM_IM_VDM_COMMON
20 Fields 1 Data Sources

Never Posted Product Storage Location Data

P_ProductStorageLocationNoPost is a Composite CDS View that provides data about "Never Posted Product Storage Location Data" in SAP S/4HANA. It reads from 1 data source (P_ProductStorLocByInvStockType) and exposes 20 fields with key fields Material, Plant, StorageLocation, Batch, Supplier. Part of development package MM_IM_VDM_COMMON.

Data Sources (1)

SourceAliasJoin Type
P_ProductStorLocByInvStockType _ProductStorageLocationBasic from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Material P_ProductStorLocByInvStockType Product Product Sold
KEY Plant P_ProductStorLocByInvStockType Plant Valuation Area
KEY StorageLocation P_ProductStorLocByInvStockType StorageLocation
KEY Batch
KEY Supplier
KEY SalesOrder Stock Ident Header
KEY SalesOrderItem Stock Ident Item
KEY WBSElementInternalID _MaterialDocumentExtract SpecialStockIdfgWBSElement WBS Internal ID
KEY Customer
KEY StockOwner
KEY Plant Plant Valuation Area
KEY StorageLocation StockIdfgStorageLocation
KEY Batch StockIdentifyingBatch
KEY Supplier
KEY SalesOrder Stock Ident Header
KEY SalesOrderItem Stock Ident Item
KEY WBSElementInternalID SpecialStockIdfgWBSElement WBS Internal ID
KEY Customer
KEY StockOwner
KEY InventoryStockType InventoryStockType Stock Type

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_ProductStorageLocationNoPost.
-- 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.

CREATE VIEW P_ProductStorageLocationNoPost AS
SELECT
  _ProductStorageLocationBasic.Product AS Material,
  _ProductStorageLocationBasic.Plant AS Plant,
  _ProductStorageLocationBasic.StorageLocation AS StorageLocation,
  cast(_MaterialDocumentExtract.StockIdentifyingBatch as charg_d preserving type) AS Batch,
  cast(_MaterialDocumentExtract.SpecialStockIdfgSupplier as elifn preserving type) AS Supplier,
  cast(_MaterialDocumentExtract.SpecialStockIdfgSalesOrder as kdauf preserving type) AS SalesOrder,
  cast(_MaterialDocumentExtract.SpecialStockIdfgSalesOrderItem as pi_sales_order_item preserving type) AS SalesOrderItem,
  _MaterialDocumentExtract.SpecialStockIdfgWBSElement AS WBSElementInternalID,
  cast(_MaterialDocumentExtract.SpecialStockIdfgCustomer as ekunn preserving type) AS Customer,
  cast(_MaterialDocumentExtract.SpecialStockIdfgStockOwner as pi_owner_of_stock preserving type) AS StockOwner,
  InventoryStockType
FROM P_ProductStorLocByInvStockType AS _ProductStorageLocationBasic
;

Learn More