I_CASubTransaction

DDL: I_CASUBTRANSACTION Type: view_entity BASIC

Document Subtransaction

I_CASubTransaction is a Basic CDS View (Dimension) that provides data about "Document Subtransaction" in SAP S/4HANA. It reads from 2 data sources (I_CAApplicationArea, tfktvo) and exposes 14 fields with key fields CAApplicationArea, CAMainTransaction, CASubTransaction. It has 5 associations to related views. It is exposed through 1 OData service (UI_CADOCUMENT_MNG).

2 data source(s) Exposed by 1 service(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_CAApplicationArea ApplArea inner
tfktvo tfktvo from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_CAApplicationArea _ApplArea $projection.CAApplicationArea = _ApplArea.CAApplicationArea
[1..1] I_CAMainTransaction _MainTransaction $projection.CAApplicationArea = _MainTransaction.CAApplicationArea and $projection.CAMainTransaction = _MainTransaction.CAMainTransaction
[0..1] I_CAMainTransaction _MainTransactionRev $projection.CAApplicationArea = _MainTransactionRev.CAApplicationArea and $projection.CAMainTransactionForReversal = _MainTransactionRev.CAMainTransaction
[0..1] I_CASubTransaction _SubTransactionRev $projection.CAApplicationArea = _SubTransactionRev.CAApplicationArea and $projection.CAMainTransactionForReversal = _SubTransactionRev.CAMainTransaction and $projection.CASubTransactionForReversal = _SubTransactionRev.CASubTransaction
[0..*] I_CASubTransactionText _Text $projection.CAApplicationArea = _Text.CAApplicationArea and $projection.CAMainTransaction = _Text.CAMainTransaction and $projection.CASubTransaction = _Text.CASubTransaction

Annotations (12)

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CAApplicationArea tfktvo applk
KEY CAMainTransaction tfktvo hvorg
KEY CASubTransaction tfktvo tvorg
CAMainTransactionForReversal tfktvo hvorg_rev
CASubTransactionForReversal tfktvo tvorg_rev
CADueDateDeterminationRule tfktvo faetp
CAWithholdingTaxAmountType tfktvo qsvtp
CARuleForAddlReceivables tfktvo rladdr
CAIsPaymentTransaction tfktvo xpayt
_ApplArea _ApplArea
_MainTransaction _MainTransaction
_MainTransactionRev _MainTransactionRev
_SubTransactionRev _SubTransactionRev
_Text _Text 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Document Subtransaction'

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

@ObjectModel: { modelingPattern: #ANALYTICAL_DIMENSION,
                representativeKey: 'CASubTransaction',
                sapObjectNodeType.name: 'ContrAcctgSubtransaction',
                supportedCapabilities: [ #ANALYTICAL_DIMENSION,
                                         #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #SQL_DATA_SOURCE,
                                         #EXTRACTION_DATA_SOURCE ],
                usageType: { dataClass: #CUSTOMIZING,
                             serviceQuality: #A,
                             sizeCategory: #S } }

@VDM.viewType: #BASIC

define view entity I_CASubTransaction
  as select from tfktvo
    inner join   I_CAApplicationArea as ApplArea on tfktvo.applk = ApplArea.CAApplicationArea

  association [1..1] to I_CAApplicationArea    as _ApplArea           on  $projection.CAApplicationArea = _ApplArea.CAApplicationArea
  association [1..1] to I_CAMainTransaction    as _MainTransaction    on  $projection.CAApplicationArea = _MainTransaction.CAApplicationArea
                                                                      and $projection.CAMainTransaction = _MainTransaction.CAMainTransaction
  association [0..1] to I_CAMainTransaction    as _MainTransactionRev on  $projection.CAApplicationArea            = _MainTransactionRev.CAApplicationArea
                                                                      and $projection.CAMainTransactionForReversal = _MainTransactionRev.CAMainTransaction
  association [0..1] to I_CASubTransaction     as _SubTransactionRev  on  $projection.CAApplicationArea            = _SubTransactionRev.CAApplicationArea
                                                                      and $projection.CAMainTransactionForReversal = _SubTransactionRev.CAMainTransaction
                                                                      and $projection.CASubTransactionForReversal  = _SubTransactionRev.CASubTransaction
  association [0..*] to I_CASubTransactionText as _Text               on  $projection.CAApplicationArea = _Text.CAApplicationArea
                                                                      and $projection.CAMainTransaction = _Text.CAMainTransaction
                                                                      and $projection.CASubTransaction  = _Text.CASubTransaction
{
      @ObjectModel.foreignKey.association: '_ApplArea'
  key tfktvo.applk     as CAApplicationArea,
      @ObjectModel.foreignKey.association: '_MainTransaction'
  key tfktvo.hvorg     as CAMainTransaction,
      @ObjectModel.text.association: '_Text'
  key tfktvo.tvorg     as CASubTransaction,

      @ObjectModel.foreignKey.association: '_MainTransactionRev'
      tfktvo.hvorg_rev as CAMainTransactionForReversal,
      @ObjectModel.foreignKey.association: '_SubTransactionRev'
      tfktvo.tvorg_rev as CASubTransactionForReversal,
      tfktvo.faetp     as CADueDateDeterminationRule,
      tfktvo.qsvtp     as CAWithholdingTaxAmountType,
      tfktvo.rladdr    as CARuleForAddlReceivables,
      tfktvo.xpayt     as CAIsPaymentTransaction,
      /*
            hvorg_spl,
            tvorg_spl,
            xnega,
      */

      /* Associations */
      _ApplArea,
      _MainTransaction,
      _MainTransactionRev,
      _SubTransactionRev,
      _Text
}
where
  ApplArea.CAApplicationAreaIsActive = 'X'

Learn More