I_FldLogsShptVoyAssgmtRecord

DDL: I_FLDLOGSSHPTVOYASSGMTRECORD Type: view_entity COMPOSITE Package: FLOG_SHIPMENT
17 Fields 2 Data Sources

Field Logistics Shipment Voyage Assign Record

I_FldLogsShptVoyAssgmtRecord is a Composite CDS View that provides data about "Field Logistics Shipment Voyage Assign Record" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsShipmentItemTP, I_FldLogsShptCtnUnitRecord) and exposes 17 fields with key field FldLogsShptVoyAssgmtItemUUID. Part of development package FLOG_SHIPMENT.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsShipmentItemTP I_FldLogsShipmentItemTP union
I_FldLogsShptCtnUnitRecord I_FldLogsShptCtnUnitRecord from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Field Logistics Shipment Voyage Assign Record view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FldLogsShptVoyAssgmtItemUUID FldLogsContainerUnitUUID Container Unit ID
FldLogsContainerID FldLogsContainerID Container ID
FldLogsReferenceDocumentNumber Reference Doc Number
DeliveryDocument Outbound Delivery
FldLogsSrcePlnt FldLogsSrcePlnt Plant
FldLogsDestPlnt FldLogsDestPlnt Plant
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
FldLogsShptItmHndlgUnitID Handling Unit ID
FldLogsContainerID Container ID
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
DeliveryDocument DeliveryDocument Outbound Delivery
FldLogsSrcePlnt FldLogsSrcePlnt Plant
FldLogsDestPlnt FldLogsDestPlnt Plant
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID Handling Unit ID

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_FldLogsShptVoyAssgmtRecord.
-- 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 I_FldLogsShptVoyAssgmtRecord AS
SELECT
  FldLogsContainerUnitUUID AS FldLogsShptVoyAssgmtItemUUID,
  FldLogsContainerID,
  cast( ' ' as char20) AS FldLogsReferenceDocumentNumber,
  cast(' ' as vbeln_vl ) AS DeliveryDocument,
  FldLogsSrcePlnt,
  FldLogsDestPlnt,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  cast(' ' as char20 ) AS FldLogsShptItmHndlgUnitID
FROM I_FldLogsShptCtnUnitRecord
-- UNION with additional select branch(es): I_FldLogsShipmentItemTP
;

Learn More