P_DeliveryItemGIDelayCalc

DDL: P_DELIVERYITEMGIDELAYCALC SQL: PDLVISHAPDELAY Type: view COMPOSITE
52 Fields 1 Data Sources

P_DeliveryItemGIDelayCalc is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_DelivItmShpdAsPlndCalc) and exposes 52 fields with key fields OutboundDelivery, OutboundDeliveryItem.

Data Sources (1)

SourceAliasJoin Type
P_DelivItmShpdAsPlndCalc P_DelivItmShpdAsPlndCalc from

Parameters (1)

NameTypeDefault
P_ShippedAsPlannedOffsetDays le_shippedasplannedoffsetdays

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.sqlViewName PDLVISHAPDELAY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery LE Delivery
KEY OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
OverallGoodsMovementStatus OverallGoodsMovementStatus
PlannedGoodsIssueDate PlannedGoodsIssueDate
AdjustedPlannedGoodsIssueDate AdjustedPlannedGoodsIssueDate
ActualGoodsMovementDate ActualGoodsMovementDate
DeliveryPriority DeliveryPriority Delivery Prior.
DeliveryDocumentType DeliveryDocumentType Delivery Type
ReceivingPlant ReceivingPlant Receiving Plant
ShipToParty ShipToParty Ship-To Party (obsolete)
ShippingCondition ShippingCondition Shipping Conditions
ShippingPoint ShippingPoint Shipping Point
SoldToParty SoldToParty Sold-to Party
ProposedDeliveryRoute ProposedDeliveryRoute
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
NmbrOfShpdAsPlndDelivItems NmbrOfShpdAsPlndDelivItems
MaterialGroup MaterialGroup Product Group
ProductGroup ProductGroup Product Sold Group
Plant Plant Valuation Area
TransportationGroup TransportationGroup Trans. Group
Warehouse Warehouse Warehouse No.
Material Material Vehicle Model
Product Product Product Sold
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory ReferenceSDDocumentCategory Prec.Doc.Categ.
CustomerClassification CustomerClassification Customer Class.
ForwardingAgent ForwardingAgent
CreationDate CreationDate Time Stamp
_OutboundDelivery _OutboundDelivery
_OverallGoodsMovementStatus _OverallGoodsMovementStatus
_CustomerClassification _CustomerClassification
_GoodsMovementStatus _GoodsMovementStatus
_SoldToParty _SoldToParty
_MaterialGroup _MaterialGroup
_ProductGroup _ProductGroup
_Plant _Plant
_TransportationGroup _TransportationGroup
_Warehouse _Warehouse
_DeliveryPriority _DeliveryPriority
_DeliveryDocumentType _DeliveryDocumentType
_ReceivingPlant _ReceivingPlant
_ShipToParty _ShipToParty
_ShippingCondition _ShippingCondition
_ShippingPoint _ShippingPoint
_ProposedDeliveryRoute _ProposedDeliveryRoute
_Material _Material
_Product _Product
_ReferenceSDDocument _ReferenceSDDocument
_ReferenceSalesDocumentItem _ReferenceSalesDocumentItem
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory
_ForwardingAgent _ForwardingAgent

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_DeliveryItemGIDelayCalc.
-- 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: PDLVISHAPDELAY
-- Parameters: P_ShippedAsPlannedOffsetDays : le_shippedasplannedoffsetdays

CREATE VIEW P_DeliveryItemGIDelayCalc AS
SELECT
  OutboundDelivery,
  OutboundDeliveryItem,
  OverallGoodsMovementStatus,
  PlannedGoodsIssueDate,
  AdjustedPlannedGoodsIssueDate,
  ActualGoodsMovementDate,
  DeliveryPriority,
  DeliveryDocumentType,
  ReceivingPlant,
  ShipToParty,
  ShippingCondition,
  ShippingPoint,
  SoldToParty,
  ProposedDeliveryRoute,
  GoodsMovementStatus,
  NmbrOfShpdAsPlndDelivItems,
  MaterialGroup,
  ProductGroup,
  Plant,
  TransportationGroup,
  Warehouse,
  Material,
  Product,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  CustomerClassification,
  ForwardingAgent,
  CreationDate
FROM P_DelivItmShpdAsPlndCalc
;

Learn More