I_CAInvcgDocHeader

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_CAInvcgDocHeader.
-- 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_CAInvcgDocHeader AS
SELECT
  invdocno AS CAInvoicingDocument,
  applk AS CAApplicationArea,
  inv_process AS CAInvcgProcess,
  inv_type AS CAInvcgType,
  inv_category AS CAInvcgCategory,
  cast(techdoctype as techdoctype_gfn_kk preserving type) AS CAInvcgTechnicalDocumentType,
  targprocess AS CAInvcgTargetProcess,
  cast(gpart as bu_partner preserving type) AS BusinessPartner,
  vkont AS ContractAccount,
  mdcat AS CAInvcgMasterDataType,
  abwvk AS AltvContractAcctForCollvBills,
  cast(abwbl as abwbl_gfn_kk preserving type ) AS CASubstituteDocumentNumber,
  crname AS CreatedByUser,
  crdate AS CAInvcgCreationDate,
  crtime AS CAInvcgCreationTime,
  crmode AS CAInvcgDocCreationMode,
  recnum AS CAInvcgNmbrOfInvoicingDocItems,
  cast(bit_number as bit_number_gfn_kk preserving type) AS CABllbleItmNumber,
  invrunno AS CAInvcgDocInternalNumber,
  fikey AS CAReconciliationKey,
  budat AS CAPostingDate,
  bldat AS DocumentDate,
  faedn AS CANetDueDate,
  faeds AS CACashDiscountDueDate,
  sktpz AS CACashDiscountRate,
  total_curr AS TransactionCurrency,
  total_amt AS CAAmountInTransactionCurrency,
  invoiced AS CAInvcgIsDocumentPosted,
  simulated AS CAInvcgIsDocumentSimulated,
  cast(preliminary as inv_preliminary_gfn_kk preserving type) AS CAInvcgIsDocumentPreliminary,
  cast(prlinv_cat as prlinv_cat_gfn_kk preserving type) AS CAInvcgPreliminaryCategory,
  prlinv_cnt AS CAPrelimInvcgDocValue,
  cast(prlinv_status as prlinv_status_gfn_kk preserving type) AS CAPreliminaryInvcgDocStatus,
  revreason AS CAInvcgDocumentReversalReason,
  cast(reversaldoc as inv_reversaldoc_gfn_kk preserving type) AS CAInvcgReversalDocument,
  cast(reverseddoc as inv_reverseddoc_gfn_kk preserving type) AS CAInvcgReversedDocument,
  cast(corrcat as corrcat_gfn_kk preserving type) AS CAInvcgCorrectionCategory,
  printdate AS CAInvcgDocumentPrintDate,
  printlock AS CAInvcgDocIsLockedForPrinting,
  nrzas AS CAPaymentFormNumber,
  form_id AS CAInvcgDocFormID,
  formkey AS ApplicationForm,
  zlsch AS FormIDForAttachedPaymentMedium,
  doctype AS CAInvcgDocumentType,
  exkid AS CAKeyIdentification,
  cast(exbel as exbel_no_conv_kk) AS CAOfficialDocumentNumber,
  ptsrl AS CAPartnerSettlementRule,
  bukrs AS CompanyCode,
  bupla AS BusinessPlace,
  vtref AS CAContract,
  subap AS CASubApplication,
  invoice_basedate AS CAInvcgBaseDate,
  invpercat AS CAInvcgDocPeriodCategory,
  invperiod AS CAInvcgDocPeriodDate,
  invperiod_from AS CAInvcgDocPeriodStartDate,
  mazae AS CADunningCounter,
  cast(chgdoc_ex as chgdoc_ex_gfn_kk preserving type) AS CAInvcgDocHasChargeOrDiscItems,
  cast(cfcsimulated as inv_cfcsimulated_gfn_kk preserving type) AS CAInvcgDocHasControlDoc,
  bollotax AS CAInvcgBolloTaxPostStatus,
  xsubinv AS CAInvcgDocIsPartOfList,
  xinvdoc_x AS CAInvcgDocHasObjectRelation,
  sepa_prenot AS CAInvcgDocHasSEPAPreNotif,
  cast(ext_invdocno as ext_invdocno_gfn_kk preserving type) AS CAInvcgDocExternal,
  adjustmentdoc AS CAInvcgAdjustmentDocument,
  cast(adjusteddoc as adjustedinvdoc_gfn_kk preserving type) AS CAInvcgAdjustedDocument,
  cast('FKKINV' as nrobj) AS NameNumberRangeObject
FROM dfkkinvdoc_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_ContractAccountPartner AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _AltvContractAcctForCollvBills ON AltvContractAcctForCollvBills = _AltvContractAcctForCollvBills.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgReversalDocument ON CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgReversedDocument ON CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgPreliminaryCategory AS _CAInvcgPreliminaryCategory ON CAInvcgPreliminaryCategory = _CAInvcgPreliminaryCategory.CAInvcgPreliminaryCategory  -- association [0..1]
LEFT OUTER JOIN I_CAPreliminaryInvcgDocStatus AS _CAPreliminaryInvcgDocStatus ON CAPreliminaryInvcgDocStatus = _CAPreliminaryInvcgDocStatus.CAPreliminaryInvcgDocStatus  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocReversalReason AS _CAInvcgDocReversalReason ON CAInvcgDocumentReversalReason = _CAInvcgDocReversalReason.CAInvcgDocumentReversalReason  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocLockedforPrint AS _CAInvcgDocLockedforPrint ON CAInvcgDocIsLockedForPrinting = _CAInvcgDocLockedforPrint.CAInvcgDocIsLockedForPrinting  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgProcess AS _CAInvcgProcess ON CAInvcgProcess = _CAInvcgProcess.CAInvcgProcess AND CAApplicationArea = _CAInvcgProcess.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCategory AS _CAInvcgCategory ON CAInvcgCategory = _CAInvcgCategory.CAInvcgCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgType AS _CAInvcgType ON CAInvcgType = _CAInvcgType.CAInvcgType AND CAApplicationArea = _CAInvcgType.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocumentType AS _CAInvcgDocumentType ON CAInvcgDocumentType = _CAInvcgDocumentType.CAInvcgDocumentType AND CAApplicationArea = _CAInvcgDocumentType.CAApplicationArea AND _CAInvcgDocumentType.NameNumberRangeObject = 'FKKINVDOC'  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgPeriodCat AS _CAInvcgPeriodCat ON CAInvcgDocPeriodCategory = _CAInvcgPeriodCat.CAInvcgPeriodCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgTargetProc AS _CAInvcgTargetProc ON CAInvcgTargetProcess = _CAInvcgTargetProc.CAInvcgTargetProcess  -- association [0..1]
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCorrectionCat AS _CAInvcgCorrectionCat ON CAInvcgCorrectionCategory = _CAInvcgCorrectionCat.CAInvcgCorrectionCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocChrgDiscItems AS _CAInvcgDocChrgDiscItems ON CAInvcgDocHasChargeOrDiscItems = _CAInvcgDocChrgDiscItems.CAInvcgDocHasChargeOrDiscItems  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocCreationMode AS _CAInvcgDocCreationMode ON CAInvcgDocCreationMode = _CAInvcgDocCreationMode.CAInvcgDocCreationMode  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgMasterDataType AS _CAInvcgMasterDataType ON CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocTechDocType AS _CAInvcgDocTechDocType ON CAInvcgTechnicalDocumentType = _CAInvcgDocTechDocType.CAInvcgTechnicalDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocPartOfList AS _CAInvcgDocPartOfList ON CAInvcgDocIsPartOfList = _CAInvcgDocPartOfList.CAInvcgDocIsPartOfList  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgBolloTaxPostStatus AS _CAInvcgBolloTaxPostStatus ON CAInvcgBolloTaxPostStatus = _CAInvcgBolloTaxPostStatus.CAInvcgBolloTaxPostStatus  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CAReconciliationKey AS _CAReconciliationKey ON CAReconciliationKey = _CAReconciliationKey.CAReconciliationKey  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN E_CAInvcgDocHeader AS _Extension ON CAInvoicingDocument = _Extension.CAInvoicingDocument  -- association [0..1]
;