P_ProductBatchNoPost

DDL: P_PRODUCTBATCHNOPOST Type: view_entity COMPOSITE
20 Fields 1 Data Sources

P_ProductBatchNoPost is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ProductBatchByInvStockType) and exposes 20 fields with key fields Material, Plant, StorageLocation, Batch, Supplier.

Data Sources (1)

SourceAliasJoin Type
P_ProductBatchByInvStockType _PhysInvtryIndBatchStorLoc 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_ProductBatchByInvStockType Material Vehicle Model
KEY Plant P_ProductBatchByInvStockType Plant Valuation Area
KEY StorageLocation P_ProductBatchByInvStockType StorageLocation
KEY Batch P_ProductBatchByInvStockType 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_ProductBatchNoPost.
-- 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_ProductBatchNoPost AS
SELECT
  _PhysInvtryIndBatchStorLoc.Material AS Material,
  _PhysInvtryIndBatchStorLoc.Plant AS Plant,
  _PhysInvtryIndBatchStorLoc.StorageLocation AS StorageLocation,
  _PhysInvtryIndBatchStorLoc.Batch 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_ProductBatchByInvStockType AS _PhysInvtryIndBatchStorLoc
;

Learn More