P_CN_CADEAssetChangeLog

DDL: P_CN_CADEASSETCHANGELOG SQL: PCADEASTCHGLOG Type: view CONSUMPTION Package: GLO_FIN_CADE_CN
46 Fields 8 Data Sources

Asset Change Log for CADE

P_CN_CADEAssetChangeLog is a Consumption CDS View that provides data about "Asset Change Log for CADE" in SAP S/4HANA. It reads from 8 data sources and exposes 46 fields with key fields CompanyCode, Ledger, MasterFixedAsset, FixedAsset, ChangeDocObject. Part of development package GLO_FIN_CADE_CN.

Data Sources (8)

SourceAliasJoin Type
I_ChangeDocumentItem ChangeLog inner
I_ChangeDocumentItem ChangeLog inner
I_CN_CADEGeneralInformation Configuration inner
I_CN_CADEGeneralInformation Configuration inner
I_FixedAssetForLedger FixedAsset from
I_FixedAssetForLedger FixedAsset union_all
I_CN_CADEStatutoryReportTypeT TransactionType inner
P_CN_CADEAstTransType_New TransactionType inner

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PCADEASTCHGLOG view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAssetForLedger CompanyCode Receiver Company Code
KEY Ledger I_FixedAssetForLedger Ledger Ledger
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY ChangeDocObject ChangeDocObject Object Value
KEY ChangeDocObjectClass ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument ChangeDocument Document Number
KEY DatabaseTable DatabaseTable Table Name
KEY ChangeDocTableKey ChangeDocTableKey Table Keys
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType ChangeDocItemChangeType Change Indicator
FixedAssetExternalID
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate Deact.Date
AssetSerialNumberendasAssetSerialNumber
Inventory
FixedAssetDescription
AssetClass
AssetTransactionType P_CN_CADEAstTransType_New DomainValue Lower Value
AssetTransactionTypeName P_CN_CADEAstTransType_New DomainText Short Description
ChangeTransactionCode _ChangeDocument ChangeTransactionCode Change Tcode
CreationDate _ChangeDocument CreationDate Time Stamp
ChangeDocNewFieldValue ChangeDocNewFieldValue New Value
CompanyCode Receiver Company Code
CompanyCode Receiver Company Code
KEY Ledger I_FixedAssetForLedger Ledger Ledger
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY ChangeDocObject ChangeDocObject Object Value
KEY ChangeDocObjectClass ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument ChangeDocument Document Number
KEY DatabaseTable DatabaseTable Table Name
KEY ChangeDocTableKey ChangeDocTableKey Table Keys
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType ChangeDocItemChangeType Change Indicator
FixedAssetExternalID
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate Deact.Date
AssetSerialNumberendasAssetSerialNumber
Inventory
FixedAssetDescription
AssetClass
AssetTransactionType P_CN_CADEAstTransType_New DomainValue Lower Value
AssetTransactionTypeName P_CN_CADEAstTransType_New DomainText Short Description
ChangeTransactionCode _ChangeDocument ChangeTransactionCode Change Tcode
CreationDate _ChangeDocument CreationDate Time Stamp
ChangeDocNewFieldValue ChangeDocNewFieldValue New Value
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue Old Value

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 P_CN_CADEAssetChangeLog.
-- 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: PCADEASTCHGLOG
-- Parameters: P_Language : sylangu

CREATE VIEW P_CN_CADEAssetChangeLog AS
SELECT
  FixedAsset.CompanyCode AS CompanyCode,
  FixedAsset.Ledger AS Ledger,
  MasterFixedAsset,
  FixedAsset,
  ChangeDocObject,
  ChangeDocObjectClass,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  FixedAsset._FixedAsset.FixedAssetExternalID AS FixedAssetExternalID,
  FixedAsset.AssetDeactivationDate AS AssetDeactivationDate,
  case when FixedAsset._FixedAsset.AssetSerialNumber = '' then FixedAsset._FixedAsset.Inventory else FixedAsset._FixedAsset.AssetSerialNumber end as AssetSerialNumber AS AssetSerialNumberendasAssetSerialNumber,
  FixedAsset._FixedAsset.Inventory AS Inventory,
  FixedAsset._FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  FixedAsset._FixedAsset.AssetClass AS AssetClass,
  TransactionType.DomainValue AS AssetTransactionType,
  TransactionType.DomainText AS AssetTransactionTypeName,
  _ChangeDocument.ChangeTransactionCode AS ChangeTransactionCode,
  _ChangeDocument.CreationDate AS CreationDate,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue
FROM I_FixedAssetForLedger AS FixedAsset
INNER JOIN I_CN_CADEGeneralInformation AS Configuration ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocumentItem AS ChangeLog ON /* join condition not captured in parsed metadata */
INNER JOIN I_CN_CADEStatutoryReportTypeT AS TransactionType ON /* join condition not captured in parsed metadata */
INNER JOIN P_CN_CADEAstTransType_New AS TransactionType ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_FixedAssetForLedger
;

Learn More