C_InspSpecVersionsObjPage

DDL: C_INSPSPECVERSIONSOBJPAGE SQL: CINSPSPEVERSCOP Type: view CONSUMPTION

Inspection Specification Versions

C_InspSpecVersionsObjPage is a Consumption CDS View that provides data about "Inspection Specification Versions" in SAP S/4HANA. It reads from 1 data source (I_InspSpecificationVersion) and exposes 11 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSpecificationVersion I_InspSpecificationVersion from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CINSPSPEVERSCOP view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Inspection Specification Versions view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant I_InspSpecificationVersion InspectionSpecificationPlant
KEY InspectionSpecification I_InspSpecificationVersion InspectionSpecification
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion
InspectionSpecificationText
InspSpecTransferType I_InspSpecificationVersion InspSpecTransferType
InspSpecTransferTypeText
ValidityStartDate I_InspSpecificationVersion ValidityStartDate
QltyMstrDataAuthorizationGroup I_InspSpecificationVersion QltyMstrDataAuthorizationGroup
InspectionSpecificationStatus I_InspSpecificationVersion InspectionSpecificationStatus
_QltyMstrDataAuthznGrp _QltyMstrDataAuthznGrp
_InspSpecStatus _InspSpecStatus 
@AbapCatalog.sqlViewName: 'CINSPSPEVERSCOP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Inspection Specification Versions' //same as DDL description

@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK 
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M, //expected number of rows < 100.000

    serviceQuality: #C // includes A,B as well

}

@UI.presentationVariant: [
  {
    sortOrder: [{ by: 'ValidityStartDate', direction: #DESC },
                { by: 'InspectionSpecificationVersion', direction: #DESC }] 
  }
]

define view C_InspSpecVersionsObjPage
   as select from I_InspSpecificationVersion
    
{
   @ObjectModel.foreignKey.association: null
   @UI.hidden: true
   key I_InspSpecificationVersion.InspectionSpecificationPlant,
   @ObjectModel.foreignKey.association: null
   @UI.hidden: true
   key I_InspSpecificationVersion.InspectionSpecification,
   @ObjectModel.foreignKey.association: null
   @UI.lineItem: [{position:10,importance: #HIGH}]
   key I_InspSpecificationVersion.InspectionSpecificationVersion,
   
   @UI.lineItem: [{position:20}]
   _Text[1:Language=$session.system_language].InspectionSpecificationText,
   
   @ObjectModel: {
      foreignKey.association: null,
      text.element: ['InspSpecTransferTypeText']
   }
   @UI: {
        lineItem: [{position:30}],
        textArrangement: #TEXT_ONLY
   }
   I_InspSpecificationVersion.InspSpecTransferType,
   @UI.hidden: true
   I_InspSpecificationVersion._InspSpecTransferTypeText[1:Language=$session.system_language].InspSpecTransferTypeText,
   @UI.lineItem: [{position:40}]
   I_InspSpecificationVersion.ValidityStartDate,
   
   @Consumption.hidden: true
   I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup,
   @Consumption.hidden: true
   I_InspSpecificationVersion.InspectionSpecificationStatus,
   
   @Consumption.hidden: true
   _QltyMstrDataAuthznGrp,
   @Consumption.hidden: true
   _InspSpecStatus
   
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPSPECIFICATIONVERSION",
"I_INSPSPECIFICATIONVERSIONTEXT",
"I_INSPSPECTRANSFERTYPETEXT"
],
"ASSOCIATED":
[
"I_INSPECTIONMSTRDATASTATUS",
"I_QLTYMSTRDATAAUTHORIZATIONGRP"
],
"BASE":
[
"I_INSPSPECIFICATIONVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More