P_WORKVIEWCMPLNCDATAUNION

CDS View

Work View Compliance Data Union

P_WORKVIEWCMPLNCDATAUNION is a CDS View in S/4HANA. Work View Compliance Data Union. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_WorkViewCmplncData view from CONSUMPTION Work View Compliance Data 
@AbapCatalog: {
  sqlViewName: 'PWVCDU',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Work View Compliance Data Union'

define view P_WorkViewCmplncDataUnion
  as select from P_ChmlCmplncInfoProperty as ChmlCmplncInfoProperty
{

  key   ChmlCmplncInfoUUID,
        ChmlCmplncInfoProperty.PCPrptyNavgnLinkUUID                           as ComplianceDataNavgnLinkUUID,
        cast ('          ' as ehfnd_legal_area preserving type )              as ProdCmplncLegalArea,
        cast (hextobin('00000000000000000000000000000000') as ehfnd_crv_uuid) as CmplRqVersUUID,
        cast ('' as ehfnd_req_identifier)                                     as ComplianceRequirement,
        cast('' as ehfnd_crr_crv_name)                                        as CmplRqVersName,
        ChmlCmplncInfoProperty.PCPrptyRootType                                as PCPrptyRootType,
        cast ('          ' as ehfnd_cci_ccmps_type preserving type )          as ChmlCompositionType,
        cast ('                              ' as abap.char( 30 ) )           as CmplRqPattern,
        ChmlCmplncInfoProperty.PCPrptyInProcProcgSts                          as PCPrptyInProcProcgSts,
        ChmlCmplncInfoProperty.PCPrptyReldProcgSts                            as PCPrptyReldProcgSts,
        cast (' ' as ehfnd_crr_proc_status)                                   as ProcessingStatus,
        cast('' as ehpma_processor_name )                                     as ProcessorUserName,
        ChmlCmplncInfoProperty._ReleasedByUser.PersonFullName                 as ReleasedByUserName,
        ChmlCmplncInfoProperty.WorkViewGroupName,
        ChmlCmplncInfoProperty.WorkView,
        ChmlCmplncInfoProperty.WorkViewUUID,
        PCPrptySequence
}

union

select from P_ChmlCmplncInfoComposition as ChmlCmplncInfoComposition
{
  key   ChmlCmplncInfoUUID,
        ChmlCmplncInfoComposition.ChmlCompositionUUID                         as ComplianceDataNavgnLinkUUID,
        ProdCmplncLegalArea,
        cast (hextobin('00000000000000000000000000000000') as ehfnd_crv_uuid) as CmplRqVersUUID,
        cast ('' as ehfnd_req_identifier)                                     as ComplianceRequirement,
        cast('' as ehfnd_crr_crv_name)                                        as CmplRqVersName,
        ''                                                                    as PCPrptyRootType,
        ChmlCmplncInfoComposition.ChmlCompositionType                         as ChmlCompositionType,
        cast ('                              ' as abap.char( 30 ) )           as CmplRqPattern,
        ChmlCmplncInfoComposition.ChmlCmpstnInProcStatus                      as PCPrptyInProcProcgSts,
        ChmlCmplncInfoComposition.ChmlCmpstnReldStatus                        as PCPrptyReldProcgSts,
        cast (' ' as ehfnd_crr_proc_status)                                   as ProcessingStatus,
        cast('' as ehpma_processor_name)                                      as ProcessorUserName,
        ChmlCmplncInfoComposition._ReleasedByUser.PersonFullName              as ReleasedByUserName,
        ChmlCmplncInfoComposition.WorkViewGroupName,
        ChmlCmplncInfoComposition.WorkView,
        ChmlCmplncInfoComposition.WorkViewUUID,
        PCPrptySequence
}

union

select from P_ChmlCmplncInfoAssmt as ChmlCmplncInfoAssmt
{
  key   ChmlCmplncInfoUUID,
        ChmlCmplncInfoAssmt.CmplRqRsltUUID                           as ComplianceDataNavgnLinkUUID,
        cast ('          ' as ehfnd_legal_area preserving type )     as ProdCmplncLegalArea,
        ChmlCmplncInfoAssmt.CmplRqVersUUID                           as CmplRqVersUUID,
        ChmlCmplncInfoAssmt.ComplianceRequirement                    as ComplianceRequirement,
        ChmlCmplncInfoAssmt.CmplRqVersName                           as CmplRqVersName,
        ''                                                           as PCPrptyRootType,
        cast ('          ' as ehfnd_cci_ccmps_type preserving type ) as ChmlCompositionType,
        ChmlCmplncInfoAssmt.CmplRqPattern                            as CmplRqPattern,
        ''                                                           as PCPrptyInProcProcgSts,
        ''                                                           as PCPrptyReldProcgSts,
        ChmlCmplncInfoAssmt.ProcessingStatus                         as ProcessingStatus,
        ChmlCmplncInfoAssmt._ProcessorUser.PersonFullName            as ProcessorUserName,
        ChmlCmplncInfoAssmt._ReleasedByUser.PersonFullName           as ReleasedByUserName,
        ChmlCmplncInfoAssmt.WorkViewGroupName,
        ChmlCmplncInfoAssmt.WorkView,
        ChmlCmplncInfoAssmt.WorkViewUUID,
        PCPrptySequence
}

Learn More