I_ParkedAccountingDocument

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_ParkedAccountingDocument.
-- 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: IFIPARKEDACCDOC

CREATE VIEW I_ParkedAccountingDocument AS
SELECT
  bukrs AS CompanyCode,
  cast(belnr as farp_belnr_d preserving type ) AS AccountingDocument,
  gjahr AS FiscalYear,
  cast(blart as farp_blart preserving type ) AS AccountingDocumentType,
  bldat AS DocumentDate,
  budat 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,
  cputm AS CreationTime,
  aedat AS LastChangeDate,
  wwert AS ExchangeRateDate,
  usnam AS AccountingDocCreatedByUser,
  tcode AS TransactionCode,
  bvorg AS IntercompanyTransaction,
  xblnr AS DocumentReferenceID,
  bktxt AS AccountingDocumentHeaderText,
  waers AS Currency,
  cast(kursf as ukurs_curr preserving type ) AS ExchangeRate,
  cast(bstat as farp_bstat_d preserving type ) AS AccountingDocumentCategory,
  awtyp AS ReferenceDocumentType,
  awkey AS OriginalReferenceDocument,
  fikrs AS FinancialManagementArea,
  cast(hwaer as farp_hwaer preserving type ) AS CompanyCodeCurrency,
  cast(hwae2 as farp_hwae2 preserving type ) AS AdditionalCurrency1,
  cast(hwae3 as farp_hwae3 preserving type ) AS AdditionalCurrency2,
  cast(curt2 as fis_adl1_currole preserving type ) AS AdditionalCurrency1Role,
  cast(curt3 as fis_adl2_currole preserving type ) AS AdditionalCurrency2Role,
  awsys AS ReferenceDocumentLogicalSystem,
  brnch AS Branch,
  reindat AS InvoiceReceiptDate,
  ldgrp AS LedgerGroup,
  vbund AS PartnerCompany,
  vatdate AS TaxReportingDate,
  xmwst AS TaxIsCalculatedAutomatically,
  txkrs AS TaxExchangeRate
FROM vbkpf
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..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_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- 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]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
;