I_CAIntTransactionAssignment

DDL: I_CAINTTRANSACTIONASSIGNMENT Type: view_entity BASIC Package: FKK_DOCUMENT
10 Fields 1 Data Sources 5 Associations

Document Internal Transaction Assignment

I_CAIntTransactionAssignment is a Basic CDS View that provides data about "Document Internal Transaction Assignment" in SAP S/4HANA. It reads from 1 data source (tfkivv) and exposes 10 fields with key fields CAApplicationArea, CAInternalMainTransaction, CAInternalSubtransaction. It has 5 associations to related views. Part of development package FKK_DOCUMENT.

Data Sources (1)

SourceAliasJoin Type
tfkivv tfkivv from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_CAApplicationArea _CAApplicationArea $projection.CAApplicationArea = _CAApplicationArea.CAApplicationArea
[1..1] I_CAInternalMainTransaction _CAInternalMainTransaction $projection.CAApplicationArea = _CAInternalMainTransaction.CAApplicationArea and $projection.CAInternalMainTransaction = _CAInternalMainTransaction.CAInternalMainTransaction
[1..1] I_CAInternalSubtransaction _CAInternalSubtransaction $projection.CAApplicationArea = _CAInternalSubtransaction.CAApplicationArea and $projection.CAInternalMainTransaction = _CAInternalSubtransaction.CAInternalMainTransaction and $projection.CAInternalSubtransaction = _CAInternalSubtransaction.CAInternalSubtransaction
[0..1] I_CAMainTransaction _CAMainTransaction $projection.CAApplicationArea = _CAMainTransaction.CAApplicationArea and $projection.CAMainTransaction = _CAMainTransaction.CAMainTransaction
[0..1] I_CASubTransaction _CASubTransaction $projection.CAApplicationArea = _CASubTransaction.CAApplicationArea and $projection.CAMainTransaction = _CASubTransaction.CAMainTransaction and $projection.CASubTransaction = _CASubTransaction.CASubTransaction

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Document Internal Transaction Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CAApplicationArea applk ApplicationArea
KEY CAInternalMainTransaction ihvor Int. main trans
KEY CAInternalSubtransaction itvor Int. Subtrans.
CAMainTransaction hvorg Main Transactn
CASubTransaction tvorg Subtransaction
_CAApplicationArea _CAApplicationArea
_CAInternalMainTransaction _CAInternalMainTransaction
_CAInternalSubtransaction _CAInternalSubtransaction
_CAMainTransaction _CAMainTransaction
_CASubTransaction _CASubTransaction

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CAIntTransactionAssignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CAIntTransactionAssignment AS
SELECT
  applk AS CAApplicationArea,
  ihvor AS CAInternalMainTransaction,
  itvor AS CAInternalSubtransaction,
  hvorg AS CAMainTransaction,
  tvorg AS CASubTransaction
FROM tfkivv
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CAInternalMainTransaction AS _CAInternalMainTransaction ON CAApplicationArea = _CAInternalMainTransaction.CAApplicationArea AND CAInternalMainTransaction = _CAInternalMainTransaction.CAInternalMainTransaction  -- association [1..1]
LEFT OUTER JOIN I_CAInternalSubtransaction AS _CAInternalSubtransaction ON CAApplicationArea = _CAInternalSubtransaction.CAApplicationArea AND CAInternalMainTransaction = _CAInternalSubtransaction.CAInternalMainTransaction AND CAInternalSubtransaction = _CAInternalSubtransaction.CAInternalSubtransaction  -- association [1..1]
LEFT OUTER JOIN I_CAMainTransaction AS _CAMainTransaction ON CAApplicationArea = _CAMainTransaction.CAApplicationArea AND CAMainTransaction = _CAMainTransaction.CAMainTransaction  -- association [0..1]
LEFT OUTER JOIN I_CASubTransaction AS _CASubTransaction ON CAApplicationArea = _CASubTransaction.CAApplicationArea AND CAMainTransaction = _CASubTransaction.CAMainTransaction AND CASubTransaction = _CASubTransaction.CASubTransaction  -- association [0..1]
;

Learn More