I_SupAssgmtBlkdSlsOrdItmsC

DDL: I_SUPASSGMTBLKDSLSORDITMSC Type: view COMPOSITE Package: VDM_ARUN_ANALYTICS
33 Fields 1 Data Sources 3 Associations

Supply Assignment Blocked Sales Order Item Details

I_SupAssgmtBlkdSlsOrdItmsC is a Composite CDS View (Cube) that provides data about "Supply Assignment Blocked Sales Order Item Details" in SAP S/4HANA. It reads from 1 data source (I_SupAssgmtBlkdSlsOrdItms) and exposes 33 fields with key fields RequirementDocumentNumber, RequirementDocumentItem, Issue. It has 3 associations to related views. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_SupAssgmtBlkdSlsOrdItms Demand from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure
[0..1] I_Currency _DisplayCurrency $projection.DisplayCurrency = _DisplayCurrency.Currency
[0..1] I_Currency _DocCurrency $projection.DocumentCurrency = _DocCurrency.Currency

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISUPAGMTBLSOIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Supply Assignment Blocked Sales Order Item Details view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY RequirementDocumentNumber RequirementDocumentNumber Requirement Document Number
KEY RequirementDocumentItem RequirementDocumentItem Requirement Document Item
KEY Issue Issue Date of Issue
IssueCategory IssueCategory Issue Category
NumberOfSalesOrderItems NumberOfSalesOrderItems Number of Sales Order Items
ARunDocumentItemUniqueID ARunDocumentItemUniqueID Requirement Document/Item
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequirementType RequirementType Requirement Type
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit Ordered Quantity
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit Delivered Quantity
OpenDemandQuantity OpenDemandQuantity Open Demand Quantity
BaseUnit BaseUnit Unit of Measure
SupAssgmtAggrgQtyUnit
Material I_SupAssgmtBlkdSlsOrdItms Material Product
MaterialGroup I_SupAssgmtBlkdSlsOrdItms MaterialGroup Product Group
MaterialType MaterialType Product Type
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Generic Article
Plant I_SupAssgmtBlkdSlsOrdItms Plant Valuation Area
RequirementSegment RequirementSegment Req. Segment
SalesOrganizationendasSalesOrganization
DivisionendasDivision
SalesDistrictendasSalesDistrict
CompanyCodeendasCompanyCode
CustomeraskunnrendasCustomer
StorageLocation StorageLocation StorageLocation
ActlAmt ActlAmt
NetPriceAmount NetPriceAmount Net Price
DocumentCurrency DocumentCurrency Document Currency
DisplayCurrency
_SupDmndPlant _SupDmndPlant
_BaseUnit _BaseUnit
_DocCurrency _DocCurrency
_DisplayCurrency _DisplayCurrency

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 I_SupAssgmtBlkdSlsOrdItmsC.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_SupAssgmtBlkdSlsOrdItmsC AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  Issue,
  IssueCategory,
  NumberOfSalesOrderItems,
  ARunDocumentItemUniqueID,
  RequestedDeliveryDate,
  RequirementType,
  RequestedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  OpenDemandQuantity,
  BaseUnit,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit,
  Demand.Material AS Material,
  Demand.MaterialGroup AS MaterialGroup,
  MaterialType,
  CrossPlantConfigurableProduct,
  Demand.Plant AS Plant,
  RequirementSegment,
  case when Demand.SalesOrganization is initial then coalesce( _SupDmndPlant.SalesOrganization, '' ) else Demand.SalesOrganization end as SalesOrganization AS SalesOrganizationendasSalesOrganization,
  case when Demand.Division is initial then coalesce( _SupDmndPlant.Division, '' ) else Demand.Division end as Division AS DivisionendasDivision,
  case when Demand.SalesDistrict is initial then coalesce( _SupDmndPlant.SalesDistrict, '' ) else Demand.SalesDistrict end as SalesDistrict AS SalesDistrictendasSalesDistrict,
  case when Demand.CompanyCode is initial then coalesce( _SupDmndPlant.CompanyCode, '' ) else Demand.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  case when Demand.Customer is initial then cast( coalesce( _SupDmndPlant.PlantCustomer, '' ) as kunnr ) else cast( Demand.Customer as kunnr ) end as Customer AS CustomeraskunnrendasCustomer,
  StorageLocation,
  ActlAmt,
  NetPriceAmount,
  DocumentCurrency,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency
FROM I_SupAssgmtBlkdSlsOrdItms AS Demand
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocCurrency ON DocumentCurrency = _DocCurrency.Currency  -- association [0..1]
;

Learn More