I_SubcontractingPurDocHier

DDL: I_SUBCONTRACTINGPURDOCHIER Type: view_entity COMPOSITE Package: ODATA_MM_PUR_SUBCONTRG_COCKPIT
31 Fields 1 Data Sources 1 Associations

Subcontracting Cockpit Pur Doc Hierarchy

I_SubcontractingPurDocHier is a Composite CDS View that provides data about "Subcontracting Cockpit Pur Doc Hierarchy" in SAP S/4HANA. It reads from 1 data source (P_SubcontractingHierNodeBase) and exposes 31 fields with key fields MaterialComponent, Plant, Subcontractor, Reservation, ReservationItem. It has 1 association to related views. Part of development package ODATA_MM_PUR_SUBCONTRG_COCKPIT.

Data Sources (1)

SourceAliasJoin Type
P_SubcontractingHierNodeBase P_SubcontractingHierNodeBase from

Parameters (2)

NameTypeDefault
P_ReqdDelivDteRngeFrmDte vdm_shippingdate
P_ReqdDelivDteRngeToDte vdm_shippingdate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CustomerSalesArea _CustomerSalesArea $projection.Customer = _CustomerSalesArea.Customer and $projection.DistributionChannel = _CustomerSalesArea.DistributionChannel and $projection.SalesOrganization = _CustomerSalesArea.SalesOrganization and $projection.Division = _CustomerSalesArea.Division

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Subcontracting Cockpit Pur Doc Hierarchy view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY MaterialComponent Material Vehicle Model
KEY Plant Plant Valuation Area
KEY Subcontractor Supplier Supplier
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement WBS Internal ID
InventorySpecialStockType InventorySpecialStockType Special Stock Type
WBSDescription WBSDescription WBS Element Name
InventorySpecialStockTypeName InventorySpecialStockTypeName
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SuplrMatlPlnt SuplrMatlPlnt
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization SalesOrganization Sales Organization
Division Division Internal Division ID
Customer Customer Sold-to Party
LoadingGroup LoadingGroup Loading Group
PurchasingDocumentType RFQ Type
PurchaseOrder Purchasing Document
PurchaseOrderItem PurchasingDocumentItem Purchasing Doc. Item
Batch Batch Lot No.
StorageLocation StorageLocation StorageLocation
StillToBeDeliveredQuantity StillToBeDeliveredQuantity
OrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
ShipmentCompletionDate RequestedDeliveryDate Requested Delivery Date
DebitCreditCode DebitCreditCode Single-Character Flag
RequiredQuantity RequiredQuantity Requirement qty
ShippingCondition _CustomerSalesArea ShippingCondition Shipping Conditions
HierarchyNodeLevel Hierarchy Node Level
RequirementType RequirementType RequirementType
int1endasProcessingStatus Processing Status

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_SubcontractingPurDocHier.
-- 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_ReqdDelivDteRngeFrmDte : vdm_shippingdate, P_ReqdDelivDteRngeToDte : vdm_shippingdate

CREATE VIEW I_SubcontractingPurDocHier AS
SELECT
  Material AS MaterialComponent,
  Plant,
  Supplier AS Subcontractor,
  Reservation,
  ReservationItem,
  SpecialStockIdfgWBSElement,
  InventorySpecialStockType,
  WBSDescription,
  InventorySpecialStockTypeName,
  SalesOrder,
  SalesOrderItem,
  SuplrMatlPlnt,
  DistributionChannel,
  SalesOrganization,
  Division,
  Customer,
  LoadingGroup,
  cast( PurchasingDocumentType as esart ) AS PurchasingDocumentType,
  cast( PurchasingDocument as vdm_purchaseorder ) AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  Batch,
  StorageLocation,
  StillToBeDeliveredQuantity,
  PurchaseOrderQuantityUnit AS OrderQuantityUnit,
  RequestedDeliveryDate AS ShipmentCompletionDate,
  DebitCreditCode,
  RequiredQuantity,
  _CustomerSalesArea.ShippingCondition AS ShippingCondition,
  cast( HierarchyNodeLevel as hrylevel ) AS HierarchyNodeLevel,
  RequirementType,
  case when (Plant <> '' and StorageLocation <> '' and StillToBeDeliveredQuantity > 0 and PurchaseOrderQuantityUnit <> '') then cast (1 as abap.int1) else cast (0 as abap.int1) end as ProcessingStatus AS int1endasProcessingStatus
FROM P_SubcontractingHierNodeBase
LEFT OUTER JOIN I_CustomerSalesArea AS _CustomerSalesArea ON Customer = _CustomerSalesArea.Customer AND DistributionChannel = _CustomerSalesArea.DistributionChannel AND SalesOrganization = _CustomerSalesArea.SalesOrganization AND Division = _CustomerSalesArea.Division  -- association [1..1]
;

Learn More