P_PhysInvtryNotPostedBatch_L2

DDL: P_PHYSINVTRYNOTPOSTEDBATCH_L2 Type: view_entity COMPOSITE Package: ODATA_MM_IM_PI_MASS_CREATE
20 Fields 1 Data Sources

Not posted batch master

P_PhysInvtryNotPostedBatch_L2 is a Composite CDS View that provides data about "Not posted batch master" in SAP S/4HANA. It reads from 1 data source (P_PhysInvtryNotPostedBatch_L1) and exposes 20 fields with key fields Material, Plant, StorageLocation, Batch, Supplier. Part of development package ODATA_MM_IM_PI_MASS_CREATE.

Data Sources (1)

SourceAliasJoin Type
P_PhysInvtryNotPostedBatch_L1 _PhysInvtryIndBatchStorLoc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Not posted batch master view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Material P_PhysInvtryNotPostedBatch_L1 Material Vehicle Model
KEY Plant P_PhysInvtryNotPostedBatch_L1 Plant Valuation Area
KEY StorageLocation P_PhysInvtryNotPostedBatch_L1 StorageLocation
KEY Batch P_PhysInvtryNotPostedBatch_L1 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_PhysInvtryNotPostedBatch_L2.
-- 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_PhysInvtryNotPostedBatch_L2 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_PhysInvtryNotPostedBatch_L1 AS _PhysInvtryIndBatchStorLoc
;

Learn More