I_ReturnsInspectionCodeText

DDL: I_RETURNSINSPECTIONCODETEXT Type: view_entity BASIC

Returns Inspection Code - Text

I_ReturnsInspectionCodeText is a Basic CDS View that provides data about "Returns Inspection Code - Text" in SAP S/4HANA. It reads from 2 data sources (qpct, msr_c_inspcat) and exposes 4 fields with key fields ReturnsInspectionCode, Language.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
qpct InspCtlgCodeTxt from
msr_c_inspcat ProdInspCtlgAndCodeGrp inner

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Returns Inspection Code - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ReturnsInspectionCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ReturnsInspectionCode qpct code
KEY Language qpct sprache
_ReturnsInspectionCode _ReturnsInspectionCode
_Language _Language 
@AbapCatalog.viewEnhancementCategory  : [ #NONE]
@AccessControl.authorizationCheck     : #NOT_REQUIRED
@EndUserText.label                    : 'Returns Inspection Code - Text'
@Metadata.ignorePropagatedAnnotations : true
@ObjectModel.dataCategory             : #TEXT
@ObjectModel.representativeKey        : 'ReturnsInspectionCode'
@ObjectModel.usageType                : {
  serviceQuality : #A,
  sizeCategory   : #S,
  dataClass      : #MIXED
}
@ObjectModel.modelingPattern          : #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities    : [
  #LANGUAGE_DEPENDENT_TEXT,
  #SQL_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET,
  #CDS_MODELING_DATA_SOURCE,
  #EXTRACTION_DATA_SOURCE
]
@Analytics.dataExtraction.enabled: true
@VDM.viewType                         : #BASIC
@VDM.lifecycle.contract.type          : #PUBLIC_LOCAL_API

define view entity I_ReturnsInspectionCodeText as
  select from qpct as InspCtlgCodeTxt
  inner join msr_c_inspcat as ProdInspCtlgAndCodeGrp on  InspCtlgCodeTxt.katalogart = ProdInspCtlgAndCodeGrp.def_cat
                                                     and InspCtlgCodeTxt.codegruppe = ProdInspCtlgAndCodeGrp.def_code_grp
  association[0..1] to I_ReturnsInspectionCode as _ReturnsInspectionCode on $projection.ReturnsInspectionCode = _ReturnsInspectionCode.ReturnsInspectionCode 
  association[0..1] to I_Language              as _Language              on $projection.Language = _Language.Language 
{

    //Key

    @ObjectModel.foreignKey.association : '_ReturnsInspectionCode'
    key InspCtlgCodeTxt.code as ReturnsInspectionCode,

    @Semantics.language                 : true
    @ObjectModel.foreignKey.association : '_Language'
    key InspCtlgCodeTxt.sprache as Language,

    //Description

    @Semantics.text                     : true
    cast(InspCtlgCodeTxt.kurztext as vdm_qtxt_code preserving
    type) as ReturnsInspectionCodeDesc,

    //Associations

    _ReturnsInspectionCode, 
    _Language
}

Learn More