Which tables does I_FrtUnitStage use?

I_FrtUnitStage reads from 1 data source(s): I_TransportationOrderStage.

How many fields does I_FrtUnitStage have?

I_FrtUnitStage has 26 fields. Key fields: TransportationOrderStageUUID.

I_FrtUnitStage

DDL: I_FRTUNITSTAGE SQL: ITORFUSTG Type: view COMPOSITE

Freight Unit: Stages

I_FrtUnitStage is a Composite CDS View that provides data about "Freight Unit: Stages" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderStage) and exposes 26 fields with key field TransportationOrderStageUUID. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_TransportationOrderStage	Stage	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_TransportationOrder	_TransportationOrder	`$projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID`
[1..1]	P_TranspOrdStageSequence	_StageSeq	`$projection.TransportationOrderUUID = _StageSeq.TransportationOrderUUID and $projection.TransportationOrderStageUUID = _StageSeq.TransportationOrderStageUUID`

Annotations (13)

Name	Value	Level
EndUserText.label	Freight Unit: Stages	view
ObjectModel.representativeKey	TransportationOrderStageUUID	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.sqlViewName	ITORFUSTG	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Metadata.allowExtensions	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (26)

Key	Field	Source Table	Source Field
KEY	TransportationOrderStageUUID		TransportationOrderStageUUID
	TransportationOrderUUID		TransportationOrderUUID
	TranspOrdStageSequence
	SourceLocationLabel
	TranspOrdDepartureDateTime
	clientNULLasTranspOrdDepartureDate
	clientNULLasTranspOrdDepartureTime
	DestinationLocationLabel
	TranspOrdArrivalDateTime
	clientNULLasTranspOrdArrivalDate
	clientNULLasTranspOrdArrivalTime
	TranspErlstAccptblPkupDteTme
	clientNULLasTranspErlstAccptblPkupDte
	clientNULLasTranspErlstAccptblPkupTme
	TranspErlstAccptblDelivDteTme
	clientNULLasTranspErlstAccptblDelivDte
	clientNULLasTranspErlstAccptblDelivTme
	TranspLtstAccptblDelivDteTme
	clientNULLasTranspLtstAccptblDelivDte
	clientNULLasTranspLtstAccptblDelivTme
	TranspOrdCapacityTranspOrd
	TranspOrdStagePlnStatus	I_TransportationOrderStage	TranspOrdStagePlnStatus
	TranspOrdStagePlnStatusDesc
	RequestingCompanyCode	I_TransportationOrderStage	RequestingCompanyCode
	_TransportationOrder		_TransportationOrder
	_RequestingCompanyCode		_RequestingCompanyCode

@EndUserText.label: 'Freight Unit: Stages'
@ObjectModel:   {representativeKey:  'TransportationOrderStageUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}
@AbapCatalog.sqlViewName:           'ITORFUSTG'
@AbapCatalog:   {compiler:           {compareFilter: true},
                 buffering:          {status: #NOT_ALLOWED},
                 preserveKey:        true}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA') }

@Metadata.allowExtensions:  true
@ClientHandling.algorithm:  #SESSION_VARIABLE

define view I_FrtUnitStage
  as select from I_TransportationOrderStage as Stage

  association [1..1] to I_TransportationOrder    as _TransportationOrder on  $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [1..1] to P_TranspOrdStageSequence as _StageSeq            on  $projection.TransportationOrderUUID      = _StageSeq.TransportationOrderUUID
                                                                         and $projection.TransportationOrderStageUUID = _StageSeq.TransportationOrderStageUUID
{
  key TransportationOrderStageUUID,
      TransportationOrderUUID,
      _StageSeq(i_clnt:$session.client, i_torcat:'FU').TranspOrdStageSequence                                  as TranspOrdStageSequence,
      _TranspOrdStageSrceStop._Locationdescr.AddressObjectDescription                                          as SourceLocationLabel,
      cast(_TranspOrdStageSrceStop.TranspOrdStopPlanTranspDteTme as    log_created_on preserving type )        as TranspOrdDepartureDateTime,
      tstmp_to_dats( _TranspOrdStageSrceStop.TranspOrdStopPlanTranspDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                  as TranspOrdDepartureDate,
      tstmp_to_tims( _TranspOrdStageSrceStop.TranspOrdStopPlanTranspDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                  as TranspOrdDepartureTime,
      _TranspOrdStageDestStop._Locationdescr.AddressObjectDescription                                          as DestinationLocationLabel,
      cast(_TranspOrdStageDestStop.TranspOrdStopPlanTranspDteTme as    log_created_on preserving type )        as TranspOrdArrivalDateTime,
      tstmp_to_dats( _TranspOrdStageDestStop.TranspOrdStopPlanTranspDteTme,
                    abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                    $session.client,
                    'NULL' )                                                                                   as TranspOrdArrivalDate,
      tstmp_to_tims( _TranspOrdStageDestStop.TranspOrdStopPlanTranspDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                  as TranspOrdArrivalTime,
      cast(_TranspOrdStageSrceStop.TranspOrdStopAccptblStrtDteTme as    log_created_on preserving type )       as TranspErlstAccptblPkupDteTme,
      tstmp_to_dats( _TranspOrdStageSrceStop.TranspOrdStopAccptblStrtDteTme,
                    abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                    $session.client,
                    'NULL' )                                                                                   as TranspErlstAccptblPkupDte,
      tstmp_to_tims( _TranspOrdStageSrceStop.TranspOrdStopAccptblStrtDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                  as TranspErlstAccptblPkupTme,
      cast(_TranspOrdStageDestStop.TranspOrdStopAccptblStrtDteTme as    log_created_on preserving type )       as TranspErlstAccptblDelivDteTme,
      tstmp_to_dats( _TranspOrdStageDestStop.TranspOrdStopAccptblStrtDteTme,
                    abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                    $session.client,
                    'NULL' )                                                                                   as TranspErlstAccptblDelivDte,
      tstmp_to_tims( _TranspOrdStageDestStop.TranspOrdStopAccptblStrtDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                  as TranspErlstAccptblDelivTme,
      cast(_TranspOrdStageDestStop.TranspOrdStopAccptblEndDteTme as    log_created_on preserving type )        as TranspLtstAccptblDelivDteTme,
      tstmp_to_dats( _TranspOrdStageDestStop.TranspOrdStopAccptblEndDteTme,
                    abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                    $session.client,
                    'NULL' )                                                                                   as TranspLtstAccptblDelivDte,
      tstmp_to_tims( _TranspOrdStageDestStop.TranspOrdStopAccptblEndDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                  as TranspLtstAccptblDelivTme,

      Stage._TranspOrdStageSrceStop._CapaStop._TransportationOrder.TransportationOrder                         as TranspOrdCapacityTranspOrd,
      Stage.TranspOrdStagePlnStatus                                                                            as TranspOrdStagePlnStatus,
      Stage._TranspOrdStagePlnStatus._Text[1:Language = $session.system_language ].TranspOrdStagePlnStatusDesc as TranspOrdStagePlnStatusDesc,
      Stage.RequestingCompanyCode                                                                              as RequestingCompanyCode,


      /* Associations */
      _TransportationOrder,
      _RequestingCompanyCode
}
where
      _TransportationOrder.TransportationOrderCategory = 'FU'
  and TranspOrdStageDestStopCategory                   = 'L'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TMLOCATIONDESCRIPTION",
"I_TRANSPORDSTAGEPLNSTATUS",
"I_TRANSPORDSTAGEPLNSTATUST",
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERSTAGE",
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_TRANSPORTATIONORDER"
],
"BASE":
[
"I_TRANSPORTATIONORDERSTAGE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_FrtUnitStage view

I_TransportationOrderStage view_entity