C_CN_CADEAssetTransTypeText

DDL: C_CN_CADEASSETTRANSTYPETEXT SQL: CCADEASTTRANSTP Type: view CONSUMPTION Package: GLO_FIN_CADE_CN
3 Fields 2 Data Sources

Asset Transaction Type

C_CN_CADEAssetTransTypeText is a Consumption CDS View that provides data about "Asset Transaction Type" in SAP S/4HANA. It reads from 2 data sources (I_AssetTransactionTypeText, I_CN_CADEStatutoryReportTypeT) and exposes 3 fields with key fields CN_CADEAssetTransactionType, CN_CADEAssetTransactionType. Part of development package GLO_FIN_CADE_CN.

Data Sources (2)

SourceAliasJoin Type
I_AssetTransactionTypeText I_AssetTransactionTypeText from
I_CN_CADEStatutoryReportTypeT I_CN_CADEStatutoryReportTypeT union_all

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CCADEASTTRANSTP view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Asset Transaction Type view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CN_CADEAssetTransactionType Lower Value
KEY CN_CADEAssetTransactionType Lower Value
AssetTransactionTypeName DomainText Short Description

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 C_CN_CADEAssetTransTypeText.
-- 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.
-- SQL view name: CCADEASTTRANSTP
-- Parameters: P_Language : sylangu

CREATE VIEW C_CN_CADEAssetTransTypeText AS
SELECT
  cast(AssetTransactionType as cade_aa_transactiontype ) AS CN_CADEAssetTransactionType,
  DomainText AS AssetTransactionTypeName
FROM I_AssetTransactionTypeText
-- UNION ALL with additional select branch(es): I_CN_CADEStatutoryReportTypeT
;

Learn More