P_CN_CADEASSETCHGDOC

CDS View

P_CN_CADEASSETCHGDOC is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CN_CADEFixedAssetValueCube view left_outer COMPOSITE Fixed Asset Balance Cube for CADE 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PCNASTCD'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_CN_CADEAssetChgDoc
  with parameters
    P_FiscalYear  : fis_gjahr,
    P_CompanyCode : fis_bukrs
  as select from    P_CN_CADEAssetLastChgDoc(P_FiscalYear : :P_FiscalYear, P_CompanyCode: :P_CompanyCode)      as LastChangeDocItem
    left outer join I_CN_CADEGeneralInformation                                                                                 on  LastChangeDocItem.CompanyCode                        = I_CN_CADEGeneralInformation.CompanyCode
                                                                                                                                and I_CN_CADEGeneralInformation.CN_CADENatlStdRelVersion = 'CN24589'
    left outer join P_CN_CADEAssetAllChgDocWthPrd(P_FiscalYear : :P_FiscalYear, P_CompanyCode: :P_CompanyCode) as ChangeDocItem on  LastChangeDocItem.CompanyCode                 = ChangeDocItem.CompanyCode
                                                                                                                                and LastChangeDocItem.MasterFixedAsset            = ChangeDocItem.MasterFixedAsset
                                                                                                                                and LastChangeDocItem.FixedAsset                  = ChangeDocItem.FixedAsset
                                                                                                                                and LastChangeDocItem.FiscalYearPeriod            = ChangeDocItem.FiscalYearPeriod
                                                                                                                                and LastChangeDocItem.ChangeDocument              = ChangeDocItem.ChangeDocument
                                                                                                                                and LastChangeDocItem.ChangeDocDatabaseTableField = ChangeDocItem.ChangeDocDatabaseTableField

{
  key LastChangeDocItem.CompanyCode,
  key LastChangeDocItem.FiscalYearPeriod,
  key LastChangeDocItem.MasterFixedAsset,
  key LastChangeDocItem.FixedAsset,
  key LastChangeDocItem.ChangeDocDatabaseTableField,
      ChangeDocItem.ChangeDocument,
      ChangeDocItem.DatabaseTable,
      ChangeDocItem.ChangeDocTableKey,
      ChangeDocItem.ChangeDocItemChangeType,

      ChangeDocItem.ChangeDocChangeType,
      ChangeDocItem.ChangeTransactionCode,
      ChangeDocItem.CreationDate,
      ChangeDocItem.CreationTime,

      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue

}
where
     LastChangeDocItem.ChangeDocDatabaseTableField = 'MENGE'
  or LastChangeDocItem.ChangeDocDatabaseTableField = CONCAT(
    'ORD4', I_CN_CADEGeneralInformation.AssetEvaluationGroup
  )

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CN_CADEGENERALINFORMATION",
"P_CN_CADEASSETALLCHGDOCWTHPRD",
"P_CN_CADEASSETLASTCHGDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More