P_ARunAssgmtSup

DDL: P_ARUNASSGMTSUP Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS_ALL
14 Fields 1 Data Sources

View for Supply Assignment Results from Supply Perspective

P_ARunAssgmtSup is a Composite CDS View that provides data about "View for Supply Assignment Results from Supply Perspective" in SAP S/4HANA. It reads from 1 data source (I_ARunAllSupAssgmt) and exposes 14 fields. Part of development package VDM_ARUN_ANALYTICS_ALL.

Data Sources (1)

SourceAliasJoin Type
I_ARunAllSupAssgmt Assgmt from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PARUNASSGMTSUP view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (14)

KeyFieldSource TableSource FieldDescription
Batch I_ARunAllSupAssgmt Batch Lot No.
StorageLocation I_ARunAllSupAssgmt StorageLocation StorageLocation
SupplyNumber I_ARunAllSupAssgmt SupplyNumber
SupplyItem I_ARunAllSupAssgmt SupplyItem
SupplyScheduleLine I_ARunAllSupAssgmt SupplyScheduleLine
AssignedSupplyType I_ARunAllSupAssgmt AssignedSupplyType Supply Type
SupAssgmtSource I_ARunAllSupAssgmt SupAssgmtSource Stock Source
Material I_ARunAllSupAssgmt Material Vehicle Model
Plant I_ARunAllSupAssgmt Plant Valuation Area
AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt
ARunTmpAssignedQuantityInBsUnt
BaseUnit I_ARunAllSupAssgmt BaseUnit Unit of Measure

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_ARunAssgmtSup.
-- 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_ARunAssgmtSup AS
SELECT
  Assgmt.Batch AS Batch,
  Assgmt.StorageLocation AS StorageLocation,
  Assgmt.SupplyNumber AS SupplyNumber,
  Assgmt.SupplyItem AS SupplyItem,
  Assgmt.SupplyScheduleLine AS SupplyScheduleLine,
  Assgmt.AssignedSupplyType AS AssignedSupplyType,
  Assgmt.SupAssgmtSource AS SupAssgmtSource,
  Assgmt.Material AS Material,
  Assgmt.Plant AS Plant,
  sum(Assgmt.AssignedQuantityInBaseUnit) AS AssignedQuantityInBaseUnit,
  sum(Assgmt.NormalAssignedQuantityInBsUnt) AS NormalAssignedQuantityInBsUnt,
  sum(Assgmt.PreviewAssignedQuantityInBsUnt) AS PreviewAssignedQuantityInBsUnt,
  sum(Assgmt.ARunTmpAssignedQuantityInBsUnt) AS ARunTmpAssignedQuantityInBsUnt,
  Assgmt.BaseUnit AS BaseUnit
FROM I_ARunAllSupAssgmt AS Assgmt
;

Learn More