C_FldLogsOutbDelivInfo

DDL: C_FLDLOGSOUTBDELIVINFO Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 2 Associations

Field Logistics Outbound Delivery Info

C_FldLogsOutbDelivInfo is a Consumption CDS View that provides data about "Field Logistics Outbound Delivery Info" in SAP S/4HANA. It reads from 1 data source (I_FldLogsOutbDelivInfo) and exposes 20 fields with key fields PurchasingDocument, PurchasingDocumentItem, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsOutbDelivInfo _obdinfo from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PickingStatusText _pickstatustext _pickstatustext.PickingStatus = _obdinfo.PickingStatus and _pickstatustext.Language = $session.system_language
[0..1] I_DeliveryBlockReasonText _blockreasontext _blockreasontext.DeliveryBlockReason = _obdinfo.DeliveryBlockReason and _blockreasontext.Language = $session.system_language

Annotations (9)

NameValueLevelField
EndUserText.label Field Logistics Outbound Delivery Info view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.resultSet.sizeCategory #XS view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY DeliveryDocument
KEY DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
KEY FldLogsSuplrItemUUID FldLogsSuplrItemUUID Suplr Item UUID
KEY OutboundDelivery OutboundDelivery LE Delivery
KEY OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
StockTransportOrder StockTransportOrder STO Number
PickingStatus PickingStatus Status Value
DeliveryBlockReason DeliveryBlockReason Delivery Block
DeliveryBlockReasonText _blockreasontext DeliveryBlockReasonText
PickingStatusName _pickstatustext PickingStatusName
ActualDeliveryQuantity ActualDeliveryQuantity Base quantity
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
EWMOutboundDelivery EWMOutboundDelivery
EWMOutboundDeliveryOrder EWMOutboundDeliveryOrder Document Number
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_FldLogsOutbDelivInfo.
-- 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.

CREATE VIEW C_FldLogsOutbDelivInfo AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  ltrim(DeliveryDocument,'0') AS DeliveryDocument,
  DeliveryDocumentItem,
  FldLogsSuplrItemUUID,
  OutboundDelivery,
  OutboundDeliveryItem,
  StockTransportOrder,
  PickingStatus,
  DeliveryBlockReason,
  _blockreasontext.DeliveryBlockReasonText AS DeliveryBlockReasonText,
  _pickstatustext.PickingStatusName AS PickingStatusName,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  EWMOutboundDelivery,
  EWMOutboundDeliveryOrder,
  IsEndOfPurposeBlocked
FROM I_FldLogsOutbDelivInfo AS _obdinfo
LEFT OUTER JOIN I_PickingStatusText AS _pickstatustext ON _pickstatustext.PickingStatus = _obdinfo.PickingStatus AND _pickstatustext.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReasonText AS _blockreasontext ON _blockreasontext.DeliveryBlockReason = _obdinfo.DeliveryBlockReason AND _blockreasontext.Language = $session.system_language  -- association [0..1]
;

Learn More