R_FinPostingClearingItmDraft

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_FinPostingClearingItmDraft.
-- 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_FinPostingClearingItmDraft AS
SELECT
  PostingClearingDocumentUUID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  PostingClearingDocDraftType,
  AccountingDocumentItem,
  PostingClearingDocumentTmpItem,
  CompanyCodeForEdit,
  FiscalYearForEdit,
  AccountingDocumentForEdit,
  AccountingDocumentItemForEdit,
  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,
  PostingClearingDataEntryStatus,
  PostingClearingDocItemIsMain,
  PostingClearingItmFldStsVal,
  PostingClearingItmMnlEntrVal,
  StatisticalPostingStatus,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM farp_post_itm_d
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDoc ON SalesDocument = _SalesDoc.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
;