I_SPQtnItemProdFprntCollCode

DDL: I_SPQTNITEMPRODFPRNTCOLLCODE Type: view_entity BASIC

Collection Status of Product Footprint

I_SPQtnItemProdFprntCollCode is a Basic CDS View that provides data about "Collection Status of Product Footprint" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field SPQtnItemProdFprntCollCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SPQtnItmProdFprntCollCodeTxt _SPQtnItmProdFprntCollCodeTxt

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SPQtnItemProdFprntCollCode view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view
Search.searchable true view
Consumption.ranked true view
Feature SW:PROD_SRCG_PROD_FPRNT view
EndUserText.label Collection Status of Product Footprint view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SPQtnItemProdFprntCollCode
DomainValue dd07l domvalue_l
_SPQtnItmProdFprntCollCodeTxt _SPQtnItmProdFprntCollCodeTxt
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel:{
    representativeKey: 'SPQtnItemProdFprntCollCode',
    dataCategory: #VALUE_HELP,
    resultSet.sizeCategory: #XS,
    usageType:{
        dataClass: #MASTER,
        serviceQuality: #A,
        sizeCategory: #S
        },
    supportedCapabilities: [#SEARCHABLE_ENTITY,#SQL_DATA_SOURCE,#CDS_MODELING_DATA_SOURCE,#CDS_MODELING_ASSOCIATION_TARGET,#VALUE_HELP_PROVIDER,#SEARCHABLE_ENTITY],
    modelingPattern: #NONE
    }

@VDM.viewType: #BASIC

@Search.searchable: true
@Consumption.ranked:true
@Feature:'SW:PROD_SRCG_PROD_FPRNT'
@EndUserText.label: 'Collection Status of Product Footprint'
define root view entity I_SPQtnItemProdFprntCollCode
  as select from dd07l
  composition [0..*] of I_SPQtnItmProdFprntCollCodeTxt as _SPQtnItmProdFprntCollCodeTxt
{
      @ObjectModel.text.association: '_SPQtnItmProdFprntCollCodeTxt'
  key cast( dd07l.domvalue_l as vdm_spqtnitemprodfprntcollcode ) as SPQtnItemProdFprntCollCode,
      @Consumption.hidden: true
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      dd07l.domvalue_l                                           as DomainValue,
      _SPQtnItmProdFprntCollCodeTxt
}
where
      domname  = 'VDM_SPQTNITEMPRODFPRNTCOLLCODE'
  and as4local = 'A'
  and as4vers  = '0000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_SPQTNITMPRODFPRNTCOLLCODETXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/