I_RetMatlInspResultCode

DDL: I_RETMATLINSPRESULTCODE SQL: IRMMATINSPCODE Type: view BASIC Package: VDM_ARM_BASICS

Return Material Inspection Result Code

I_RetMatlInspResultCode is a Basic CDS View that provides data about "Return Material Inspection Result Code" in SAP S/4HANA. It reads from 2 data sources (qpcd, msr_c_inspcat) and exposes 2 fields with key field RetMatlInspResultCode. It has 1 association to related views. It is exposed through 1 OData service (UI_CUSTOMERRETURNMANAGE). Part of development package VDM_ARM_BASICS.

2 data source(s) Exposed by 1 service(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
qpcd InspCtlgCode from
msr_c_inspcat MatlInspCtlgAndCodeGrp inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_RetMatlInspResultCodeText _Text $projection.RetMatlInspResultCode = _Text.RetMatlInspResultCode

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IRMMATINSPCODE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Return Material Inspection Result Code view
VDM.viewType #BASIC view
ObjectModel.representativeKey RetMatlInspResultCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY RetMatlInspResultCode qpcd code
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IRMMATINSPCODE'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Return Material Inspection Result Code'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'RetMatlInspResultCode'
@ObjectModel.supportedCapabilities: 
  [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S

define view I_RetMatlInspResultCode
  //I_InspectionCode

  as select from qpcd          as InspCtlgCode
    inner join   msr_c_inspcat as MatlInspCtlgAndCodeGrp on  InspCtlgCode.katalogart = MatlInspCtlgAndCodeGrp.def_cat
                                                         and InspCtlgCode.codegruppe = MatlInspCtlgAndCodeGrp.def_code_grp

  association [1..*] to I_RetMatlInspResultCodeText as _Text on $projection.RetMatlInspResultCode = _Text.RetMatlInspResultCode

{
      //Key

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

      //Associations

      _Text
}
where
  InspCtlgCode.inaktiv = '' //Status of Inspection Code Group: initial is active

Learn More