C_FixedAssetSimlnPostingTP

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 C_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 C_FixedAssetSimlnPostingTP AS
SELECT
  faad_tr_simdoc.fixedassetpostinguuid AS FixedAssetPostingUUID,
  faad_tr_simdoc.referencedocumentitem AS ReferenceDocumentItem,
  faad_tr_post.companycode AS CompanyCode,
  faad_tr_simdoc.ledger AS Ledger,
  faad_tr_simdoc.assetdepreciationarea AS AssetDepreciationArea,
  faad_tr_simdoc.fiscalyear AS FiscalYear,
  faad_tr_simdoc.subledgeracctlineitemtype AS SubLedgerAcctLineItemType,
  faad_tr_simdoc.transactionsubitem AS TransactionSubitem,
  faad_tr_simdoc.accountingdocumentitemref AS AccountingDocumentItemRef,
  _LedgerText.LedgerName AS LedgerName,
  _DepreciationAreaText.AssetDepreciationAreaName AS AssetDepreciationAreaName,
  _SubLedgerAccLineItemTypeText.SubLedgerAcctLineItemTypeName AS SubLedgerAcctLineItemTypeName,
  faad_tr_simdoc.referencedocumenttype AS ReferenceDocumentType,
  faad_tr_simdoc.referencedocument AS ReferenceDocument,
  faad_tr_simdoc.referencedocumentcontext AS ReferenceDocumentContext,
  faad_tr_simdoc.logicalsystem AS LogicalSystem,
  faad_tr_simdoc.glbusinesstransactiontype AS GLBusinessTransactionType,
  faad_tr_simdoc.glaccount AS GLAccount,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  faad_tr_simdoc.postingdate AS PostingDate,
  faad_tr_simdoc.assetvaluedate AS AssetValueDate,
  faad_tr_simdoc.documentdate AS DocumentDate,
  faad_tr_simdoc.fiscalperiod AS FiscalPeriod,
  faad_tr_simdoc.debitcreditcode AS DebitCreditCode,
  faad_tr_simdoc.financialaccounttype AS FinancialAccountType,
  faad_tr_simdoc.quantity AS Quantity,
  faad_tr_simdoc.baseunit AS BaseUnit,
  faad_tr_simdoc.depreciationfiscalperiod AS DepreciationFiscalPeriod,
  faad_tr_simdoc.assetaccttransclassfctn AS AssetAcctTransClassfctn,
  faad_tr_simdoc.assetclass AS AssetClass,
  faad_tr_simdoc.assetaccountdetermination AS AssetAccountDetermination,
  faad_tr_simdoc.partnermasterfixedasset AS PartnerMasterFixedAsset,
  faad_tr_simdoc.partnerfixedasset AS PartnerFixedAsset,
  faad_tr_simdoc.referencedocumentitemgroup AS ReferenceDocumentItemGroup,
  faad_tr_simdoc.accountingdocumentitem AS AccountingDocumentItem,
  faad_tr_simdoc.isreversal AS IsReversal,
  faad_tr_simdoc.isreversed AS IsReversed,
  faad_tr_simdoc.issettlement AS IsSettlement,
  faad_tr_simdoc.issettled AS IsSettled,
  faad_tr_simdoc.predecessorreferencedoctype AS PredecessorReferenceDocType,
  faad_tr_simdoc.predecessorreferencedoccntxt AS PredecessorReferenceDocCntxt,
  faad_tr_simdoc.predecessorreferencedocument AS PredecessorReferenceDocument,
  faad_tr_simdoc.reversalreferencedocumentcntxt AS ReversalReferenceDocumentCntxt,
  faad_tr_simdoc.reversalreferencedocument AS ReversalReferenceDocument,
  faad_tr_simdoc.reversaltransactionsubitem AS ReversalTransactionSubitem,
  faad_tr_simdoc.documentreferenceid AS DocumentReferenceID,
  faad_tr_simdoc.documentitemtext AS DocumentItemText,
  faad_tr_simdoc.tradingpartner AS TradingPartner,
  faad_tr_simdoc.assignmentreference AS AssignmentReference,
  faad_tr_simdoc.offsettingaccount AS OffsettingAccount,
  faad_tr_simdoc.customer AS Customer,
  faad_tr_simdoc.supplier AS Supplier,
  faad_tr_simdoc.functionalarea AS FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  faad_tr_simdoc.controllingarea AS ControllingArea,
  faad_tr_simdoc.costcenter AS CostCenter,
  faad_tr_simdoc.costctractivitytype AS CostCtrActivityType,
  faad_tr_simdoc.orderid AS OrderID,
  faad_tr_simdoc.profitcenter AS ProfitCenter,
  faad_tr_simdoc.segment AS Segment,
  faad_tr_simdoc.partnerprofitcenter AS PartnerProfitCenter,
  t001.fikrs AS FinancialManagementArea,
  faad_tr_simdoc.fund AS Fund,
  _FundText.FundName AS FundName,
  faad_tr_simdoc.grantid AS GrantID,
  _GrantText.GrantName AS GrantName,
  faad_tr_simdoc.assetglpostingmethod AS AssetGLPostingMethod,
  faad_tr_simdoc.balancetransactioncurrency AS BalanceTransactionCurrency,
  faad_tr_simdoc.amountinbalancetransaccrcy AS AmountInBalanceTransacCrcy,
  faad_tr_simdoc.transactioncurrency AS TransactionCurrency,
  faad_tr_simdoc.amountintransactioncurrency AS AmountInTransactionCurrency,
  faad_tr_simdoc.companycodecurrency AS CompanyCodeCurrency,
  faad_tr_simdoc.amountincompanycodecurrency AS AmountInCompanyCodeCurrency,
  faad_tr_simdoc.globalcurrency AS GlobalCurrency,
  faad_tr_simdoc.amountinglobalcurrency AS AmountInGlobalCurrency,
  faad_tr_simdoc.functionalcurrency AS FunctionalCurrency,
  faad_tr_simdoc.amountinfunctionalcurrency AS AmountInFunctionalCurrency,
  faad_tr_simdoc.freedefinedcurrency1 AS FreeDefinedCurrency1,
  faad_tr_simdoc.amountinfreedefinedcurrency1 AS AmountInFreeDefinedCurrency1,
  faad_tr_simdoc.freedefinedcurrency2 AS FreeDefinedCurrency2,
  faad_tr_simdoc.amountinfreedefinedcurrency2 AS AmountInFreeDefinedCurrency2,
  faad_tr_simdoc.freedefinedcurrency3 AS FreeDefinedCurrency3,
  faad_tr_simdoc.amountinfreedefinedcurrency3 AS AmountInFreeDefinedCurrency3,
  faad_tr_simdoc.freedefinedcurrency4 AS FreeDefinedCurrency4,
  faad_tr_simdoc.amountinfreedefinedcurrency4 AS AmountInFreeDefinedCurrency4,
  faad_tr_simdoc.freedefinedcurrency5 AS FreeDefinedCurrency5,
  faad_tr_simdoc.amountinfreedefinedcurrency5 AS AmountInFreeDefinedCurrency5,
  faad_tr_simdoc.freedefinedcurrency6 AS FreeDefinedCurrency6,
  faad_tr_simdoc.amountinfreedefinedcurrency6 AS AmountInFreeDefinedCurrency6,
  faad_tr_simdoc.freedefinedcurrency7 AS FreeDefinedCurrency7,
  faad_tr_simdoc.amountinfreedefinedcurrency7 AS AmountInFreeDefinedCurrency7,
  faad_tr_simdoc.freedefinedcurrency8 AS FreeDefinedCurrency8,
  faad_tr_simdoc.amountinfreedefinedcurrency8 AS AmountInFreeDefinedCurrency8,
  faad_tr_post.businesstransactiontype AS BusinessTransactionType,
  faad_tr_post.businesstransactioncategory AS BusinessTransactionCategory
FROM faad_tr_simdoc
INNER JOIN faad_tr_post ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_FixedAssetPostingTP AS _FixedAssetPosting ON FixedAssetPostingUUID = _FixedAssetPosting.FixedAssetPostingUUID AND ReferenceDocumentItem = _FixedAssetPosting.ReferenceDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DeprAreaForLedgerText AS _DepreciationAreaText ON CompanyCode = _DepreciationAreaText.CompanyCode AND Ledger = _DepreciationAreaText.Ledger AND AssetDepreciationArea = _DepreciationAreaText.AssetDepreciationArea AND _DepreciationAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemTypeT AS _SubLedgerAccLineItemTypeText ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemTypeText.SubLedgerAcctLineItemType AND _SubLedgerAccLineItemTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND FinancialManagementArea = _FundText.FinancialManagementArea AND _FundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
;