P_SubcontrgCockpitDelivery2

DDL: P_SUBCONTRGCOCKPITDELIVERY2 Type: view_entity COMPOSITE
25 Fields 1 Data Sources 1 Associations

P_SubcontrgCockpitDelivery2 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ProcmtDocSubcontrg) and exposes 25 fields with key fields MaterialComponent, Plant, Subcontractor, Reservation, ReservationItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProcmtDocSubcontrg P_ProcmtDocSubcontrg from

Parameters (2)

NameTypeDefault
P_ReqdDelivDteRngeFrmDte vdm_shippingdate
P_ReqdDelivDteRngeToDte vdm_shippingdate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesArea _SalesArea $projection.DistributionChannel = _SalesArea.DistributionChannel and $projection.SalesOrganization = _SalesArea.SalesOrganization and $projection.Division = _SalesArea.Division

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaterialComponent MaterialComponent Vehicle Model
KEY Plant Plant Valuation Area
KEY Subcontractor Subcontractor Supplier
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
SuplrMatlPlnt SuplrMatlPlnt
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization SalesOrganization Sales Organization
Division Division Internal Division ID
ReferenceDistributionChannel _SalesArea ReferenceDistributionChannel
ReferenceDivision _SalesArea ReferenceDivision
Customer Customer Sold-to Party
LoadingGroup LoadingGroup Loading Group
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Batch Batch Lot No.
StorageLocation StorageLocation StorageLocation
StillToBeDeliveredQuantity StillToBeDeliveredQuantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
ShipmentCompletionDate ShipmentCompletionDate Reqmts date
DebitCreditCode DebitCreditCode Single-Character Flag
RequiredQuantity RequiredQuantity Requirement qty
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
RequirementType RequirementType RequirementType

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_SubcontrgCockpitDelivery2.
-- 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 P_SubcontrgCockpitDelivery2 AS
SELECT
  MaterialComponent,
  Plant,
  Subcontractor,
  Reservation,
  ReservationItem,
  SuplrMatlPlnt,
  DistributionChannel,
  SalesOrganization,
  Division,
  _SalesArea.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  _SalesArea.ReferenceDivision AS ReferenceDivision,
  Customer,
  LoadingGroup,
  PurchasingDocumentType,
  PurchaseOrder,
  PurchaseOrderItem,
  Batch,
  StorageLocation,
  StillToBeDeliveredQuantity,
  OrderQuantityUnit,
  ShipmentCompletionDate,
  DebitCreditCode,
  RequiredQuantity,
  HierarchyNodeLevel,
  RequirementType
FROM P_ProcmtDocSubcontrg
LEFT OUTER JOIN I_SalesArea AS _SalesArea ON DistributionChannel = _SalesArea.DistributionChannel AND SalesOrganization = _SalesArea.SalesOrganization AND Division = _SalesArea.Division  -- association [1..1]
;

Learn More