I_SUPLRFRTINVCREQUESTITEM

CDS View

Supplier Freight Invoice Request Item

I_SUPLRFRTINVCREQUESTITEM is a CDS View in S/4HANA. Supplier Freight Invoice Request Item. It contains 6 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 6 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_CollabnApplMngFrtOrdChrgNote view_entity inner CONSUMPTION Freight Order Charges Notes
I_FrtCarrInvcInvcAmt view_entity from COMPOSITE Invoice Amount for Freight Carrier Invc
I_FrtCarrInvcVarcAmt view_entity from COMPOSITE Variance Amount for Freight Carrier Invoice
P_CollabnFrtOrdChrgFilterFo view from CONSUMPTION Private view to exclude FO with invoice

Fields (6)

KeyField CDS FieldsUsed in Views
KEY SuplrFrtInvcReqItemUUID FrtCarrInvcItemUUID,SuplrFrtInvcReqItemUUID 3
KEY SuplrFrtInvcReqUUID FrtCarrInvcUUID,SuplrFrtInvcReqUUID 3
SupplierFreightInvoiceReqItem SupplierFreightInvoiceReqItem 1
TransportationOrderItemUUID TransportationOrderItemUUID 2
TransportationOrderStageUUID TransportationOrderStageUUID 2
TransportationOrderUUID TransportationOrderUUID 4 
@EndUserText:   {   label:              'Supplier Freight Invoice Request Item'}
@ObjectModel:   {   representativeKey:  'SuplrFrtInvcReqItemUUID',
                    usageType:          { serviceQuality: #A,
                                          sizeCategory:   #M,
                                          dataClass:      #TRANSACTIONAL }}
@VDM:           {   viewType:           #BASIC}
@AccessControl: {   authorizationCheck: #PRIVILEGED_ONLY,
                    personalData.blocking: #NOT_REQUIRED }

define view entity I_SuplrFrtInvcRequestItem
  as select from /scmtms/d_sf_itm
  association to I_SupplierFreightInvoiceReq as _SupplierFreightInvoiceReq on $projection.SuplrFrtInvcReqUUID = _SupplierFreightInvoiceReq.SuplrFrtInvcReqUUID
{
  key db_key          as SuplrFrtInvcReqItemUUID,
      parent_key      as SuplrFrtInvcReqUUID,
      item_id         as SupplierFreightInvoiceReqItem,
      item_parent_key as SuplrFrtInvcReqItmParentUUID,
      disputed        as SuplrFrtInvcReqItemIsDisputed,
      tor_root_key    as TransportationOrderUUID,
      tor_item_tr_key as TransportationOrderItemUUID,
      tor_stage_key   as TransportationOrderStageUUID,

      /*Associations*/
      _SupplierFreightInvoiceReq
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_SF_ITM"
],
"ASSOCIATED":
[
"I_SUPPLIERFREIGHTINVOICEREQ"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More