FAC_DART_Z3_DOCUMENTTYPE

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 FAC_DART_Z3_DOCUMENTTYPE.
-- 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: FAC_DZDOCTYPE
-- Parameters: P_Language : sylangu

CREATE VIEW FAC_DART_Z3_DOCUMENTTYPE AS
SELECT
  cast ( blart as farp_blart preserving type ) AS AccountingDocumentType,
  _Text[1: Language = $parameters.P_Language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  numkr AS AccountingDocumentNumberRange,
  brgru AS AuthorizationGroup,
  koars AS AllowedFinancialAccountTypes,
  stbla AS DocumentType,
  xnetb AS IndDocumentPostedNet,
  xrvup AS IndPostingFromBillingDocument,
  xsybl AS IndCanOnlyBeUsedinBatchInput,
  xmref AS IndReferenceNumber,
  kurst AS ExchangeRateType,
  xnegp AS IndNegativePostings,
  xkoaa AS IndPostingstoAssets,
  xkoad AS IndPostingstoCustomer,
  xkoak AS IndPostingstoVendor,
  xkoam AS IndPostingstoMaterialAccount,
  xkoas AS IndPostingstoGLAccount,
  mandt AS SystemClient,
  xrvup,
  xsybl,
  kurst,
  xkoasecc
FROM t003
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _Text ON AccountingDocumentType = _Text.AccountingDocumentType  -- association [0..*]
;