I_SVTCALCULATION

CDS View

Substance Volume Tracking Calculation

I_SVTCALCULATION is a CDS View in S/4HANA. Substance Volume Tracking Calculation. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SVTCalculation view_entity from CONSUMPTION SVT Calculation
I_MatlDocsByMonthAndBusProcess view inner COMPOSITE Mat Doc Info By Month and Bus Process 
@AbapCatalog.sqlViewName: 'SVTCALCN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Substance Volume Tracking Calculation'

@VDM.viewType: #BASIC

@ObjectModel: {
    usageType:{
        dataClass: #TRANSACTIONAL,
        serviceQuality: #A,
        sizeCategory: #L
      }
}

@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_SVTCalculation
  as select from ehpmad_svt_clhdr
  association [0..1] to I_Country                as _CountryFrom         on $projection.SubstVolSourceCountry = _CountryFrom.Country
  association [0..1] to I_Country                as _CountryTo           on $projection.SubstVolTargetCountry = _CountryTo.Country
  association [0..1] to I_Supplier               as _Supplier            on $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_ImprtRespyRespImporter as _ResponsibleImporter on $projection.SVTBizProcCatRespImporter = _ResponsibleImporter.ImprtRespyRespImporter
{
  key svtcalculationheaderuuid                    as SVTCalculationUUID,
      svtpreprocesseddocumentuuid                 as SVTPreprocessedDocumentUUID,
      compliancerequirement                       as ComplianceRequirement,
      svtpreprocesseddocumentdate                 as SVTPreprocessedDocumentDate,
      material                                    as Material,
      plant                                       as Plant,
      cast(applicationloghandle as abap.char(22)) as ApplicationLogHandle,
      legalentitymapuuid                          as ProdCmplncLglEntyMappgUUID,
      calculationisdeleted                        as CalculationIsDeleted,
      supplierid                                  as Supplier,
      svtbusinessprocess                          as SVTBusinessProcess,
      svtbusinessprocessscenario                  as SVTBusinessProcessScenario,
      companycode                                 as CompanyCode,
      legalentity                                 as LegalEntity,
      responsibleimporter                         as SVTBizProcCatRespImporter,
      chmlsuplrmatlimprtrespyuuid                 as ChmlSuplrMatlImprtRespyUUID,
      substvolcountryfrom                         as SubstVolSourceCountry,
      substvolcountryto                           as SubstVolTargetCountry,
      businesspartnersupplier                     as BusinessPartnerSupplier,
      businesspartnercustomer                     as BusinessPartnerCustomer,
      breakdownpolymers                           as PolymerBreakdownIsRequired,
      ispolymerexcluded                           as PolymerExclusionIsRequired,
      svtcalculationlastresultuuid                as SVTCalculationLastResultUUID,

      _CountryFrom,
      _CountryTo,
      _Supplier,
      _ResponsibleImporter
}
//where calculationisdeleted = ''

Learn More