I_CABillgDocHeader

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_CABillgDocHeader.
-- 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_CABillgDocHeader AS
SELECT
  billdocno AS CABillgDocument,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  bill_type AS CABillgType,
  cast(date_from as bill_period_from_gfn_kk preserving type ) AS CABillgDocPeriodStartDate,
  cast(date_to as bill_period_to_gfn_kk preserving type ) AS CABillgDocPeriodEndDate,
  revreason AS CABillgDocumentReversalReason,
  simulated AS CABillgIsDocumentSimulated,
  cast(refdocno as refdocno_gfn_kk preserving type ) AS CABillgDocumentExternal,
  log_system AS LogicalSystem,
  applk AS CAApplicationArea,
  srcprocess AS CABillgDocOriginProcess,
  srcdoctype AS CAInvcgSourceDocumentType,
  cast(techdoctype as techdoctype_gfn_kk preserving type ) AS CAInvcgTechnicalDocumentType,
  doctype AS CAInvcgDocumentType,
  targprocess AS CAInvcgTargetProcess,
  mdcat AS CAInvcgMasterDataType,
  cast(gpart_inv as gpart_inv_gfn_kk preserving type ) AS CAInvcgAltvBusinessPartner,
  cast(vkont_inv as vkont_inv_gfn_kk preserving type ) AS CAInvcgAltvContractAccount,
  bill_basedate AS CABillgBaseDate,
  bill_curr AS CABillgCurrency,
  cast(inv_curr as inv_curr_gfn_kk preserving type ) AS CAInvcgCurrency,
  tax_det_type AS CATaxDetnType,
  tax_date_type AS CATaxDateType,
  inv_category AS CAInvcgCategory,
  cast(separate_inv as separate_inv_bitpack_gfn_kk preserving type ) AS CAInvcgControlOfInvoicingUnit,
  invoice_first AS CAInvcgFirstDate,
  cast(reversaldoc as reversalbilldoc_gfn_kk preserving type ) AS CABillgReversalDocument,
  cast(reverseddoc as reversedbilldoc_gfn_kk preserving type ) AS CABillgReversedDocument,
  cast(adjustmentdoc as adjustmentbilldoc_gfn_kk preserving type ) AS CABillgAdjustmentDocument,
  adjusteddoc AS CABillgAdjustedDocument,
  cast(corrcat as corrcat_gfn_kk preserving type ) AS CAInvcgCorrectionCategory,
  cast(trigdeleted as trigdeleted_gfn_kk preserving type ) AS CaInvcgIsOrderDeleted,
  xinfbill AS CABillgHasAdditionalInvoice,
  cast(xbillac as xbillac_gfn_kk preserving type ) AS CAInvcgIsAccrualPostingRlvt,
  invlock AS CABillgLockedForInvoicing,
  cast(add_group as add_group_gfn_kk preserving type ) AS CABillgGrpgOfAdditionalItems,
  cast(xinvbill_x as xinvbill_x_gfn_kk preserving type ) AS CABillgDocHasRefObjects,
  recnum AS CABillgDocumentNumberOfItems,
  cast(bit_number as bit_number_gfn_kk preserving type ) AS CABllbleItmNumber,
  crname AS CreatedByUser,
  crdate AS CABillgDocCreationDate,
  crtime AS CABillgDocCreationTime,
  cast(billrunno as billrunno_gfn_kk preserving type ) AS CABillgDocInternalNumber,
  bill_process AS CABillgProcess,
  prepaid_incl AS CABillgDocHasPrepaidItems,
  pprefill_incl AS CABillgDocHasRefillItems,
  revrec_incl AS CABillgDocHasRevnRecgnItems,
  ptsrl AS CAPartnerSettlementRule,
  invstatus AS CABillgDocumentInvcgStatus,
  invdocno AS CAInvoicingDocument,
  invcrdate AS CAInvcgCreationDate,
  keypp AS CASubAreaForParallelization,
  altmd_orig_incl AS CAAltvMDOriginalIsIncluded
FROM dfkkinvbill_h AS _dfkkinvbill_h
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CAInvcgAltvBusinessPartner ON CAInvcgAltvBusinessPartner = _CAInvcgAltvBusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAInvcgAltvContractAccount ON CAInvcgAltvContractAccount = _CAInvcgAltvContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CABillgCurrency ON CABillgCurrency = _CABillgCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CAInvcgCurrency ON CAInvcgCurrency = _CAInvcgCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgReversalDocument ON CABillgReversalDocument = _CABillgReversalDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgReversedDocument ON CABillgReversedDocument = _CABillgReversedDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgAdjustmentDocument ON CABillgAdjustmentDocument = _CABillgAdjustmentDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgAdjustedDocument ON CABillgAdjustedDocument = _CABillgAdjustedDocument.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocOriginProcess AS _CABillgDocOriginProcess ON CABillgDocOriginProcess = _CABillgDocOriginProcess.CABillgDocOriginProcess  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgTargetProc AS _CAInvcgTargetProc ON CAInvcgTargetProcess = _CAInvcgTargetProc.CAInvcgTargetProcess  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCategory AS _CAInvcgCategory ON CAInvcgCategory = _CAInvcgCategory.CAInvcgCategory  -- association [0..1]
LEFT OUTER JOIN I_CABillgProcess AS _CABillgProcess ON CABillgProcess = _CABillgProcess.CABillgProcess  -- association [0..1]
LEFT OUTER JOIN I_CABillgType AS _CABillgType ON CABillgType = _CABillgType.CABillgType  -- association [0..1]
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSourceDocType AS _CAInvcgSourceDocType ON _CAInvcgSourceDocType.CAInvcgSourceDocumentCat = 'INVBI' AND CAInvcgSourceDocumentType = _CAInvcgSourceDocType.CAInvcgSourceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocumentType AS _CAInvcgDocumentType ON CAInvcgDocumentType = _CAInvcgDocumentType.CAInvcgDocumentType AND CAApplicationArea = _CAInvcgDocumentType.CAApplicationArea AND _CAInvcgDocumentType.NameNumberRangeObject = 'FKKINVBILL'  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocTechDocType AS _CAInvcgDocTechDocType ON CAInvcgTechnicalDocumentType = _CAInvcgDocTechDocType.CAInvcgTechnicalDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocReversalReason AS _CABillgDocReversalReason ON CABillgDocumentReversalReason = _CABillgDocReversalReason.CABillgDocumentReversalReason  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgMasterDataType AS _CAInvcgMasterDataType ON CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType  -- association [0..1]
LEFT OUTER JOIN I_CATaxDetnType AS _CATaxDetnType ON CATaxDetnType = _CATaxDetnType.CATaxDetnType  -- association [0..1]
LEFT OUTER JOIN I_CATaxDateType AS _CATaxDateType ON CATaxDateType = _CATaxDateType.CATaxDateType  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgControlOfInvcgUnit AS _CAInvcgControlOfInvcgUnit ON CAInvcgControlOfInvoicingUnit = _CAInvcgControlOfInvcgUnit.CAInvcgControlOfInvoicingUnit  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCorrectionCat AS _CAInvcgCorrectionCat ON CAInvcgCorrectionCategory = _CAInvcgCorrectionCat.CAInvcgCorrectionCategory  -- association [0..1]
LEFT OUTER JOIN I_CABillgExistsAddInvcg AS _CABillgExistsAddInvcg ON CABillgHasAdditionalInvoice = _CABillgExistsAddInvcg.CABillgHasAdditionalInvoice  -- association [0..1]
LEFT OUTER JOIN I_CABillgLockedForInvcg AS _CABillgLockedForInvcg ON CABillgLockedForInvoicing = _CABillgLockedForInvcg.CABillgLockedForInvoicing  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocInvcgStatus AS _CABillgDocInvcgStatus ON CABillgDocumentInvcgStatus = _CABillgDocInvcgStatus.CABillgDocumentInvcgStatus  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN E_CABillgDocHeader AS _Extension ON CABillgDocument = _Extension.CABillgDocument  -- association [0..1]
;