C_DelivProcFlowInbDeliv

DDL: C_DELIVPROCFLOWINBDELIV SQL: CDLVPROCFLIBDLV Type: view CONSUMPTION
10 Fields 2 Data Sources

Delivery Process Flow - Node Inbound Delivery

C_DelivProcFlowInbDeliv is a Consumption CDS View that provides data about "Delivery Process Flow - Node Inbound Delivery" in SAP S/4HANA. It reads from 2 data sources (C_PutawayStatusText, I_InboundDelivery) and exposes 10 fields with key field InboundDelivery.

Data Sources (2)

SourceAliasJoin Type
C_PutawayStatusText C_PutawayStatusText left_outer
I_InboundDelivery I_InboundDelivery from

Parameters (1)

NameTypeDefault
P_Language spras

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDLVPROCFLIBDLV view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Process Flow - Node Inbound Delivery view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey InboundDelivery view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InboundDelivery InboundDelivery LE Delivery
ShippingPoint ShippingPoint Shipping Point
Language StatusText Language Report Text Language
SDDocumentCategory SDDocumentCategory Document Cat.
OverallGoodsMovementStatus OverallGoodsMovementStatus
OverallPutawayStatus I_InboundDelivery OverallPutawayStatus
DeliveryDocumentType
ProcessFlowNodeTitle
ProcessFlowNodeShortTitle
_Language StatusText _Language

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 C_DelivProcFlowInbDeliv.
-- 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: CDLVPROCFLIBDLV
-- Parameters: P_Language : spras

CREATE VIEW C_DelivProcFlowInbDeliv AS
SELECT
  InboundDelivery,
  ShippingPoint,
  StatusText.Language AS Language,
  SDDocumentCategory,
  OverallGoodsMovementStatus,
  I_InboundDelivery.OverallPutawayStatus AS OverallPutawayStatus,
  I_InboundDelivery._DeliveryDocumentType.DeliveryDocumentType AS DeliveryDocumentType,
  I_InboundDelivery._DeliveryDocumentType._Text[1: Language = :P_Language].DeliveryDocumentTypeName AS ProcessFlowNodeTitle,
  I_InboundDelivery._DeliveryDocumentType._Text[1: Language = :P_Language].DeliveryDocumentTypeName AS ProcessFlowNodeShortTitle,
  StatusText._Language AS _Language
FROM I_InboundDelivery
LEFT OUTER JOIN C_PutawayStatusText ON /* join condition not captured in parsed metadata */
;

Learn More