C_ProdCmplncProdReqSftyDataSht

DDL: C_PRODCMPLNCPRODREQSFTYDATASHT SQL: CPCPRSDS Type: view CONSUMPTION Package: EHFND_SDSA_SERVICE_INTEGRATION

Product Request Safety Data Sheets

C_ProdCmplncProdReqSftyDataSht is a Consumption CDS View that provides data about "Product Request Safety Data Sheets" in SAP S/4HANA. It reads from 1 data source (P_ProdCmplncProdReqSftyDataSht) and exposes 9 fields with key fields ChmlCmplncInfoUUID, CmplRqVersUUID, CmplRqRsltUUID, Language. It has 1 association to related views. Part of development package EHFND_SDSA_SERVICE_INTEGRATION.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_ProdCmplncProdReqSftyDataSht SftyDataShtDoc from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_LanguageText _LanguageText $projection.Language = _LanguageText.LanguageCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPCPRSDS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Product Request Safety Data Sheets view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
UI.headerInfo.typeName Requested Safety Data Sheet view
UI.headerInfo.typeNamePlural Requested Safety Data Sheets view
UI.headerInfo.title.value CmplRqVersName view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID P_ProdCmplncProdReqSftyDataSht ChmlCmplncInfoUUID
KEY CmplRqVersUUID P_ProdCmplncProdReqSftyDataSht CmplRqVersUUID
KEY CmplRqRsltUUID P_ProdCmplncProdReqSftyDataSht CmplRqRsltUUID
KEY Language P_ProdCmplncProdReqSftyDataSht Language
CmplRqVersName P_ProdCmplncProdReqSftyDataSht CmplRqVersName
CmplRqUUID P_ProdCmplncProdReqSftyDataSht CmplRqUUID
EffectiveDate P_ProdCmplncProdReqSftyDataSht EffectiveDate
_Language P_ProdCmplncProdReqSftyDataSht _Language
_LanguageText _LanguageText 
@AbapCatalog.sqlViewName: 'CPCPRSDS'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Product Request Safety Data Sheets'

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  // blocking of personal data not required (no personal data fields exposed for material; user can not be blocked)

  personalData.blocking: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  semanticKey:  [ 'CmplRqVersName' ],
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

@UI:
{
  headerInfo : {
    typeName : 'Requested Safety Data Sheet',
    typeNamePlural : 'Requested Safety Data Sheets',
    title.value : 'CmplRqVersName'
  }
}
define view C_ProdCmplncProdReqSftyDataSht
  as select from P_ProdCmplncProdReqSftyDataSht as SftyDataShtDoc

  association [0..*] to I_LanguageText as _LanguageText on $projection.Language = _LanguageText.LanguageCode
{
  key SftyDataShtDoc.ChmlCmplncInfoUUID,
  key SftyDataShtDoc.CmplRqVersUUID,
  key SftyDataShtDoc.CmplRqRsltUUID,

      @ObjectModel.text.association: '_LanguageText'
  key SftyDataShtDoc.Language,

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

      /**** Associations ****/
      SftyDataShtDoc._Language,
      _LanguageText
}

Learn More