R_SettlmtDocType

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_SettlmtDocType.
-- 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_SettlmtDocType AS
SELECT
  cast( lfart as wlf_settlmt_doc_type preserving type ) AS SettlmtDocType,
  bo_type AS SAPObjectType,
  lftyp AS SettlmtDocCat,
  abart AS SettlmtCat,
  process_type AS SettlmtBusProcVar,
  use_case AS SettlmtBusProcCat,
  reporting_display_variant AS SettlmtRptgDisplayVariant,
  lfart_type AS SettlmtDocTypeVariant,
  kappl AS SettlmtMgmtPrcgApplCat,
  taxcode_allowed AS SettlmtTxCodeTxTypeChkCat,
  bw4_hana AS SettlmtDataXtrctnCat,
  cast( cancel_only as wlf_settlmtdoctype_is_for_rvsl preserving type ) AS SettlmtDocTypeIsForReversal,
  cast( docparty as wlf_prod_bsd_doc_prtn_cat preserving type ) AS SetlMgmtProdBsdDocPrtnCat,
  txtgr AS SettlmtHdrTxtDetnProced,
  txtgr_i AS SettlmtItmTxtDetnProced,
  cast ( blart as wlf_journal_entry_type preserving type ) AS JournalEntryType,
  cast ( blart_customer as wlf_journal_entry_type_alt preserving type ) AS AltvJournalEntryType,
  lfart_coll AS SettlmtDocTypeOfCollection,
  distribution AS SettlmtMgmtDocItemDistrCat,
  visibility_group AS ApplElmntBehaviorGrp
FROM tmfk
LEFT OUTER JOIN R_SettlmtDocTypeText AS _Text ON SettlmtDocType = _Text.SettlmtDocType  -- association [0..*]
LEFT OUTER JOIN R_SetlMgmtSAPObjectType AS _SAPObjectType ON SAPObjectType = _SAPObjectType.SAPObjectType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocCat AS _SettlmtDocCat ON SettlmtDocCat = _SettlmtDocCat.SettlmtDocCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtCat AS _SettlmtCat ON SettlmtCat = _SettlmtCat.SettlmtCat  -- association [0..1]
LEFT OUTER JOIN R_SettlmtBusProcVar AS _SettlmtBusProcVar ON SettlmtBusProcVar = _SettlmtBusProcVar.SettlmtBusProcVar  -- association [0..1]
LEFT OUTER JOIN I_SettlmtBusProcCat AS _SettlmtBusProcCat ON SettlmtBusProcCat = _SettlmtBusProcCat.SettlmtBusProcCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtRptgDisplayVariant AS _SettlmtRptgDisplayVariant ON SettlmtRptgDisplayVariant = _SettlmtRptgDisplayVariant.SettlmtRptgDisplayVariant  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocTypeVariant AS _SettlmtDocTypeVariant ON SettlmtDocTypeVariant = _SettlmtDocTypeVariant.SettlmtDocTypeVariant  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtPrcgApplCat AS _SettlmtMgmtPrcgApplCat ON SettlmtMgmtPrcgApplCat = _SettlmtMgmtPrcgApplCat.SettlmtMgmtPrcgApplCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtTxCodeTxTypeChkCat AS _SettlmtTxCodeTxTypeChkCat ON SettlmtTxCodeTxTypeChkCat = _SettlmtTxCodeTxTypeChkCat.SettlmtTxCodeTxTypeChkCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDataXtrctnCat AS _SettlmtDataXtrctnCat ON SettlmtDataXtrctnCat = _SettlmtDataXtrctnCat.SettlmtDataXtrctnCat  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtProdBsdDocPrtnCat AS _SetlMgmtProdBsdDocPrtnCat ON SetlMgmtProdBsdDocPrtnCat = _SetlMgmtProdBsdDocPrtnCat.SetlMgmtProdBsdDocPrtnCat  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtHdrTxtDetnProced AS _SettlmtHdrTxtDetnProced ON SettlmtHdrTxtDetnProced = _SettlmtHdrTxtDetnProced.SettlmtHdrTxtDetnProced  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtItmTxtDetnProced AS _SettlmtItmTxtDetnProced ON SettlmtItmTxtDetnProced = _SettlmtItmTxtDetnProced.SettlmtItmTxtDetnProced  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDocType AS _SettlmtDocTypeOfCollection ON SettlmtDocTypeOfCollection = _SettlmtDocTypeOfCollection.SettlmtDocType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocItemDistrCat AS _SettlmtMgmtDocItemDistrCat ON SettlmtMgmtDocItemDistrCat = _SettlmtMgmtDocItemDistrCat.SettlmtMgmtDocItemDistrCat  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtElmntBehaviorGrp AS _ApplElmntBehaviorGrp ON SAPObjectType = _ApplElmntBehaviorGrp.SAPObjectType AND ApplElmntBehaviorGrp = _ApplElmntBehaviorGrp.ApplElmntBehaviorGrp  -- association [0..1]
;