I_CmplRqRsltSftyDataShtDoc

DDL: I_CMPLRQRSLTSFTYDATASHTDOC SQL: ICRRSDSDOC Type: view BASIC

CmplRqRslt SDS Document Info

I_CmplRqRsltSftyDataShtDoc is a Basic CDS View that provides data about "CmplRqRslt SDS Document Info" in SAP S/4HANA. It reads from 1 data source (ehsdsv_crr_doc) and exposes 13 fields with key field CmplRqRsltDocInfoUUID. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
ehsdsv_crr_doc ehsdsv_crr_doc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRslt _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICRRSDSDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CmplRqRslt SDS Document Info view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey CmplRqRsltDocInfoUUID view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltDocInfoUUID cmplrqrsltdocinfouuid
CmplRqRsltUUID cmplrqrsltuuid
Language language
CmplRqRsltSftyDataShtDocStatus cmplrqrsltsftydatashtdocstatus
CreationDateTime creationdatetime
CreatedByUser createdbyuser
LastChangeDateTime lastchangedatetime
LastChangedByUser lastchangedbyuser
CmplRqRsltSftyDataShtCrtnDate cmplrqrsltsftydatashtcrtndate
CmplRqRsltSftyDataShtMajorVers cmplrqrsltsftydatashtmajorvers
CmplRqRsltSftyDataShtSubVers cmplrqrsltsftydatashtsubvers
_CmplRqRslt _CmplRqRslt
_Language _Language 
@AbapCatalog.sqlViewName: 'ICRRSDSDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CmplRqRslt SDS Document Info'

@VDM.viewType: #BASIC

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
    transactionalProcessingEnabled: true,
    usageType:
    {
      dataClass: #TRANSACTIONAL,
      sizeCategory: #L,
      serviceQuality: #B
    },
    representativeKey: 'CmplRqRsltDocInfoUUID'
}
define view I_CmplRqRsltSftyDataShtDoc
  as select from ehsdsv_crr_doc
  association [1..1] to I_CmplRqRslt as _CmplRqRslt on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
  association [1..1] to I_Language   as _Language   on $projection.Language = _Language.Language

{
      /****  Keys  ****/

  key cmplrqrsltdocinfouuid          as CmplRqRsltDocInfoUUID,

      cmplrqrsltuuid                 as CmplRqRsltUUID,


      /****  Content  ****/
      @ObjectModel.foreignKey.association: '_Language'
      language                       as Language,

      cmplrqrsltsftydatashtdocstatus as CmplRqRsltSftyDataShtDocStatus,

      creationdatetime               as CreationDateTime,

      createdbyuser                  as CreatedByUser,

      lastchangedatetime             as LastChangeDateTime,

      lastchangedbyuser              as LastChangedByUser,

      cmplrqrsltsftydatashtcrtndate  as CmplRqRsltSftyDataShtCrtnDate,

      cmplrqrsltsftydatashtmajorvers as CmplRqRsltSftyDataShtMajorVers,

      cmplrqrsltsftydatashtsubvers   as CmplRqRsltSftyDataShtSubVers,

      /**** Associations ****/

      _CmplRqRslt,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHSDSV_CRR_DOC"
],
"ASSOCIATED":
[
"I_CMPLRQRSLT",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More