I_ReturnsInspectionCode

DDL: I_RETURNSINSPECTIONCODE Type: view_entity BASIC Package: VDM_ARM_BASICS

Returns Inspection Code

I_ReturnsInspectionCode is a Basic CDS View (Dimension) that provides data about "Returns Inspection Code" in SAP S/4HANA. It reads from 2 data sources (qpcd, msr_c_inspcat) and exposes 2 fields with key field ReturnsInspectionCode. Part of development package VDM_ARM_BASICS.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
qpcd InspCtlgCode from
msr_c_inspcat ProdInspCtlgAndCodeGrp inner

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Returns Inspection Code view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey ReturnsInspectionCode view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name ReturnsInspectionResult view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ReturnsInspectionCode qpcd code
_Text _Text 
@AbapCatalog.viewEnhancementCategory  : [ #NONE]
@AccessControl.authorizationCheck     : #NOT_REQUIRED
@EndUserText.label                    : 'Returns Inspection Code'
@Metadata.ignorePropagatedAnnotations : true
@ObjectModel.usageType                : {
  serviceQuality : #A,
  sizeCategory   : #S,
  dataClass      : #MIXED
}
@ObjectModel.representativeKey        : 'ReturnsInspectionCode'
@ObjectModel.modelingPattern          : #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities    : [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET,
  #ANALYTICAL_DIMENSION,
  #EXTRACTION_DATA_SOURCE
]
@ObjectModel.sapObjectNodeType.name   : 'ReturnsInspectionResult'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true, internalName:#LOCAL }
@VDM.viewType                         : #BASIC
@VDM.lifecycle.contract.type          : #PUBLIC_LOCAL_API

define view entity I_ReturnsInspectionCode as
  select from qpcd as InspCtlgCode
  inner join msr_c_inspcat as ProdInspCtlgAndCodeGrp on  InspCtlgCode.katalogart = ProdInspCtlgAndCodeGrp.def_cat
                                                     and InspCtlgCode.codegruppe = ProdInspCtlgAndCodeGrp.def_code_grp
  association[1..*] to I_ReturnsInspectionCodeText as _Text on $projection.ReturnsInspectionCode = _Text.ReturnsInspectionCode 
{

    //Key

    @ObjectModel.text.association : '_Text'
    key InspCtlgCode.code as ReturnsInspectionCode,

    //Associations

    _Text
}
where
  InspCtlgCode.inaktiv = ''

Learn More