I_CAInvcgRequest

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_CAInvcgRequest.
-- 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_CAInvcgRequest AS
SELECT
  cast(srcdoccat as srcdoccat_gfn_kk preserving type) AS CAInvcgSourceDocumentCat,
  cast(srcdocno as srcdocno_gfn_kk preserving type) AS CAInvcgSourceDocumentNumber,
  abwvk AS AltvContractAcctForCollvBills,
  applk AS CAApplicationArea,
  bukrs AS CompanyCode,
  bupla AS BusinessPlace,
  cast(corrcat as corrcat_gfn_kk preserving type) AS CAInvcgCorrectionCategory,
  crdate AS CAInvcgReqCreationDate,
  crname AS CAInvcgReqCreationUser,
  cast(date_from as bill_period_from_gfn_kk preserving type) AS CAInvcgReqStartDate,
  cast(date_to as bill_period_to_gfn_kk preserving type) AS CAInvcgReqEndDate,
  cast(gpart as bu_partner preserving type) AS BusinessPartner,
  inv_category AS CAInvcgCategory,
  invoice_basedate AS CAInvcgBaseDate,
  invoice_first AS CAInvcgFirstDate,
  invtriglock AS CAInvcgReqIsLockedForInvoicing,
  invtriglock_rsn AS CAInvcgReqLockReason,
  invtriglock_date AS CAInvcgReqLockDate,
  invtriglock_date_to AS CAInvcgReqLockedToDate,
  invtriglock_user AS CAInvcgReqLockedByUser,
  log_system AS LogicalSystem,
  mdcat AS CAInvcgMasterDataType,
  ptsrl AS CAPartnerSettlementRule,
  recnum AS CASourceDocumentNumberOfItems,
  cast(bit_number as bit_number_gfn_kk preserving type) AS CABllbleItmNumber,
  cast(separate_inv as separate_inv_bitpack_gfn_kk preserving type) AS CAInvcgControlOfInvoicingUnit,
  cast(simulated as invtrig_simulated_gfn_kk preserving type) AS CAInvcgReqIsDocumentSimulated,
  spart AS Division,
  srcdoc_amount AS CAInvcgSourceDocumentAmount,
  srcdoc_crdate AS CASourceDocumentCreationDate,
  srcdoctype AS CAInvcgSourceDocumentType,
  srcprocess AS CABillgDocOriginProcess,
  subap AS CASubApplication,
  targprocess AS CAInvcgTargetProcess,
  cast(techdoctype as techdoctype_gfn_kk preserving type) AS CAInvcgTechnicalDocumentType,
  vkont AS ContractAccount,
  vtref AS CAContract,
  waers AS TransactionCurrency
FROM dfkkinv_trig
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
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_ContractAccountHeader AS _AltvContractAccountHeader ON AltvContractAcctForCollvBills = _AltvContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSourceDocCat AS _CAInvcgSourceDocCat ON CAInvcgSourceDocumentCat = _CAInvcgSourceDocCat.CAInvcgSourceDocumentCat  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCategory AS _CAInvcgCategory ON CAInvcgCategory = _CAInvcgCategory.CAInvcgCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgReqLock AS _CAInvcgReqLock ON CAInvcgReqIsLockedForInvoicing = _CAInvcgReqLock.CAInvcgReqIsLockedForInvoicing  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgReqLockReason AS _CAInvcgReqLockReason ON CAInvcgReqLockReason = _CAInvcgReqLockReason.CAInvcgReqLockReason  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSourceDocType AS _CAInvcgSourceDocType ON CAInvcgSourceDocumentType = _CAInvcgSourceDocType.CAInvcgSourceDocumentType AND CAInvcgSourceDocumentCat = _CAInvcgSourceDocType.CAInvcgSourceDocumentCat  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgTargetProc AS _CAInvcgTargetProc ON CAInvcgTargetProcess = _CAInvcgTargetProc.CAInvcgTargetProcess  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocTechDocType AS _CAInvcgDocTechDocType ON CAInvcgTechnicalDocumentType = _CAInvcgDocTechDocType.CAInvcgTechnicalDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgMasterDataType AS _CAInvcgMasterDataType ON CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocOriginProcess AS _CABillgDocOriginProcess ON CABillgDocOriginProcess = _CABillgDocOriginProcess.CABillgDocOriginProcess  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCorrectionCat AS _CAInvcgCorrectionCat ON CAInvcgCorrectionCategory = _CAInvcgCorrectionCat.CAInvcgCorrectionCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgControlOfInvcgUnit AS _CAInvcgControlOfInvcgUnit ON CAInvcgControlOfInvoicingUnit = _CAInvcgControlOfInvcgUnit.CAInvcgControlOfInvoicingUnit  -- association [0..1]
LEFT OUTER JOIN I_CACompanyCode AS _CACompanyCode ON CompanyCode = _CACompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CAInvcgReqCreationUser = _User.UserID  -- association [0..1]
;