I_FinPostingClearingItem

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 I_FinPostingClearingItem.
-- 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 I_FinPostingClearingItem AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as fdc_dft_key preserving type ) AS PostingClearingDocumentUUID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  cast('0000000000' as posnr_acc preserving type ) AS PostingClearingDocumentTmpItem,
  AccountingDocumentItemType,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  PostingKey,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  TaxCode,
  TaxCountry,
  TaxRateValidityStartDate,
  TransactionTypeDetermination,
  AssignmentReference,
  DocumentItemText,
  ControllingArea,
  CostCenter,
  OrderID,
  SalesDocument,
  ServiceDocumentType,
  ServiceDocument,
  MasterFixedAsset,
  FixedAsset,
  OperationalGLAccount,
  GLAccount,
  Customer,
  Supplier,
  IsBalanceSheetAccount,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  DunningKey,
  DunningBlockingReason,
  DunningArea,
  ValuationArea,
  PaymentDifferenceReason,
  ProfitCenter,
  CompanyCodeCurrencyDetnMethod,
  TaxDeterminationDate,
  FunctionalArea,
  Segment,
  PostingDate,
  AccountingDocumentType,
  NetDueDate,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  AdditionalCurrency1,
  AmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN I_DunningKeyText AS _DunningKeyText ON DunningKey = _DunningKeyText.DunningKey  -- association [0..*]
LEFT OUTER JOIN I_DunningBlockingReasonText AS _DunningBlockingReasonText ON DunningBlockingReason = _DunningBlockingReasonText.DunningBlockingReason  -- association [0..*]
LEFT OUTER JOIN I_DunningAreaText AS _DunningAreaText ON DunningArea = _DunningAreaText.DunningArea AND CompanyCode = _DunningAreaText.CompanyCode  -- association [0..*]
;