I_CADocPostingControl

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_CADocPostingControl.
-- 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_CADocPostingControl AS
SELECT
  hvorg AS CAMainTransaction,
  tvorg AS CASubTransaction,
  bukrs AS CompanyCode,
  spart AS Division,
  shkzg AS CADebitCreditCode,
  xmanb AS CADocumentIsPostedManually,
  verkz AS CAItemIsOnlyForSettlement,
  ikey AS CAInterestCode,
  mahnv AS CADunningProcedure,
  strkz AS CAOtherTaxCode,
  spzah AS CAPaymentLockReason,
  mansp AS CADunningLockReason,
  sperz AS CAInterestLockReason,
  cast( clrlo as clrlo_kk preserving type ) AS CAClearingLockReason
FROM tfkc_hvtv
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_CAInterestCode AS _InterestCode ON CAInterestCode = _InterestCode.CAInterestCode  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _DunningProcedure ON CADunningProcedure = _DunningProcedure.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CAStatisticalItemCode AS _StatisticalItemCode ON CAStatisticalItemCode = _StatisticalItemCode.CAStatisticalItemCode  -- association [0..1]
LEFT OUTER JOIN I_CADocPostingControlText AS _Text ON CAMainTransaction = _Text.CAMainTransaction AND CASubTransaction = _Text.CASubTransaction AND CompanyCode = _Text.CompanyCode AND Division = _Text.Division  -- association [0..*]
;