I_FrtCarrInvcInvcAmt

DDL: I_FRTCARRINVCINVCAMT Type: view_entity COMPOSITE

Invoice Amount for Freight Carrier Invc

I_FrtCarrInvcInvcAmt is a Composite CDS View that provides data about "Invoice Amount for Freight Carrier Invc" in SAP S/4HANA. It reads from 3 data sources (I_SuplrFrtInvcRequestItem, I_TranspChargeItem, I_TranspChargeObject) and exposes 8 fields with key fields FrtCarrInvcUUID, FrtCarrInvcItemUUID.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_SuplrFrtInvcRequestItem I_SuplrFrtInvcRequestItem from
I_TranspChargeItem I_TranspChargeItem inner
I_TranspChargeObject I_TranspChargeObject inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
EndUserText.label Invoice Amount for Freight Carrier Invc view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FrtCarrInvcUUID I_SuplrFrtInvcRequestItem SuplrFrtInvcReqUUID
KEY FrtCarrInvcItemUUID I_SuplrFrtInvcRequestItem SuplrFrtInvcReqItemUUID
SupplierFreightInvoiceRequest
TransportationOrderUUID I_SuplrFrtInvcRequestItem TransportationOrderUUID
TransportationOrderItemUUID I_SuplrFrtInvcRequestItem TransportationOrderItemUUID
TransportationOrderStageUUID I_SuplrFrtInvcRequestItem TransportationOrderStageUUID
FrtCarrInvcInvoiceAmount
FrtCarrInvcInvcAmountCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Invoice Amount for Freight Carrier Invc'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity I_FrtCarrInvcInvcAmt
  as select from I_SuplrFrtInvcRequestItem
    inner join   I_TranspChargeObject on I_TranspChargeObject.TranspChargeHostDocumentUUID = I_SuplrFrtInvcRequestItem.SuplrFrtInvcReqUUID
    inner join   I_TranspChargeItem   on  I_TranspChargeItem.TransportationChargesObjUUID            = I_TranspChargeObject.TransportationChargesObjUUID
                                      and I_TranspChargeItem.TranspChargeItemTypeCode                = '1'
                                      and I_TranspChargeItem.RefTransportationOrderUUID              = I_SuplrFrtInvcRequestItem.TransportationOrderUUID
                                      and (
                                         (
                                           I_TranspChargeItem.RefTransportationOrderNodeUUID         = I_SuplrFrtInvcRequestItem.TransportationOrderUUID
                                           and I_SuplrFrtInvcRequestItem.TransportationOrderItemUUID = I_SuplrFrtInvcRequestItem.TransportationOrderStageUUID
                                         )
                                         or I_TranspChargeItem.RefTransportationOrderNodeUUID        = I_SuplrFrtInvcRequestItem.TransportationOrderItemUUID
                                         or I_TranspChargeItem.RefTransportationOrderNodeUUID        = I_SuplrFrtInvcRequestItem.TransportationOrderStageUUID
                                       )

{
  key I_SuplrFrtInvcRequestItem.SuplrFrtInvcReqUUID                      as FrtCarrInvcUUID,
  key I_SuplrFrtInvcRequestItem.SuplrFrtInvcReqItemUUID                  as FrtCarrInvcItemUUID,
      I_SuplrFrtInvcRequestItem._SupplierFreightInvoiceReq.SupplierFreightInvoiceRequest,
      I_SuplrFrtInvcRequestItem.TransportationOrderUUID,
      I_SuplrFrtInvcRequestItem.TransportationOrderItemUUID,
      I_SuplrFrtInvcRequestItem.TransportationOrderStageUUID,
      @Semantics.amount.currencyCode: 'FrtCarrInvcInvcAmountCurrency'
      I_TranspChargeItem._TranspChargeItemElement.InvoicedAmount         as FrtCarrInvcInvoiceAmount,
      I_TranspChargeItem._TranspChargeItemElement.InvoicedAmountCurrency as FrtCarrInvcInvcAmountCurrency
}
where
     I_SuplrFrtInvcRequestItem._SupplierFreightInvoiceReq.SuplrFrtInvcReqCategory = '50'
  or I_SuplrFrtInvcRequestItem._SupplierFreightInvoiceReq.SuplrFrtInvcReqCategory = '60';
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPLRFRTINVCREQUESTITEM",
"I_SUPPLIERFREIGHTINVOICEREQ",
"I_TRANSPCHARGEITEM",
"I_TRANSPCHARGEITEMELEMENT",
"I_TRANSPCHARGEOBJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More