P_StkBalInitAndDelivs

DDL: P_STKBALINITANDDELIVS SQL: PSTKBALAVAILDEL Type: view CONSUMPTION Package: ODATA_MM_PUR_SUBCONTRG_COCKPIT
6 Fields 3 Associations

Stock Balance Initial And Delivs

P_StkBalInitAndDelivs is a Consumption CDS View that provides data about "Stock Balance Initial And Delivs" in SAP S/4HANA. It has 3 associations to related views. Part of development package ODATA_MM_PUR_SUBCONTRG_COCKPIT.

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_StkAvailyAndStkResvn _AvailSubcontrgStock $projection.Material = _AvailSubcontrgStock.Material and $projection.Plant = _AvailSubcontrgStock.Plant and $projection.Supplier = _AvailSubcontrgStock.Supplier
[0..1] P_OpenDelivery _OpenDelivery $projection.Material = _OpenDelivery.Material and $projection.Plant = _OpenDelivery.Plant and $projection.Supplier = _OpenDelivery.Supplier
[0..1] ftg_enabled _FeatureToggle _FeatureToggle.ftg_id = 'MM_PUR_PROJECT_BASED_SUBCONTRG'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSTKBALAVAILDEL view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Stock Balance Initial And Delivs view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY Supplier Supplier Supplier
InitAvailQtySubcontrg _AvailSubcontrgStock InitAvailQtySubcontrg
InitialAndStockTransferQty _AvailSubcontrgStock InitialAndStockTransferQty
ActualDeliveryQuantity _OpenDelivery ActualDeliveryQuantity Base quantity

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_StkBalInitAndDelivs.
-- 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.
-- SQL view name: PSTKBALAVAILDEL

CREATE VIEW P_StkBalInitAndDelivs AS
SELECT
  Material,
  Plant,
  Supplier,
  _AvailSubcontrgStock.InitAvailQtySubcontrg AS InitAvailQtySubcontrg,
  _AvailSubcontrgStock.InitialAndStockTransferQty AS InitialAndStockTransferQty,
  _OpenDelivery.ActualDeliveryQuantity AS ActualDeliveryQuantity
LEFT OUTER JOIN P_StkAvailyAndStkResvn AS _AvailSubcontrgStock ON Material = _AvailSubcontrgStock.Material AND Plant = _AvailSubcontrgStock.Plant AND Supplier = _AvailSubcontrgStock.Supplier  -- association [0..1]
LEFT OUTER JOIN P_OpenDelivery AS _OpenDelivery ON Material = _OpenDelivery.Material AND Plant = _OpenDelivery.Plant AND Supplier = _OpenDelivery.Supplier  -- association [0..1]
LEFT OUTER JOIN ftg_enabled AS _FeatureToggle ON _FeatureToggle.ftg_id = 'MM_PUR_PROJECT_BASED_SUBCONTRG'  -- association [0..1]
;

Learn More