I_InspSpecCatalogTP

DDL: I_INSPSPECCATALOGTP Type: view_entity TRANSACTIONAL

Catalogs of Master Characteristic

I_InspSpecCatalogTP is a Transactional CDS View that provides data about "Catalogs of Master Characteristic" in SAP S/4HANA. It reads from 1 data source (I_InspSpecCatalog) and exposes 17 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion, InspSpecAddlCatalogFieldGroup. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSpecCatalog I_InspSpecCatalog from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_InspectionCatalogText _InspSpecAddlCatalogText $projection.InspSpecAdditionalCatalog = _InspSpecAddlCatalogText.InspectionCatalog
[0..*] I_Inspectioncodegrouptext _InspSpecAddlCodeGroupText $projection.InspSpecAdditionalCatalog = _InspSpecAddlCodeGroupText.InspectionCatalog and $projection.InspSpecAdditionalCodeGroup = _InspSpecAddlCodeGroupText.InspectionCodeGroup

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Catalogs of Master Characteristic view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey InspSpecAddlCatalogFieldGroup view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant InspectionSpecificationPlant
KEY InspectionSpecification InspectionSpecification
KEY InspectionSpecificationVersion InspectionSpecificationVersion
KEY InspSpecAddlCatalogFieldGroup InspSpecAddlCatalogFieldGroup
InspSpecAdditionalCatalog InspSpecAdditionalCatalog
InspSpecAdditionalSelectedSet InspSpecAdditionalSelectedSet
InspSpecAdditionalCodeGroup InspSpecAdditionalCodeGroup
InspSpecAddlSeldCodeSetPlant InspSpecAddlSeldCodeSetPlant
_InspSpecificationVersion _InspSpecificationVersion
_InspectionSpecification _InspectionSpecification
_InspectionSpecificationPlant _InspectionSpecificationPlant
_InspSpecAddlCatalog _InspSpecAddlCatalog
_InspSpecAddlSelectedSet _InspSpecAddlSelectedSet
_InspSpecAddlCodeGroup _InspSpecAddlCodeGroup
_InspSpecAddlSeldCodeSetPlant _InspSpecAddlSeldCodeSetPlant
_InspSpecAddlCodeGroupText _InspSpecAddlCodeGroupText
_InspSpecAddlCatalogText _InspSpecAddlCatalogText 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Catalogs of Master Characteristic'
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel: {
    usageType: {
      dataClass: #MASTER,
      sizeCategory: #M, //expected number of rows < 100.000

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

    },
    representativeKey: 'InspSpecAddlCatalogFieldGroup'
}

define view entity I_InspSpecCatalogTP as select from I_InspSpecCatalog

  association to parent I_InspSpecificationVersionTP as  _InspSpecificationVersion
    on     $projection.InspectionSpecificationPlant   =  _InspSpecificationVersion.InspectionSpecificationPlant
       and $projection.InspectionSpecification        =  _InspSpecificationVersion.InspectionSpecification
       and $projection.InspectionSpecificationVersion =  _InspSpecificationVersion.InspectionSpecificationVersion
       
  association [0..*] to I_InspectionCatalogText as _InspSpecAddlCatalogText
    on $projection.InspSpecAdditionalCatalog = _InspSpecAddlCatalogText.InspectionCatalog
  
  association [0..*] to I_Inspectioncodegrouptext as _InspSpecAddlCodeGroupText
    on     $projection.InspSpecAdditionalCatalog   = _InspSpecAddlCodeGroupText.InspectionCatalog
       and $projection.InspSpecAdditionalCodeGroup = _InspSpecAddlCodeGroupText.InspectionCodeGroup

{
   key InspectionSpecificationPlant,
   key InspectionSpecification,
   key InspectionSpecificationVersion,
   key InspSpecAddlCatalogFieldGroup,
   
   InspSpecAdditionalCatalog,
   InspSpecAdditionalSelectedSet,
   InspSpecAdditionalCodeGroup,
   InspSpecAddlSeldCodeSetPlant,
   
   /* Compoistions */
   _InspSpecificationVersion,
   
   /* Associations */
   _InspectionSpecification,
   _InspectionSpecificationPlant,
   _InspSpecAddlCatalog,
   _InspSpecAddlSelectedSet,
   _InspSpecAddlCodeGroup,
   _InspSpecAddlSeldCodeSetPlant,
   _InspSpecAddlCodeGroupText,
   _InspSpecAddlCatalogText  
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPSPECCATALOG"
],
"ASSOCIATED":
[
"I_INSPECTIONCATALOG",
"I_INSPECTIONCATALOGTEXT",
"I_INSPECTIONCODEGROUP",
"I_INSPECTIONCODEGROUPTEXT",
"I_INSPECTIONSELECTEDSET",
"I_INSPECTIONSPECIFICATION",
"I_INSPSPECIFICATIONVERSIONTP",
"I_PLANT"
],
"BASE":
[
"I_INSPSPECCATALOG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More