R_FixedAssetSimlnPostingTP

DDL: R_FIXEDASSETSIMLNPOSTINGTP Type: view_entity TRANSACTIONAL
106 Fields 1 Data Sources

Line Item Amount for Fixed Asset Posting

R_FixedAssetSimlnPostingTP is a Transactional CDS View that provides data about "Line Item Amount for Fixed Asset Posting" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetSimulationPosting) and exposes 106 fields with key fields FixedAssetPostingUUID, ReferenceDocumentItem, CompanyCode, Ledger, AssetDepreciationArea.

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetSimulationPosting I_FixedAssetSimulationPosting from

Annotations (8)

NameValueLevelField
EndUserText.label Line Item Amount for Fixed Asset Posting view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (106)

KeyFieldSource TableSource FieldDescription
KEY FixedAssetPostingUUID FixedAssetPostingUUID Posting UUID
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
KEY CompanyCode CompanyCode Receiver Company Code
KEY Ledger Ledger Ledger
KEY AssetDepreciationArea AssetDepreciationArea Deprec. Area
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
KEY TransactionSubitem TransactionSubitem Sub Transaction
KEY AccountingDocumentItemRef AccountingDocumentItemRef Position
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
LogicalSystem LogicalSystem Logical System
GLBusinessTransactionType GLBusinessTransactionType Transact. Type
GLAccount GLAccount General Ledger
PostingDate PostingDate Posting Date for GR
AssetValueDate AssetValueDate Reference date
DocumentDate DocumentDate Journal Entry Date
FiscalPeriod FiscalPeriod Tax period
DebitCreditCode DebitCreditCode Single-Character Flag
FinancialAccountType FinancialAccountType Fin. Account Type
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
DepreciationFiscalPeriod DepreciationFiscalPeriod Deprec. Period
AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
AssetClass AssetClass Asset Class
AssetAccountDetermination AssetAccountDetermination Account Determ.
PartnerMasterFixedAsset PartnerMasterFixedAsset Partner Asset
PartnerFixedAsset PartnerFixedAsset Partner Sub-No.
BusinessTransactionType BusinessTransactionType Bus.transaction
ReferenceDocumentItemGroup ReferenceDocumentItemGroup Reference Document Item Group
AccountingDocumentItem AccountingDocumentItem Posting View Item
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
IsSettlement IsSettlement Is Settling
IsSettled IsSettled Is Settled
PredecessorReferenceDocType PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument PredecessorReferenceDocument Predecessor Reference Document
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
ReversalTransactionSubitem ReversalTransactionSubitem Reversal Sub Trans
DocumentReferenceID DocumentReferenceID Reference
DocumentItemText DocumentItemText Text
TradingPartner TradingPartner Trading Partner
AssignmentReference AssignmentReference Assignment Reference
OffsettingAccount OffsettingAccount Offsetting Acct
Customer Customer Sold-to Party
Supplier Supplier Supplier
FunctionalArea FunctionalArea Sendr Fctl Area
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
CostCtrActivityType CostCtrActivityType Activity Type
OrderID OrderID Order ID
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
PartnerProfitCenter PartnerProfitCenter Profit Center
Fund Fund Sender Fund
GrantID GrantID Sender Grant
AssetGLPostingMethod AssetGLPostingMethod Ind.: G/L Acct.
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
FunctionalCurrency FunctionalCurrency Functional Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
_BalanceTransactionCurrency _BalanceTransactionCurrency
_TransactionCurrency _TransactionCurrency
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FunctionalCurrency _FunctionalCurrency
_FreeDefinedCurrency1 _FreeDefinedCurrency1
_FreeDefinedCurrency2 _FreeDefinedCurrency2
_FreeDefinedCurrency3 _FreeDefinedCurrency3
_FreeDefinedCurrency4 _FreeDefinedCurrency4
_FreeDefinedCurrency5 _FreeDefinedCurrency5
_FreeDefinedCurrency6 _FreeDefinedCurrency6
_FreeDefinedCurrency7 _FreeDefinedCurrency7
_FreeDefinedCurrency8 _FreeDefinedCurrency8
_Ledger _Ledger
_DepreciationArea _DepreciationArea
_SubLedgerAccLineItemType _SubLedgerAccLineItemType
_LedgerText _LedgerText
_DepreciationAreaText _DepreciationAreaText
_SubLedgerAccLineItemTypeText _SubLedgerAccLineItemTypeText
_FixedAssetPosting _FixedAssetPosting

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 R_FixedAssetSimlnPostingTP.
-- 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.

CREATE VIEW R_FixedAssetSimlnPostingTP AS
SELECT
  FixedAssetPostingUUID,
  ReferenceDocumentItem,
  CompanyCode,
  Ledger,
  AssetDepreciationArea,
  FiscalYear,
  SubLedgerAcctLineItemType,
  TransactionSubitem,
  AccountingDocumentItemRef,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  LogicalSystem,
  GLBusinessTransactionType,
  GLAccount,
  PostingDate,
  AssetValueDate,
  DocumentDate,
  FiscalPeriod,
  DebitCreditCode,
  FinancialAccountType,
  Quantity,
  BaseUnit,
  DepreciationFiscalPeriod,
  AssetAcctTransClassfctn,
  AssetClass,
  AssetAccountDetermination,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  BusinessTransactionType,
  ReferenceDocumentItemGroup,
  AccountingDocumentItem,
  IsReversal,
  IsReversed,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  DocumentReferenceID,
  DocumentItemText,
  TradingPartner,
  AssignmentReference,
  OffsettingAccount,
  Customer,
  Supplier,
  FunctionalArea,
  ControllingArea,
  CostCenter,
  CostCtrActivityType,
  OrderID,
  ProfitCenter,
  Segment,
  PartnerProfitCenter,
  Fund,
  GrantID,
  AssetGLPostingMethod,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8
FROM I_FixedAssetSimulationPosting
;

Learn More