I_AccountingDocument

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_AccountingDocument.
-- 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: IFIACCDOC

CREATE VIEW I_AccountingDocument AS
SELECT
  cast(bukrs as fis_bukrs preserving type) AS CompanyCode,
  cast(gjahr as fis_gjahr preserving type) AS FiscalYear,
  cast(belnr as farp_belnr_d preserving type) AS AccountingDocument,
  cast(blart as farp_blart preserving type) AS AccountingDocumentType,
  cast(bldat as fis_bldat preserving type) AS DocumentDate,
  cast(budat as fis_budat preserving type) AS PostingDate,
  cast( cast( concat( '0', monat ) as abap.numc( 3 ) ) as fins_fiscalperiod) AS FiscalPeriod,
  cast(cpudt as farp_cpudt preserving type) AS AccountingDocumentCreationDate,
  cast(cputm as ttet_dt_cr_time preserving type) AS CreationTime,
  cast(aedat as ttet_dt_chg_date preserving type) AS LastChangeDate,
  cast(wwert as vdm_v_exchange_rate_date preserving type) AS ExchangeRateDate,
  cast(usnam as fis_usnam preserving type) AS AccountingDocCreatedByUser,
  tcode AS TransactionCode,
  cast(bvorg as fac_bvorg preserving type) AS IntercompanyTransaction,
  xblnr AS DocumentReferenceID,
  cast(dbblg as fac_rjet_id preserving type) AS RecurringAccountingDocument,
  stblg AS ReverseDocument,
  stjah AS ReverseDocumentFiscalYear,
  bktxt AS AccountingDocumentHeaderText,
  cast(kursf as ukurs_curr preserving type) AS ExchangeRate,
  kzwrs AS GroupCurrency,
  cast(bstat as farp_bstat_d preserving type) AS AccountingDocumentCategory,
  cast(glvor as fins_bttype preserving type) AS BusinessTransactionType,
  cast(grpid as fac_grpid preserving type) AS BatchInputSession,
  cast(awtyp as fis_awtyp) AS ReferenceDocumentType,
  cast(awkey as fac_awkey) AS OriginalReferenceDocument,
  fikrs AS FinancialManagementArea,
  cast(awsys as fis_awsys) AS ReferenceDocumentLogicalSystem,
  brnch AS Branch,
  adisc AS IsDiscountDocument,
  cast(xref1_hd as fins_xref1_hd) AS Reference1InDocumentHeader,
  cast(xref2_hd as fins_xref2_hd) AS Reference2InDocumentHeader,
  reindat AS InvoiceReceiptDate,
  cast(rldnr as fis_rldnr preserving type) AS Ledger,
  ldgrp AS LedgerGroup,
  cast(xblnr_alt as fac_xblnr_alt preserving type) AS AlternativeReferenceDocument,
  cast(xreversing as fins_xreversing) AS IsReversal,
  cast(xreversed as fins_xreversed) AS IsReversed,
  vatdate AS TaxReportingDate,
  stgrd AS ReversalReason,
  ppdat AS ParkingDate,
  pptme AS ParkingTime,
  cast(waers as waers preserving type) AS Currency,
  cast(hwaer as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(hwae2 as fis_hwae2 preserving type) AS AdditionalCurrency1,
  cast(hwae3 as fis_hwae3 preserving type) AS AdditionalCurrency2,
  xmwst AS TaxIsCalculatedAutomatically,
  numpg AS NmbrOfPages
FROM bkpf
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND FiscalPeriod = _OperationalAcctgDocItem.FiscalPeriod AND AccountingDocumentCategory = _OperationalAcctgDocItem.AccountingDocumentCategory AND PostingDate = _OperationalAcctgDocItem.PostingDate AND DocumentDate = _OperationalAcctgDocItem.DocumentDate AND AccountingDocumentType = _OperationalAcctgDocItem.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON AccountingDocCreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
;