P_PRODCMPLNCPRODREQSFTYDATASHT

CDS View

P_PRODCMPLNCPRODREQSFTYDATASHT is a CDS View in S/4HANA. It contains 8 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 8 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProdCmplncProdReqSftyDataSht view from CONSUMPTION Product Request Safety Data Sheets

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID 1
KEY CmplRqRsltUUID CmplRqRsltUUID 1
KEY CmplRqVersUUID CmplRqVersUUID 1
KEY Language Language 1
_Language _Language 1
CmplRqUUID CmplRqUUID 1
CmplRqVersName CmplRqVersName 1
EffectiveDate EffectiveDate 1 
@AbapCatalog.sqlViewName: 'PPCPRSDS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ProdCmplncProdReqSftyDataSht
  as select from P_CmplRqRsltSftyDataShtDoc as SftyDataShtDoc

    // use only sds data for the latest active crv version

    inner join            P_CmplncRqmtNewestActvRev  as _latestActiveCrv on  _latestActiveCrv.CmplRqVersUUID    = SftyDataShtDoc.CmplRqVersUUID

{
  key SftyDataShtDoc.ChmlCmplncInfoUUID,
  key SftyDataShtDoc.CmplRqVersUUID,
  key SftyDataShtDoc.CmplRqRsltUUID,

  key SftyDataShtDoc.Language,

      SftyDataShtDoc.CmplRqVersName,
      SftyDataShtDoc.CmplRqUUID,
      SftyDataShtDoc.EffectiveDate,

      /**** Associations ****/
      SftyDataShtDoc._Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CMPLNCRQMTNEWESTACTVREV",
"P_CMPLRQRSLTSFTYDATASHTDOC"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[
"P_CMPLRQRSLTSFTYDATASHTDOC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More