R_FrtCostAllocRefFreightOrder

DDL: R_FRTCOSTALLOCREFFREIGHTORDER Type: view_entity COMPOSITE

Frt Cost Alloc Ref Freight Order

R_FrtCostAllocRefFreightOrder is a Composite CDS View that provides data about "Frt Cost Alloc Ref Freight Order" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrder) and exposes 5 fields with key fields FreightCostAllocationDocument, FrtCostAllocDocumentItem. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrder I_TransportationOrder inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_FrtCostAllocDoc _FrtCostAllocDoc $projection.FreightCostAllocationDocument = _FrtCostAllocDoc.FreightCostAllocationDocument
[1..1] R_FrtCostAllocItm _FrtCostAllocItm $projection.FreightCostAllocationDocument = _FrtCostAllocItm.FreightCostAllocationDocument and $projection.FrtCostAllocDocumentItem = _FrtCostAllocItm.FrtCostAllocDocumentItem

Annotations (9)

NameValueLevelField
EndUserText.label Frt Cost Alloc Ref Freight Order view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY FreightCostAllocationDocument
KEY FrtCostAllocDocumentItem
FreightOrder
_FrtCostAllocDoc _FrtCostAllocDoc
_FrtCostAllocItm _FrtCostAllocItm 
@EndUserText.label: 'Frt Cost Alloc Ref Freight Order'
@AccessControl: {
    authorizationCheck: #PRIVILEGED_ONLY,
    personalData.blocking: #('TRANSACTIONAL_DATA')
    }
@ObjectModel: {
    usageType.serviceQuality: #C,
    usageType.dataClass:      #TRANSACTIONAL,
    usageType.sizeCategory:   #XXL
    }
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
    }
@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions: false
    }

define view entity R_FrtCostAllocRefFreightOrder
  as select distinct from R_SettlmtMgmtRefDocProcessFlow
    inner join            I_TransportationOrder on R_SettlmtMgmtRefDocProcessFlow.SettlmtRefDoc = I_TransportationOrder.TransportationOrder

  association [1..1] to R_FrtCostAllocDoc as _FrtCostAllocDoc on  $projection.FreightCostAllocationDocument = _FrtCostAllocDoc.FreightCostAllocationDocument
  association [1..1] to R_FrtCostAllocItm as _FrtCostAllocItm on  $projection.FreightCostAllocationDocument = _FrtCostAllocItm.FreightCostAllocationDocument
                                                              and $projection.FrtCostAllocDocumentItem      = _FrtCostAllocItm.FrtCostAllocDocumentItem

{
           @ObjectModel.foreignKey.association: '_FrtCostAllocDoc'
  key      cast( R_SettlmtMgmtRefDocProcessFlow.SettlmtSubsqntRefDoc as wlf_fcadoc_wbeln preserving type )      as FreightCostAllocationDocument,
           @ObjectModel.foreignKey.association: '_FrtCostAllocItm'
  key      cast( R_SettlmtMgmtRefDocProcessFlow.SettlmtSubsqntRefDocItem  as wposnr_lf  preserving type )       as FrtCostAllocDocumentItem,
           cast( R_SettlmtMgmtRefDocProcessFlow.SettlmtRefDoc as /scmtms/vdm_freight_order_id preserving type ) as FreightOrder,

           /* Associations */
           _FrtCostAllocDoc,
           _FrtCostAllocItm
}
where

  (
         R_SettlmtMgmtRefDocProcessFlow.SettlmtRefDocCat        = '81'
    and

    (
         R_SettlmtMgmtRefDocProcessFlow.SettlmtRefDocBusProcCat = '30'
      or R_SettlmtMgmtRefDocProcessFlow.SettlmtRefDocBusProcCat = '31'
    )
  )

  and(
         I_TransportationOrder.TransportationOrderCategory      = 'TO'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDER",
"R_SETTLMTMGMTREFDOCPROCESSFLOW"
],
"ASSOCIATED":
[
"R_FRTCOSTALLOCDOC",
"R_FRTCOSTALLOCITM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More