I_BillingDocumentType

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_BillingDocumentType.
-- 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_BillingDocumentType AS
SELECT
  fkart AS BillingDocumentType,
  vbtyp AS SDDocumentCategory,
  incpo AS IncrementItemNumber,
  fktyp AS BillingDocumentCategory,
  cast(txtgr as billg_proc_doc_text_detn_head preserving type) AS BillgProcDocTxtDetnProcedure,
  cast(txtgr_p as billg_proc_doc_text_detn_item preserving type) AS BillgProcDocItmTxtDetnProced
FROM tvfk
LEFT OUTER JOIN I_BillingDocumentTypeText AS _Text ON BillingDocumentType = _Text.BillingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentCategory AS _BillingDocumentCategory ON BillingDocumentCategory = _BillingDocumentCategory.BillingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_TextDeterminationProcedure AS _BillgProcDocTxtDetnProcedure ON BillgProcDocTxtDetnProcedure = _BillgProcDocTxtDetnProcedure.TextDeterminationProcedure AND _BillgProcDocTxtDetnProcedure.TextObjectCategory = 'VBBK'  -- association [0..1]
LEFT OUTER JOIN I_TextDeterminationProcedure AS _BillgProcDocItmTxtDetnProced ON BillgProcDocItmTxtDetnProced = _BillgProcDocItmTxtDetnProced.TextDeterminationProcedure AND _BillgProcDocItmTxtDetnProced.TextObjectCategory = 'VBBP'  -- association [0..1]
;