I_FldLogsShptCtnUnit

DDL: I_FLDLOGSSHPTCTNUNIT Type: view_entity BASIC
34 Fields 1 Data Sources 1 Associations

Field Logistics Shipment Container Unit

I_FldLogsShptCtnUnit is a Basic CDS View that provides data about "Field Logistics Shipment Container Unit" in SAP S/4HANA. It reads from 1 data source (flog_shptctnunit) and exposes 34 fields with key field FldLogsContainerUnitUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
flog_shptctnunit flog_shptctnunit from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FldLogsShptCtnUnit _ShptCtnUnitExtension $projection.FldLogsContainerUnitUUID = _ShptCtnUnitExtension.FldLogsContainerUnitUUID

Annotations (6)

NameValueLevelField
EndUserText.label Field Logistics Shipment Container Unit view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerUnitUUID fldlogscontainerunituuid Container Unit ID
FldLogsContainerUUID fldlogscontaineruuid Container UUID
FldLogsShipmentID fldlogsshipmentid Shipment ID
FldLogsCtnPackgStsCode fldlogsctnpackgstscode Packing Status
FldLogsCtnPackgChkErrCode fldlogsctnpackgchkerrcode Check Error Code
FldLogsCtnIntTranspStsCode fldlogsctninttranspstscode Field Logistics: Container Internal Transport Status Code
FldLogsCtnExtTranspSts fldlogsctnexttranspsts Ext. Status
FldLogsSrceStorLocID fldlogssrcestorlocid Location
FldLogsSrcePlnt fldlogssrceplnt Plant
FldLogsDestStorLocID fldlogsdeststorlocid Location
FldLogsDestPlnt fldlogsdestplnt Plant
FldLogsCtnPackgChangeDateTime fldlogsctnpackgchangedatetime Changed On
FldLogsGrossVolume fldlogsgrossvolume Volume
FldLogsGrossVolumeUnit fldlogsgrossvolumeunit Volume Unit
ProductGrossWeight productgrossweight Gross Weight
ProductWeightUnit productweightunit Unit of Weight
FldLogsCtnActualWeight fldlogsctnactualweight Ctn Actual Weight
FldLogsCtnActualWeightUnit fldlogsctnactualweightunit Unit
FldLogsSealNumber1 fldlogssealnumber1 Seal Number
FldLogsSealNumber2 fldlogssealnumber2 Seal Number
FldLogsSealNumber3 fldlogssealnumber3 Seal Number
FldLogsSealNumber4 fldlogssealnumber4 Seal Number
FldLogsSealNumber5 fldlogssealnumber5 Seal Number
FldLogsShptItmIsAssgdToVoy fldlogsshptitmisassgdtovoy VoyAsgnInd
FldLogsVoyageSrceStage fldlogsvoyagesrcestage Source Stage
FldLogsVoyageDestStage fldlogsvoyagedeststage Destination Stage
FldLogsVoyageAssignmentStatus fldlogsvoyageassignmentstatus Voy Assgmt Status
FldLogsCtnUnitCurrentPlant fldlogsctnunitcurrentplant Plant
FldLogsCtnUnitCurShipgPoint fldlogsctnunitcurshipgpoint Destination Stage
FldLogsContainerUnitExternalID fldlogscontainerunitexternalid External ID
FieldLogisticsCtnIsOwned fieldlogisticsctnisowned Ctn classification
FldLogsParentContainerUnitUUID fldlogsparentcontainerunituuid Parent Container ID
FldLogsParentContainerID fldlogsparentcontainerid Parent Ctn ID
FldLogsShptLocationID fldlogsshptlocationid Location 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_FldLogsShptCtnUnit.
-- 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_FldLogsShptCtnUnit AS
SELECT
  FldLogsContainerUnitUUID,
  FldLogsContainerUUID,
  FldLogsShipmentID,
  FldLogsCtnPackgStsCode,
  FldLogsCtnPackgChkErrCode,
  FldLogsCtnIntTranspStsCode,
  FldLogsCtnExtTranspSts,
  FldLogsSrceStorLocID,
  FldLogsSrcePlnt,
  FldLogsDestStorLocID,
  FldLogsDestPlnt,
  FldLogsCtnPackgChangeDateTime,
  FldLogsGrossVolume,
  FldLogsGrossVolumeUnit,
  ProductGrossWeight,
  ProductWeightUnit,
  FldLogsCtnActualWeight,
  FldLogsCtnActualWeightUnit,
  FldLogsSealNumber1,
  FldLogsSealNumber2,
  FldLogsSealNumber3,
  FldLogsSealNumber4,
  FldLogsSealNumber5,
  FldLogsShptItmIsAssgdToVoy,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsVoyageAssignmentStatus,
  FldLogsCtnUnitCurrentPlant,
  FldLogsCtnUnitCurShipgPoint,
  FldLogsContainerUnitExternalID,
  FieldLogisticsCtnIsOwned,
  FldLogsParentContainerUnitUUID,
  FldLogsParentContainerID,
  FldLogsShptLocationID
FROM flog_shptctnunit
LEFT OUTER JOIN E_FldLogsShptCtnUnit AS _ShptCtnUnitExtension ON FldLogsContainerUnitUUID = _ShptCtnUnitExtension.FldLogsContainerUnitUUID  -- association [0..1]
;

Learn More