C_FreightAgrmtFrtOrdRef

DDL: C_FREIGHTAGRMTFRTORDREF SQL: CFAGRFRTREF Type: view CONSUMPTION

Transportation Agreement Reference Doc

C_FreightAgrmtFrtOrdRef is a Consumption CDS View that provides data about "Transportation Agreement Reference Doc" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrder) and exposes 23 fields with key fields TransportationOrderUUID, TranspChargeItemUUID. It has 1 association to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrder I_TransportationOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TranspChargeObject _TranspChargeObject $projection.TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CFAGRFRTREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transportation Agreement Reference Doc view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID
KEY TranspChargeItemUUID
FreightOrder
TransportationAgreementUUID
TransportationOrderType TransportationOrderType
TransportationOrderCategory TransportationOrderCategory
PurchasingOrgExternalID PurchasingOrgExternalID
PurchasingGroupExternalID PurchasingGroupExternalID
TranspOrdResponsiblePerson TranspOrdResponsiblePerson
TransportationMode TransportationMode
PlngAndExecOrganization PlngAndExecOrganization
PlngAndExecGroup PlngAndExecGroup
CreationDateTime CreationDateTime
InvoicingStatus _TranspChargeObject InvoicingStatus
InvoicingStatusDesc
TransportationOrderExecSts TransportationOrderExecSts
TransportationOrderExecStsDesc
TranspOrdLifeCycleStatus TranspOrdLifeCycleStatus
TranspOrdLifeCycleStatusDesc
TranspChargeCalcStatus _TranspChargeObject TranspChargeCalcStatus
TranspChargeCalcStatusDesc
TranspChrgTotalAmtInDocCrcy _TranspChargeObject TranspChrgTotalAmtInDocCrcy
TranspChargeDocumentCurrency _TranspChargeObject TranspChargeDocumentCurrency 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CFAGRFRTREF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Transportation Agreement Reference Doc'

@ObjectModel:       {representativeKey:   [ 'TransportationOrderUUID', 'TranspChargeItemUUID'],
                     semanticKey: ['FreightOrder'],
                     usageType:          {serviceQuality: #C,
                                          sizeCategory:   #XXL,
                     dataClass:           #TRANSACTIONAL}}

@VDM:               {viewType:           #CONSUMPTION}
@Metadata.allowExtensions: true                                          
define view C_FreightAgrmtFrtOrdRef 

as select from I_TransportationOrder 
  association [0..1] to I_TranspChargeObject as _TranspChargeObject on $projection.TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID

{
  key cast(TransportationOrderUUID     as /scmtms/vdm_tor_db_key preserving type )                                           as TransportationOrderUUID,
      
  key _TranspChargeObject._TranspChargeItem.TranspChargeItemUUID,

      @Consumption.semanticObject: 'FreightOrder'
      cast(TransportationOrder as /scmtms/tor_fo_id preserving type )                                                                                                   as FreightOrder,
      _TranspChargeObject._TranspChargeItem.TransportationAgreementUUID,

      /* DCL Fields*/
       
      TransportationOrderType,
      TransportationOrderCategory,   
      PurchasingOrgExternalID,
      PurchasingGroupExternalID,
      TranspOrdResponsiblePerson,
      TransportationMode,
      PlngAndExecOrganization,
      PlngAndExecGroup,
      
      CreationDateTime, 
      
      @ObjectModel.text.element: ['InvoicingStatusDesc']
      _TranspChargeObject.InvoicingStatus, 
      @Semantics.text: true
      _TranspChargeObject._InvoicingStatus._Text[1:Language = $session.system_language ].InvoicingStatusDesc, 
                
      @ObjectModel.text.element: ['TransportationOrderExecStsDesc']
      TransportationOrderExecSts,
      @Semantics.text: true
      _TransportationOrderExecSts._Text[1:Language = $session.system_language ].TransportationOrderExecStsDesc,
      @ObjectModel.text.element: ['TranspOrdLifeCycleStatusDesc']
      TranspOrdLifeCycleStatus,
      @Semantics.text: true
      _TranspOrdLifeCycleStatus._Text[1:Language = $session.system_language ].TranspOrdLifeCycleStatusDesc                   as TranspOrdLifeCycleStatusDesc,
      @ObjectModel.text.element: ['TranspChargeCalcStatusDesc']
      _TranspChargeObject.TranspChargeCalcStatus,
      @Semantics.text: true
      _TranspChargeObject._TranspChargeCalcStatus._Text[1: Language = $session.system_language ].TranspChargeCalcStatusDesc,
      @Semantics.amount.currencyCode: 'TranspChargeDocumentCurrency'
      //@DefaultAggregation: #SUM

      _TranspChargeObject.TranspChrgTotalAmtInDocCrcy                                                                       as TranspChrgTotalAmtInDocCrcy,
      @Semantics.currencyCode: true
      _TranspChargeObject.TranspChargeDocumentCurrency                                                                       as TranspChargeDocumentCurrency

}
where
      TransportationOrderCategory = 'TO' // /SCMTMS/IF_TOR_CONST=>SC_TOR_CATEGORY-ACTIVE

  and TransportationOrder         is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INVOICINGSTATUS",
"I_INVOICINGSTATUSTEXT",
"I_TRANSPCHARGECALCSTATUS",
"I_TRANSPCHARGECALCSTATUSTEXT",
"I_TRANSPCHARGEITEM",
"I_TRANSPCHARGEOBJECT",
"I_TRANSPORDLIFECYCLESTATUS",
"I_TRANSPORDLIFECYCLESTATUSTEXT",
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDEREXECSTS",
"I_TRANSPORTATIONORDEREXECSTST"
],
"ASSOCIATED":
[
"I_TRANSPCHARGEOBJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More