C_CustomerGuaranteeItemTP

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_CustomerGuaranteeItemTP.
-- 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_CustomerGuaranteeItemTP AS
SELECT
  PostingClearingDocumentUUID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  PostingClearingDocDraftType,
  AccountingDocumentItem,
  PostingClearingDocumentTmpItem,
  CompanyCodeForEdit,
  ClearingJournalEntry,
  FinancialAccountType,
  SpecialGLCode,
  cast( AssignmentReference as fis_post_clear_assignment preserving type ) AS AssignmentReference,
  DocumentItemText,
  ControllingArea,
  CostCenter,
  OrderID,
  SalesDocument,
  ServiceDocumentType,
  ServiceDocument,
  MasterFixedAsset,
  FixedAsset,
  GLAccount,
  Customer,
  Supplier,
  cast( DueCalculationBaseDate as fis_post_clear_due_on preserving type ) AS DueCalculationBaseDate,
  DunningKey,
  cast( DunningBlockingReason as fis_post_clear_dunning_block preserving type ) AS DunningBlockingReason,
  DunningArea,
  ValuationArea,
  ProfitCenter,
  FunctionalArea,
  Segment,
  PostingDate,
  AccountingDocumentType,
  NetDueDate,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  PostingClearingItmFldStsVal,
  virtual UICT_DocumentItemText : abap_boolean AS virtualUICT_DocumentItemTextabap_boolean,
  virtual UICT_DunningKey : abap_boolean AS virtualUICT_DunningKeyabap_boolean,
  virtual UICT_DunningArea : abap_boolean AS virtualUICT_DunningAreaabap_boolean,
  _Customer.CustomerName AS CustomerName,
  _DunningKeyText.MaximumDunningLevelDescription : localized AS MaximumDunningLevelDescriptionlocalized,
  _DunningBlockingReasonText.DunningBlockingReasonDesc : localized AS DunningBlockingReasonDesclocalized,
  _DunningAreaText.DunningAreaName : localized AS DunningAreaNamelocalized
FROM R_FinPostingClearingItemTP
;