I_CABillgSourceTransRefType

DDL: I_CABILLGSOURCETRANSREFTYPE Type: view_entity BASIC Package: FKKINV_VDM_UTILS

Source Transaction Reference Type

I_CABillgSourceTransRefType is a Basic CDS View (Dimension) that provides data about "Source Transaction Reference Type" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field CABillgSourceTransRefType. It has 1 association to related views. Part of development package FKKINV_VDM_UTILS.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_CABillgSourceTransRefTypeTxt _CABillgSourceTransRefTypeTxt $projection.CABillgSourceTransRefType = _CABillgSourceTransRefTypeTxt.CABillgSourceTransRefType

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
EndUserText.label Source Transaction Reference Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CABillgSourceTransRefType view
ObjectModel.sapObjectNodeType.name CABillgSrceTransRefType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CABillgSourceTransRefType
_CABillgSourceTransRefTypeTxt _CABillgSourceTransRefTypeTxt
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction.enabled: true,
  internalName: #LOCAL
}
@EndUserText.label: 'Source Transaction Reference Type'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  modelingPattern: #ANALYTICAL_DIMENSION,
  representativeKey: 'CABillgSourceTransRefType',
  sapObjectNodeType.name: 'CABillgSrceTransRefType',
  supportedCapabilities: [
    #ANALYTICAL_DIMENSION,
    #CDS_MODELING_ASSOCIATION_TARGET,
    #CDS_MODELING_DATA_SOURCE,
    #EXTRACTION_DATA_SOURCE,
    #SQL_DATA_SOURCE
  ],
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S
  }
}
@VDM.viewType: #BASIC
define view entity I_CABillgSourceTransRefType
  as select from dd07l

  association [1..*] to I_CABillgSourceTransRefTypeTxt as _CABillgSourceTransRefTypeTxt on $projection.CABillgSourceTransRefType = _CABillgSourceTransRefTypeTxt.CABillgSourceTransRefType
{
      @ObjectModel.text.association: '_CABillgSourceTransRefTypeTxt'
  key cast ( substring( dd07l.domvalue_l,1,1 )  as bill_srcreftype_kk preserving type ) as CABillgSourceTransRefType,
      _CABillgSourceTransRefTypeTxt
}
where
      domname  = 'BILL_SRCREFTYPE_KK'
  and as4local = 'A'