R_FIXEDASSETPOSTINGTP

CDS View

Fixed Asset Posting

R_FIXEDASSETPOSTINGTP is a CDS View in S/4HANA. Fixed Asset Posting. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_FixedAssetAcquisition view_entity projection CONSUMPTION Fixed Asset Acquisition Posting
C_FixedAssetPostingTP view_entity projection CONSUMPTION Fixed Asset Posting 
@EndUserText.label: 'Fixed Asset Posting'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #TRANSACTIONAL
    },
    lifecycle.enqueue.expiryBehavior: #RELATIVE_TO_ENQUEUE_START,
    lifecycle.enqueue.expiryInterval: 'PT15M'
 }
@ObjectModel.sapObjectNodeType.name:     'FixedAsset'
define root view entity R_FixedAssetPostingTP
  as select from I_FixedAssetPosting as FixedAssetPosting

  composition [0..*] of R_FixedAssetPostingItemAmtTP   as _FixedAssetPostingItemAmount
  composition [1..*] of R_FixedAssetSimlnPostingTP     as _FixedAssetPostingSimulation
  composition [0..*] of R_FixedAssetPostingLedgerTP    as _FixedAssetPostingLedger
  composition [0..*] of R_FixedAssetPostingValuationTP as _FixedAssetPostingValuation


{

  key  FixedAssetPostingUUID,
  key  ReferenceDocumentItem,

       AssetAcctTransClassfctn, //FAAI_MOVCAT


       ReferenceDocumentType,
       LogicalSystem,
       ReferenceDocumentContext,
       ReferenceDocument,

       CompanyCode,
       MasterFixedAsset,
       FixedAsset,
       AssetClass,

       DocumentDate,
       PostingDate,
       AssetValueDate,
       AssetOriginalValueDate,

       BusinessTransactionType,
       BusinessTransactionCategory,

       DocumentReferenceID,
       AccountingDocumentHeaderText,

       // Translation Date

       ExchangeRateDate,
       //       ExchangeRate,

       //       cast(abs(ExchangeRate) as fis_absolute_exchangerate preserving type)                                                      as AbsoluteExchangeRate,

       //       @Semantics.booleanIndicator:true

       //       cast(case when ExchangeRate < 0 then 'X' else '' end as fis_indirect_quotation preserving type)                           as ExchRateIsIndirectQuotation,

       //       cast(case when ExchangeRate < 0 then division(1,abs(ExchangeRate),5) else ExchangeRate end as fis_effective_exchangerate) as EffectiveExchangeRate,


       //Acquisition


       @Semantics.amount.currencyCode : 'TransactionCurrency'
       AcqnAmtInTransactionCurrency,
       //       Currency,

       TransactionCurrency,

       //       @Semantics.quantity.unitOfMeasure : 'BaseUnit'

       //       Quantity,

       @Semantics.quantity.unitOfMeasure : 'BaseUnit'
       QuantityInBaseUnit,
       BaseUnit,

       DebitCreditCode,
       FixedAssetYearOfAcqnCode,
       
       FixedAssetRetirementType,
       FxdAstRetirementRevenueType,
    
       @Semantics.amount.currencyCode : 'FxdAstRetirementTransCrcy'
       AstRtrmtAmtInTransCrcy,
       FxdAstRetirementTransCrcy,
       FxdAstRetirementCurrencyRole,
       
       
       @Semantics.quantity.unitOfMeasure : 'FixedAssetRetirementBaseUnit'
       FxdAstRtrmtQuantityInBaseUnit,
       FixedAssetRetirementBaseUnit, 
       
       @Semantics.amount.currencyCode : 'FxdAstRtrmtRevnTransCrcy'
       AstRevenueAmountInTransCrcy,
       FxdAstRtrmtRevnTransCrcy,
       FxdAstRtrmtRevnCurrencyRole,
      
       FxdAstRetirementRatioInPercent,
       
       FxdAstRevnDetnDeprArea,
//       DepreciationAreaCurrencyRole,

//       DepreciationAreaCurrency,

       // Additional Information


       AccountingDocumentType,
       FinancialClosingStep,
       TradingPartner,
       AssignmentReference,
       DocumentItemText,
       OffsettingAccount,
       //PartnerBusinessArea,


       //Coding Block

       //       CostCtrActivityType,

       //

       //       BusinessArea,

       //

       //       CostCenter,

       //

       //       FunctionalArea,

       //

       //       Fund,

       //

       //       GrantID,

       //

       //       InternalOrder,

       //

       //       ProfitCenter,

       //

       //       Segment,

       //

       //       WBSElementInternalID,


       cast('' as faa_tr_post_changed) as IsChanged,

       //virtual fields for the draft

       cast( '' as xfixd_curv )        as FixedExchangeRateIsUsed,
   
       CreatedByUser,
       CreationDateTime,

       LastChangeDateTime,



       _FixedAssetPostingItemAmount,
       _FixedAssetPostingSimulation,
       _FixedAssetPostingLedger,
       _FixedAssetPostingValuation,

       //foreign key association

       _CompanyCode,
       _MasterFixedAsset,
       _FixedAsset,
       _Currency,
       _UnitOfMeasure,
       _RetirementUnitOfMeasure,
       _ReferenceDocumentType,
       _LogicalSystem,
       _FixedAssetBusTransacCategory,
       _AccountingDocumentType,
       _BusinessTransactionType,
       _PartnerCompany

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIXEDASSETPOSTING"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_BUSINESSTRANSACTIONTYPE",
"I_COMPANYCODE",
"I_CURRENCY",
"I_FIXEDASSET",
"I_FIXEDASSETBUSTRANSACCATEGORY",
"I_LOGICALSYSTEM",
"I_MASTERFIXEDASSET",
"I_PARTNERCOMPANY",
"I_REFERENCEDOCUMENTTYPE",
"I_UNITOFMEASURE",
"R_FIXEDASSETPOSTINGITEMAMTTP",
"R_FIXEDASSETPOSTINGLEDGERTP",
"R_FIXEDASSETPOSTINGVALUATIONTP",
"R_FIXEDASSETSIMLNPOSTINGTP"
],
"BASE":
[
"I_FIXEDASSETPOSTING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More