P_AUDIT_AT_AssetTransaction

DDL: P_AUDIT_AT_ASSETTRANSACTION SQL: PAUDITATASTTRANS Type: view COMPOSITE

P_AUDIT_AT_AssetTransaction is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_AssetValuationForLedger, I_FixedAssetAssgmt, I_FixedAssetForLedger, P_AUDIT_AT_AstTransToKeyFigs) and exposes 68 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger.

4 data source(s) 68 fields

Data Sources (4)

SourceAliasJoin Type
I_AssetValuationForLedger AssetValuationForLedger left_outer
I_FixedAssetAssgmt FixedAssetAssgmt left_outer
I_FixedAssetForLedger FixedAssetForLedger left_outer
P_AUDIT_AT_AstTransToKeyFigs P_AUDIT_AT_AstTransToKeyFigs from

Parameters (8)

NameTypeDefault
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_CompanyCode fis_bukrs
P_Ledger fis_rldnr
P_AssetDepreciationArea fis_afabe
P_FiscalYear fis_gjahr
P_FiscalPeriod fis_period_to
P_FiscalPeriodEndDate fagl_keydate
P_SelectedCurrencyBranch fis_curtp

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PAUDITATASTTRANS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Values CompanyCode
KEY AssetDepreciationArea Values AssetDepreciationArea
KEY MasterFixedAsset Values MasterFixedAsset
KEY FixedAsset Values FixedAsset
KEY Ledger Values Ledger
KEY FiscalYear Values FiscalYear
KEY AssetAccountingKeyFigureSet Values AssetAccountingKeyFigureSet
KEY AccountingDocument Values AccountingDocument
KEY CurrencyRole Values CurrencyRole
AssetAuthorizationContext Values AssetAuthorizationContext
AssetClass Values AssetClass
AssetClassName
AssetClassDescription
MasterFixedAssetDescription
FixedAssetDescription
AssetAdditionalDescription
BaseUnit Values BaseUnit
AssetCapitalizationDate I_FixedAssetForLedger AssetCapitalizationDate
AssetDeactivationDate I_FixedAssetForLedger AssetDeactivationDate
AssetAccountDetermination Values AssetAccountDetermination
ChartOfAccounts Values ChartOfAccounts
AcqnProdnCostGLAccount Values AcqnProdnCostGLAccount
APCGLAccountDescription
PostingDate Values PostingDate
AssetValueDate Values AssetValueDate
DocumentItemText Values DocumentItemText
ReferenceDocument I_FixedAssetAssgmt ReferenceDocument
Quantity Values Quantity
SelectedCurrencyBranch Values SelectedCurrencyBranch
DisplayCurrency Values DisplayCurrency
AmountInDisplayCurrency1 Values AmountInDisplayCurrency1
AmountInDisplayCurrency2 Values AmountInDisplayCurrency2
AmountInDisplayCurrency3 Values AmountInDisplayCurrency3
AmountInDisplayCurrency4 Values AmountInDisplayCurrency4
AmountInDisplayCurrency5 Values AmountInDisplayCurrency5
AmountInDisplayCurrency6 Values AmountInDisplayCurrency6
AmountInDisplayCurrency7 Values AmountInDisplayCurrency7
AmountInDisplayCurrency8 Values AmountInDisplayCurrency8
AmountInDisplayCurrency9 Values AmountInDisplayCurrency9
AmountInDisplayCurrency10 Values AmountInDisplayCurrency10
AmountInDisplayCurrency11 Values AmountInDisplayCurrency11
AmountInDisplayCurrency12 Values AmountInDisplayCurrency12
AmountInDisplayCurrency13 Values AmountInDisplayCurrency13
AmountInDisplayCurrency14 Values AmountInDisplayCurrency14
AmountInDisplayCurrency15 Values AmountInDisplayCurrency15
AmountInDisplayCurrency16 Values AmountInDisplayCurrency16
AmountInDisplayCurrency17 Values AmountInDisplayCurrency17
AmountInDisplayCurrency18 Values AmountInDisplayCurrency18
AmountInDisplayCurrency19 Values AmountInDisplayCurrency19
AmountInDisplayCurrency20 Values AmountInDisplayCurrency20
AmountInDisplayCurrency21 Values AmountInDisplayCurrency21
AmountInDisplayCurrency22 Values AmountInDisplayCurrency22
AmountInDisplayCurrency23 Values AmountInDisplayCurrency23
_CompanyCode Values _CompanyCode
_DepreciationArea Values _DepreciationArea
_MasterFixedAsset Values _MasterFixedAsset
_FixedAsset Values _FixedAsset
_Ledger Values _Ledger
_FiscalYear Values _FiscalYear
_AssetKeyFigureSet Values _AssetKeyFigureSet
_JournalEntry Values _JournalEntry
_CurrencyRole Values _CurrencyRole
_AssetClass Values _AssetClass
_AssetAccountDetermination Values _AssetAccountDetermination
_ChartOfAccounts Values _ChartOfAccounts
_AcqnProdnCostGLAccount Values _AcqnProdnCostGLAccount
_SelectedCurrencyBranch Values _SelectedCurrencyBranch
_UnitOfMeasure Values _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'PAUDITATASTTRANS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_AUDIT_AT_AssetTransaction
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set,
    P_CompanyCode                 : fis_bukrs,
    P_Ledger                      : fis_rldnr,
    P_AssetDepreciationArea       : fis_afabe,
    P_FiscalYear                  : fis_gjahr,
    P_FiscalPeriod                : fis_period_to,
    P_FiscalPeriodEndDate         : fagl_keydate,
    P_SelectedCurrencyBranch      : fis_curtp

  as select from    P_AUDIT_AT_AstTransToKeyFigs( P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet,
                                                  P_FiscalYear:                  :P_FiscalYear,
                                                  P_FiscalPeriod:                :P_FiscalPeriod,
                                                  P_KeyDate:                     :P_FiscalPeriodEndDate ) as Values
    left outer join I_FixedAssetAssgmt                                                                    as FixedAssetAssgmt        on  FixedAssetAssgmt.CompanyCode       =  :P_CompanyCode
                                                                                                                                     and FixedAssetAssgmt.MasterFixedAsset  =  Values.MasterFixedAsset
                                                                                                                                     and FixedAssetAssgmt.FixedAsset        =  Values.FixedAsset
                                                                                                                                     and FixedAssetAssgmt.ValidityStartDate <= :P_FiscalPeriodEndDate
                                                                                                                                     and FixedAssetAssgmt.ValidityEndDate   >= :P_FiscalPeriodEndDate
    left outer join I_FixedAssetForLedger                                                                 as FixedAssetForLedger     on  FixedAssetForLedger.CompanyCode      = :P_CompanyCode
                                                                                                                                     and FixedAssetForLedger.MasterFixedAsset = Values.MasterFixedAsset
                                                                                                                                     and FixedAssetForLedger.FixedAsset       = Values.FixedAsset
                                                                                                                                     and FixedAssetForLedger.Ledger           = :P_Ledger
    left outer join I_AssetValuationForLedger                                                             as AssetValuationForLedger on  AssetValuationForLedger.CompanyCode               =  :P_CompanyCode
                                                                                                                                     and AssetValuationForLedger.MasterFixedAsset          =  Values.MasterFixedAsset
                                                                                                                                     and AssetValuationForLedger.Ledger                    =  :P_Ledger
                                                                                                                                     and AssetValuationForLedger.AssetRealDepreciationArea =  :P_AssetDepreciationArea
                                                                                                                                     and AssetValuationForLedger.ValidityStartDate         <= :P_FiscalPeriodEndDate
                                                                                                                                     and AssetValuationForLedger.ValidityEndDate           >= :P_FiscalPeriodEndDate
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key Values.CompanyCode,
      @ObjectModel.foreignKey.association: '_DepreciationArea'
  key Values.AssetDepreciationArea,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key Values.MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
  key Values.FixedAsset,
      @ObjectModel.foreignKey.association: '_Ledger'
  key Values.Ledger,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key Values.FiscalYear,
  key Values.AssetAccountingKeyFigureSet,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key Values.AccountingDocument,
      @ObjectModel.foreignKey.association: '_CurrencyRole'
  key Values.CurrencyRole,


      @Consumption.hidden: true
      Values.AssetAuthorizationContext, //Needed for DCL

      @ObjectModel.foreignKey.association: '_AssetClass'
      Values.AssetClass,
      @Semantics.text
      Values._AssetClass._Text[1: Language = $session.system_language].AssetClassName        as AssetClassName,
      @Semantics.text
      Values._AssetClass._Text[1: Language = $session.system_language].AssetClassDescription as AssetClassDescription,

      Values._MasterFixedAsset.MasterFixedAssetDescription                                   as MasterFixedAssetDescription,

      Values._FixedAsset.FixedAssetDescription                                               as FixedAssetDescription,
      Values._FixedAsset.AssetAdditionalDescription                                          as AssetAdditionalDescription,
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      Values.BaseUnit                                                                        as BaseUnit,

      FixedAssetForLedger.AssetCapitalizationDate                                            as AssetCapitalizationDate,
      FixedAssetForLedger.AssetDeactivationDate                                              as AssetDeactivationDate,

      @ObjectModel.foreignKey.association: '_AssetAccountDetermination'
      Values.AssetAccountDetermination,
      // for _AcqnProdnCostGLAccount

      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      Values.ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_AcqnProdnCostGLAccount'
      Values.AcqnProdnCostGLAccount,
      @Semantics.text
      _AcqnProdnCostGLAccount._Text[1: Language = $session.system_language].GLAccountName    as APCGLAccountDescription,

      Values.PostingDate,
      Values.AssetValueDate,
      Values.DocumentItemText,
      FixedAssetAssgmt.ReferenceDocument,
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Values.Quantity,

      @ObjectModel.foreignKey.association: '_SelectedCurrencyBranch'
      @Environment.sql.passValue : true
      Values.SelectedCurrencyBranch,
      @Semantics.currencyCode:true
      Values.DisplayCurrency,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency1,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency2,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency3,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency4,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency5,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency6,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency7,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency8,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency9,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency10,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency11,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency12,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency13,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency14,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency15,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency16,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency17,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency18,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency19,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency20,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency21,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency22,
      @Semantics: { amount : {currencyCode: 'DisplayCurrency'} }
      Values.AmountInDisplayCurrency23,

      /*Associations */
      Values._CompanyCode,
      Values._DepreciationArea,
      Values._MasterFixedAsset,
      Values._FixedAsset,
      Values._Ledger,
      Values._FiscalYear,
      Values._AssetKeyFigureSet,
      Values._JournalEntry,
      Values._CurrencyRole,
      Values._AssetClass,
      Values._AssetAccountDetermination,
      Values._ChartOfAccounts,
      Values._AcqnProdnCostGLAccount,
      Values._SelectedCurrencyBranch,
      Values._UnitOfMeasure
}
where
      Values.CompanyCode            = :P_CompanyCode
  and Values.Ledger                 = :P_Ledger
  and Values.AssetDepreciationArea  = :P_AssetDepreciationArea
  and Values.SelectedCurrencyBranch = :P_SelectedCurrencyBranch
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETCLASS",
"I_ASSETCLASSTEXT",
"I_ASSETVALUATIONFORLEDGER",
"I_FIXEDASSET",
"I_FIXEDASSETASSGMT",
"I_FIXEDASSETFORLEDGER",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTTEXT",
"I_MASTERFIXEDASSET",
"P_AUDIT_AT_ASTTRANSTOKEYFIGS"
],
"ASSOCIATED":
[
"I_ASSETACCTDETERMINATION",
"I_ASSETCLASS",
"I_ASSETKEYFIGURESET",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_CURRENCYROLE",
"I_DEPRECIATIONAREAFORLEDGER",
"I_FISCALYEARFORCOMPANYCODE",
"I_FIXEDASSET",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_JOURNALENTRY",
"I_LEDGER",
"I_MASTERFIXEDASSET",
"I_SELECTEDCURRENCYBRANCH",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_AUDIT_AT_ASTTRANSTOKEYFIGS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More