R_DIGITALVEHSLSORDCONFIGNVALTP

CDS View

Digital Vehicle Sales Order Config

R_DIGITALVEHSLSORDCONFIGNVALTP is a CDS View in S/4HANA. Digital Vehicle Sales Order Config. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_DigitalVehSlsOrdConfignVal view_entity projection CONSUMPTION Digital Vehicle Sales Order Config Val 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Digital Vehicle Sales Order Config'
@ObjectModel: {
    usageType: {
        sizeCategory: #XXL,
        serviceQuality: #C,
        dataClass:#MIXED
    },
    semanticKey: ['SalesDocument','SalesDocumentItem','VariantConfigurationValueID','CharcInternalID']
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations:true
define view entity R_DigitalVehSlsOrdConfignValTP
  as select from 
//  I_SalesDocumentItem        as _SalesDocumentItem

//    inner join   I_SalesDocument            as _SalesDocument            on  _SalesDocument.SalesDocument      = _SalesDocumentItem.SalesDocument

//                                                                         and _SalesDocument.SDDocumentCategory = 'C' 

//    inner join  

//    I_DgtlVehSlsConfignVal as _DigitalVehicleConfignVal

     I_DigitalVehicleConfignVal as _DigitalVehicleConfignVal
//      on  _DigitalVehicleConfignVal.ConfigurationNumber           = _SalesDocumentItem.ProductConfiguration

//                                                                         and _DigitalVehicleConfignVal.VarConfignInstceBusObjectType = 'VBPS'

//                                                                         and _DigitalVehicleConfignVal.VarConfignInstceBusObjectKey =

//                                                                              concat(_SalesDocumentItem.SalesDocument, _SalesDocumentItem.SalesDocumentItem)

  association to parent R_DigitalVehSlsOrdConfignTP as _DigitalVehSlsOrdConfign  on  $projection.SalesDocument     = _DigitalVehSlsOrdConfign.SalesDocument
                                                                                 and $projection.SalesDocumentItem = _DigitalVehSlsOrdConfign.SalesDocumentItem
                                                                                 and $projection.Characteristic    = _DigitalVehSlsOrdConfign.Characteristic
  association to R_DigitalVehSlsOrdItemTP_2         as _DigitalVehSlsOrdItemTP_2 on  $projection.SalesDocument     = _DigitalVehSlsOrdItemTP_2.SalesDocument
                                                                                 and $projection.SalesDocumentItem = _DigitalVehSlsOrdItemTP_2.SalesDocumentItem

{

  key           _DigitalVehicleConfignVal.SalesDocument,
  key           _DigitalVehicleConfignVal.SalesDocumentItem,
  key           _DigitalVehicleConfignVal.VariantConfigurationValueID,
  key           _DigitalVehicleConfignVal.CharcInternalID,
                _DigitalVehicleConfignVal.Characteristic,
                _DigitalVehicleConfignVal.CharcValue,
                _DigitalVehicleConfignVal.CharcFromDate,
                _DigitalVehicleConfignVal.CharcFromTime,
                @Semantics.amount.currencyCode: 'CharacteristicCurrency'
                _DigitalVehicleConfignVal.CharcFromAmount,
                _DigitalVehicleConfignVal.CharacteristicCurrency,
                _DigitalVehicleConfignVal.CharcFromNumericValue,
                _DigitalVehicleConfignVal.ConfigurationNumber,
                // included unit of measure technical name

                _DigitalVehicleConfignVal.UnitOfMeasureTechnicalName,
                _DigitalVehSlsOrdConfign,
                _DigitalVehSlsOrdItemTP_2
} where _DigitalVehicleConfignVal.SalesDocument <> ''
      and _DigitalVehicleConfignVal.SDDocumentCategory = 'C'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DIGITALVEHICLECONFIGNVAL"
],
"ASSOCIATED":
[
"R_DIGITALVEHSLSORDCONFIGNTP",
"R_DIGITALVEHSLSORDITEMTP_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More