P_PRODCMPLNCPRODREQSFTYDATASHT
Product Request Safety Data Sheets
P_PRODCMPLNCPRODREQSFTYDATASHT is a CDS View in S/4HANA. Product Request Safety Data Sheets. It contains 8 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProdCmplncProdReqSftyDataSht | view | from | CONSUMPTION | Product Request Safety Data Sheets |
Fields (8)
| Key | Field | CDS Fields | Used 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
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
private: true,
viewType: #CONSUMPTION
}
@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
}