I_FldLogsShptStageAssgmtTP

DDL: I_FLDLOGSSHPTSTAGEASSGMTTP Type: view_entity TRANSACTIONAL

Field Logistics Shipment Stage Assignment Interface - TP

I_FldLogsShptStageAssgmtTP is a Transactional CDS View that provides data about "Field Logistics Shipment Stage Assignment Interface - TP" in SAP S/4HANA. It reads from 1 data source (I_FldLogsShptStageAssgmt) and exposes 14 fields with key fields FldLogsShptVoyageUUID, FldLogsVoyStgeAssgmtUUID.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsShptStageAssgmt I_FldLogsShptStageAssgmt from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Field Logistics Shipment Stage Assignment Interface - TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY FldLogsShptVoyageUUID FldLogsShptVoyageUUID Voyage UUID
KEY FldLogsVoyStgeAssgmtUUID FldLogsVoyStgeAssgmtUUID Voy Stge Assgmt UUID
FldLogsVoyStgeAssgmtSqncID FldLogsVoyStgeAssgmtSqncID Voy Stg Assgmt Sq ID
FldLogsShipmentItemTypeCode FldLogsShipmentItemTypeCode Shpt Item Type Code
FldLogsSrcePlnt FldLogsSrcePlnt Plant
FldLogsDestPlnt FldLogsDestPlnt Plant
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
FldLogsShptAssignmentStatus FldLogsShptAssignmentStatus Assignment Status
FldLogsShptVoyageNumber _FldLogsShptVoyage FldLogsShptVoyageNumber Voyage Number
FldLogsShptVoyageTypeCode _FldLogsShptVoyage FldLogsShptVoyageTypeCode Voyage Type Code
FldLogsShptVoyageVehicleNumber _FldLogsShptVoyage FldLogsShptVoyageVehicleNumber Voyage Veh number
FldLogsShptVoyageVehicleName _FldLogsShptVoyage FldLogsShptVoyageVehicleName Voyage Veh Name
FldLogsVoyageChangeDateTime _FldLogsShptVoyage FldLogsVoyageChangeDateTime Changed On

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_FldLogsShptStageAssgmtTP.
-- 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_FldLogsShptStageAssgmtTP AS
SELECT
  FldLogsShptVoyageUUID,
  FldLogsVoyStgeAssgmtUUID,
  FldLogsVoyStgeAssgmtSqncID,
  FldLogsShipmentItemTypeCode,
  FldLogsSrcePlnt,
  FldLogsDestPlnt,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsShptAssignmentStatus,
  _FldLogsShptVoyage.FldLogsShptVoyageNumber AS FldLogsShptVoyageNumber,
  _FldLogsShptVoyage.FldLogsShptVoyageTypeCode AS FldLogsShptVoyageTypeCode,
  _FldLogsShptVoyage.FldLogsShptVoyageVehicleNumber AS FldLogsShptVoyageVehicleNumber,
  _FldLogsShptVoyage.FldLogsShptVoyageVehicleName AS FldLogsShptVoyageVehicleName,
  _FldLogsShptVoyage.FldLogsVoyageChangeDateTime AS FldLogsVoyageChangeDateTime
FROM I_FldLogsShptStageAssgmt
;