I_BUSPARTSOURCEPACKAGETP

CDS View

Business Partner Source Data Packages

I_BUSPARTSOURCEPACKAGETP is a CDS View in S/4HANA. Business Partner Source Data Packages. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BusPartSourcePackageTP view_entity projection CONSUMPTION Projection View Business Partner Source Package 
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true
@EndUserText.label: 'Business Partner Source Data Packages'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.viewType: #TRANSACTIONAL
define root view entity I_BusPartSourcePackageTP

  as select from I_BusinessPartnerSourcePackage as _BusinessPartnerSourcePackage

  association [0..1] to I_LatestMasterDataImport       as _LatestMasterDataImport    on  _BusinessPartnerSourcePackage.MDChgProcessSrceSystem = _LatestMasterDataImport.MasterDataImportSourceSystem
                                                                                     and _BusinessPartnerSourcePackage.MDChgProcessSrceFilter = _LatestMasterDataImport.MasterDataImportSourceFilter
  association [0..1] to I_BusPartSourceConsolidated    as _ConsolidatedSourceRecords on  _BusinessPartnerSourcePackage.MDChgProcessSrceSystem = _ConsolidatedSourceRecords.MDChgProcessSrceSystem
                                                                                     and _BusinessPartnerSourcePackage.MDChgProcessSrceFilter = _ConsolidatedSourceRecords.MDChgProcessSrceFilter
  association [0..1] to I_BusinessPartnerSourceProcess as _ProcessedSourceRecords    on  _BusinessPartnerSourcePackage.MDChgProcessSrceSystem = _ProcessedSourceRecords.MDChgProcessSrceSystem
                                                                                     and _BusinessPartnerSourcePackage.MDChgProcessSrceFilter = _ProcessedSourceRecords.MDChgProcessSrceFilter
  association [0..1] to I_UserContactCard              as _RequestorContactCard      on  $projection.MasterDataImportCreator = _RequestorContactCard.ContactCardID
{
  key MDChgProcessSrceSystem,
      @Search.defaultSearchElement: true
  key MDChgProcessSrceFilter,
      MDChgProcessNmbrOfSrceRecords,
      _LatestMasterDataImport.MasterDataImportCreator                                                         as MasterDataImportCreator,
      tstmp_to_dats( _LatestMasterDataImport.LatestMDImportCreationDateTime, 'UTC', $session.client, 'NULL' ) as MDImportCreationDate,
      case
        when _ConsolidatedSourceRecords.MDChgProcNmbrOfCnsldtdSrce is not null
        and _ProcessedSourceRecords.MDChgProcNmbrOfSrceInProcess is not null
          then MDChgProcessNmbrOfSrceRecords - _ConsolidatedSourceRecords.MDChgProcNmbrOfCnsldtdSrce - _ProcessedSourceRecords.MDChgProcNmbrOfSrceInProcess
        when _ConsolidatedSourceRecords.MDChgProcNmbrOfCnsldtdSrce is not null
          then MDChgProcessNmbrOfSrceRecords - _ConsolidatedSourceRecords.MDChgProcNmbrOfCnsldtdSrce
        when _ProcessedSourceRecords.MDChgProcNmbrOfSrceInProcess is not null
          then MDChgProcessNmbrOfSrceRecords - _ProcessedSourceRecords.MDChgProcNmbrOfSrceInProcess
        else
          MDChgProcessNmbrOfSrceRecords
      end                                                                                                     as MDChgProcNmbrOfInitSrceRecords,
      _ConsolidatedSourceRecords.MDChgProcNmbrOfCnsldtdSrce                                                   as MDChgProcNmbrOfCnsldtdSrce,
      _ProcessedSourceRecords.MDChgProcNmbrOfSrceInProcess                                                    as MDChgProcNmbrOfSrceInProcess,

      _RequestorContactCard,
      _BusinessPartnerSource,
      _LatestMasterDataImport
}

Learn More