I_CAMainTransaction

DDL: I_CAMAINTRANSACTION Type: view_entity BASIC

Document Main Transaction

I_CAMainTransaction is a Basic CDS View (Dimension) that provides data about "Document Main Transaction" in SAP S/4HANA. It reads from 2 data sources (I_CAApplicationArea, tfkhvo) and exposes 4 fields with key fields CAApplicationArea, CAMainTransaction. It has 2 associations to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_CAApplicationArea ApplArea inner
tfkhvo tfkhvo from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CAApplicationArea _ApplArea $projection.CAApplicationArea = _ApplArea.CAApplicationArea
[0..*] I_CAMainTransactionText _Text $projection.CAApplicationArea = _Text.CAApplicationArea and $projection.CAMainTransaction = _Text.CAMainTransaction

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
EndUserText.label Document Main Transaction view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey CAMainTransaction view
ObjectModel.sapObjectNodeType.name ContrAcctgMainTransaction view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CAApplicationArea tfkhvo applk
KEY CAMainTransaction tfkhvo hvorg
_ApplArea _ApplArea
_Text _Text 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@Analytics: { dataCategory: #DIMENSION,
              dataExtraction.enabled: true }

@EndUserText.label: 'Document Main Transaction'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { modelingPattern: #ANALYTICAL_DIMENSION,
                representativeKey: 'CAMainTransaction',
                sapObjectNodeType.name: 'ContrAcctgMainTransaction',
                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_CAMainTransaction
  as select from tfkhvo
    inner join   I_CAApplicationArea as ApplArea on tfkhvo.applk = ApplArea.CAApplicationArea

  association [1..1] to I_CAApplicationArea     as _ApplArea on  $projection.CAApplicationArea = _ApplArea.CAApplicationArea
  association [0..*] to I_CAMainTransactionText as _Text     on  $projection.CAApplicationArea = _Text.CAApplicationArea
                                                             and $projection.CAMainTransaction = _Text.CAMainTransaction
{
      @ObjectModel.foreignKey.association: '_ApplArea'
  key tfkhvo.applk as CAApplicationArea,
      @ObjectModel.text.association: '_Text'
  key tfkhvo.hvorg as CAMainTransaction,

      _ApplArea,
      _Text
}
where
  ApplArea.CAApplicationAreaIsActive = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAAPPLICATIONAREA",
"TFKHVO"
],
"ASSOCIATED":
[
"I_CAAPPLICATIONAREA",
"I_CAMAINTRANSACTIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More