C_FldLogsShptVoyPackggAssgmtTP

DDL: C_FLDLOGSSHPTVOYPACKGGASSGMTTP Type: view_entity CONSUMPTION Package: FLOG_SHIPMENT
19 Fields 1 Data Sources 1 Associations 2 OData Services 1 Fiori Apps

FL Shipment Voyage Packaging Assignment

C_FldLogsShptVoyPackggAssgmtTP is a Consumption CDS View that provides data about "FL Shipment Voyage Packaging Assignment" in SAP S/4HANA. It reads from 1 data source (R_FldLogsShptVoyPackggAssgmtTP) and exposes 19 fields with key fields FldLogsShptVoyageUUID, FldLogsVoyStgeAssgmtUUID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F6040, UI_SHIPMENTVOYAGE). It is used in 1 Fiori application: Manage Field Logistics Voyages. Part of development package FLOG_SHIPMENT.

Data Sources (1)

SourceAliasJoin Type
R_FldLogsShptVoyPackggAssgmtTP R_FldLogsShptVoyPackggAssgmtTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FldLogsShptVoyStgeAssignment _ShptVoyPackggAssgmt $projection.FldLogsShptVoyageUUID = _ShptVoyPackggAssgmt.FldLogsShptVoyageUUID and $projection.FldLogsVoyStgeAssgmtUUID = _ShptVoyPackggAssgmt.FldLogsVoyStgeAssgmtUUID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FL Shipment Voyage Packaging Assignment view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.resultSet.sizeCategory #XS view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix AGN view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.quota.maximumFields 1000 view
AbapCatalog.extensibility.quota.maximumBytes 100000 view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6040 ASQL_F6040 C2 NOT_RELEASED
UI_SHIPMENTVOYAGE UI_SHIPMENTVOYAGE V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F6040 Manage Field Logistics Voyages Transactional This App is used to create Voyages along with Stages and assign packed containers, handling units or standalone items to a voyage.

Manage Field Logistics Voyages

Business Role: Transportation Planner (Oil & Gas)

With this app, you can create, display, or edit a voyage. You can also maintain stages and perform actions such as dispatch and set them to arrived.

Key Features: Search for voyages based on one or more filter criteria, for example, voyage ID, voyage status, start date, mode of transport, from plant, or to plant. View voyage details, for example, voyage stages and assignments. Create voyages. Create, edit, or delete stages. Add planned departure date, planned departure time, planned arrival date, and planned arrival time for the stages. Assign or unassign containers / FL packages / delivery items / handling units. Perform dispatch and set a voyage stage as arrived. Reverse voyage assignment for delivery items, handling units, FL packages and containers. View and assign FL packages to a voyage. View FL package information such as packed deliveries in the Voyage summary document . Assign containers, FL packages or standalone items from multiple plants that share a common shipping point to the same voyage stage (with a matching shipping point). You can preview, print, or export the voyage summary details of a single voyage from the object page. You can print voyage summary documents for multiple voyages together from the worklist. Send email with pdf document containing all voyage details. Note that email is triggered upon performing print action on voyage. Automatic removal of any item from the voyage with the status as Dispatched or Arrived if the Goods Issue for that item is reversed using the standard LoB app. The voyage status is reverted to Not Started if goods issue for all the assigned items is reversed. Note Delivery items / handling units / FL packages /containers can be assigned to a voyage from Pack Container (F5786) app.Objects with different source or destination plants can be assigned to the same voyage stage even if there is a mismatch between the plant of the object and the stage, provided these plants share a common shipping or receiving point.

Fields (19)

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
FldLogsContainerID FldLogsContainerID Container ID
FldLogsSrcePlnt FldLogsSrcePlnt Plant
FldLogsDestPlnt FldLogsDestPlnt Plant
FldLogsVoyageSrceStage FldLogsVoyageSrceStage Source Stage
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
FldLogsCtnActualWeight FldLogsCtnActualWeight Ctn Actual Weight
FldLogsCtnActualWeightUnit FldLogsCtnActualWeightUnit Unit
FldLogsShptAssignmentStatus FldLogsShptAssignmentStatus Assignment Status
FldLogsShptVoyAssgmtCritlty FldLogsShptVoyAssgmtCritlty
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd Purpose Completed
_VoyageAssgmtText _VoyageAssgmtText
_ItemType _ItemType
PlantName _SrcePlantText PlantName Plant Name
PlantName2 _DestPlantText PlantName Plant Name

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_FldLogsShptVoyPackggAssgmtTP.
-- 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_FldLogsShptVoyPackggAssgmtTP AS
SELECT
  FldLogsShptVoyageUUID,
  FldLogsVoyStgeAssgmtUUID,
  FldLogsVoyStgeAssgmtSqncID,
  FldLogsShipmentItemTypeCode,
  FldLogsContainerID,
  FldLogsSrcePlnt,
  FldLogsDestPlnt,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsCtnActualWeight,
  FldLogsCtnActualWeightUnit,
  FldLogsShptAssignmentStatus,
  FldLogsShptVoyAssgmtCritlty,
  IsBusinessPurposeCompleted,
  SuplrCoIsBusPrpsCmpltd,
  _SrcePlantText.PlantName AS PlantName,
  _DestPlantText.PlantName AS PlantName2
FROM R_FldLogsShptVoyPackggAssgmtTP
LEFT OUTER JOIN E_FldLogsShptVoyStgeAssignment AS _ShptVoyPackggAssgmt ON FldLogsShptVoyageUUID = _ShptVoyPackggAssgmt.FldLogsShptVoyageUUID AND FldLogsVoyStgeAssgmtUUID = _ShptVoyPackggAssgmt.FldLogsVoyStgeAssgmtUUID  -- association [0..1]
;

Learn More