R_FldLogsShptPackggUnitTP

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 R_FldLogsShptPackggUnitTP.
-- 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 R_FldLogsShptPackggUnitTP AS
SELECT
  FldLogsContainerUnitUUID,
  FldLogsContainerUUID,
  FldLogsContainerID,
  FldLogsShipmentID,
  FldLogsCtnPackgStsCode,
  FldLogsCtnPackgChkErrCode,
  FldLogsCtnIntTranspStsCode,
  FldLogsCtnExtTranspSts,
  FldLogsSrceStorLocID,
  FldLogsSrcePlnt,
  FldLogsDestStorLocID,
  FldLogsDestPlnt,
  FldLogsCtnPackgChangeDateTime,
  FldLogsContainerCategory,
  FldLogsCtnPackgStsText,
  FldLogsShptCtnIntTranspStsText,
  FldLogsSealNumber1,
  FldLogsSealNumber2,
  FldLogsSealNumber3,
  FldLogsSealNumber4,
  FldLogsSealNumber5,
  FldLogsGrossVolume,
  FldLogsGrossVolumeUnit,
  ProductGrossWeight,
  ProductWeightUnit,
  FldLogsCtnActualWeight,
  FldLogsCtnActualWeightUnit,
  EquipmentType,
  FldLogsContainerText,
  FldLogsContainerStatus,
  FldLogsContainerSafeLoadQty,
  FldLogsContainerSafeLoadUnit,
  FldLogsCtnCurrentLocation,
  FldLogsCtnCurrentStorageLoc,
  FldLogsContainerOwner,
  FldLogsCtnCubicCapacity,
  FldLogsCtnCubicCapacityUnit,
  FldLogsCertEndDate,
  FldLogsShptItmIsAssgdToVoy,
  FldLogsContainerTareWeight,
  FldLogsContainerTareWeightUnit,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsVoyageAssignmentStatus,
  FldLogsVoyAssgmtStatusText,
  FldLogsCtnUnitCurrentPlant,
  FldLogsCtnUnitCurShipgPoint,
  FldLogsContainerUnitExternalID,
  FieldLogisticsCtnIsOwned,
  FldLogsParentContainerUnitUUID,
  FldLogsParentContainerID,
  FldLogsShptLocationID,
  cast(''as abap.char(20)) AS HandlingUnitExternalID,
  cast(''as abap.char(10)) AS DeliveryDocument,
  cast(''as abap.char(20)) AS FldLogsReferenceDocumentNumber,
  cast(''as flog_kit_id) AS FieldLogisticsKitIdentifier,
  IsBusinessPurposeCompleted,
  SuplrCoIsBusPrpsCmpltd,
  cast('' as flog_shptitem_evt_id) AS FldLogsShptItemActnID,
  _ShipgPtText.ShippingPointName AS ShippingPointName,
  cast( substring( _RcvgPtText.ShippingPointName, 1, 25) as empst ) AS ReceivingPoint,
  _DestPlantText.PlantName AS PlantName
FROM I_FldLogsShptPackggUnitRecord
LEFT OUTER JOIN I_EquipmentTypeText AS _EquipmentTypeText ON EquipmentType = _EquipmentTypeText.EquipmentType  -- association [0..*]
LEFT OUTER JOIN I_FldLogsContainerCategoryText AS _CtnCategoryText ON FldLogsContainerCategory = _CtnCategoryText.FldLogsContainerCategory  -- association [0..*]
LEFT OUTER JOIN E_FldLogsShptCtnUnit AS _ShptCtnUnitExtension ON FldLogsContainerUnitUUID = _ShptCtnUnitExtension.FldLogsContainerUnitUUID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsPackCtnApplUsrSttg AS _SuplritemBasePlantPre ON _SuplritemBasePlantPre.AppSettingsUser = $session.user  -- association [0..1]
LEFT OUTER JOIN I_ShippingPointText AS _ShipgPtText ON FldLogsVoyageSrceStage = _ShipgPtText.ShippingPoint AND _ShipgPtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ShippingPointText AS _RcvgPtText ON FldLogsVoyageDestStage = _RcvgPtText.ShippingPoint AND _RcvgPtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _DestPlantText ON FldLogsDestPlnt = _DestPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN R_FldLogsShptPackggItemTP AS _ShptItems ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_FldLogsShptStgeAssgPackggTP AS _ShptStgeAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_FldLogsItmsTaggedToPackggTP AS _TaggedItems ON /* condition not available in parsed metadata */  -- association [0..*]
;