P_AccountingDocumentType

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 P_AccountingDocumentType.
-- 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.
-- SQL view name: PFIACCDOCTYPE

CREATE VIEW P_AccountingDocumentType AS
SELECT
  cast ( blart as farp_blart preserving type ) AS AccountingDocumentType,
  cast ( _Text.ltext as farp_ltext_003t preserving type ) AS AccountingDocumentTypeName,
  numkr AS AccountingDocumentNumberRange,
  brgru AS AuthorizationGroup,
  kurst AS ExchangeRateType,
  koars AS AllowedFinancialAccountTypes
FROM t003
LEFT OUTER JOIN t003t AS _Text ON AccountingDocumentType = _Text.blart AND _Text.spras = $session.system_language  -- association [0..1]
;