I_ParkedOplAcctgDocument

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_ParkedOplAcctgDocument.
-- 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_ParkedOplAcctgDocument AS
SELECT
  ausbk AS SourceCompanyCode,
  cast( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast( belnr as fis_belnr preserving type ) AS SourceAccountingDocument,
  cast( gjahr as fis_gjahr_no_conv ) AS SourceFiscalYear,
  cast( bstat as farp_bstat_d preserving type ) AS AccountingDocumentCategory,
  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( wwert as vdm_v_exchange_rate_date preserving type) AS ExchangeRateDate,
  cast( cpudt as farp_cpudt preserving type ) AS AccountingDocumentCreationDate,
  cast( cputm as ttet_dt_cr_time preserving type ) AS CreationTime,
  cast ( aedat as fis_lastmanualchangedate preserving type ) AS LastManualChangeDate,
  cast ( upddt as fis_lastautomaticchangedate preserving type ) AS LastAutomaticChangeDate,
  cast( usnam as fis_usnam preserving type) AS AccountingDocCreatedByUser,
  tcode AS TransactionCode,
  cast( bvorg as fac_bvorg preserving type ) AS IntercompanyTransaction,
  cast( xblnr as fis_xblnr1 preserving type ) AS DocumentReferenceID,
  bktxt AS AccountingDocumentHeaderText,
  fikrs AS FinancialManagementArea,
  waers AS TransactionCurrency,
  cast( hwaer as fis_hwaer ) AS CompanyCodeCurrency,
  cast( hwae2 as fis_hwae2 ) AS AdditionalCurrency1,
  cast( hwae3 as fis_hwae3 ) AS AdditionalCurrency2,
  cast( curt2 as fis_adl1_currole ) AS AdditionalCurrency1Role,
  cast( curt3 as fis_adl2_currole ) AS AdditionalCurrency2Role,
  cast( awtyp as fis_awtyp preserving type ) AS ReferenceDocumentType,
  cast( awkey as fac_awkey preserving type ) AS OriginalReferenceDocument,
  cast(awsys as fis_awsys preserving type) AS ReferenceDocumentLogicalSystem,
  cast( brnch as fis_j_1abrnch preserving type) AS Branch,
  cast( reindat as fis_reindat ) AS InvoiceReceiptDate,
  ldgrp AS LedgerGroup,
  vbund AS PartnerCompany,
  vatdate AS TaxReportingDate,
  cast( xmwst as fis_xmwst ) AS TaxIsCalculatedAutomatically
FROM vbkpf
LEFT OUTER JOIN I_CompanyCode AS _SourceCompanyCode ON SourceCompanyCode = _SourceCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _SourceFiscalYear ON SourceFiscalYear = _SourceFiscalYear.FiscalYear AND CompanyCode = _SourceFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.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_CurrencyRole AS _AdditionalCurrency1Role ON AdditionalCurrency1Role = _AdditionalCurrency1Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _AdditionalCurrency2Role ON AdditionalCurrency2Role = _AdditionalCurrency2Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RefDocumentLogicalSystem ON ReferenceDocumentLogicalSystem = _RefDocumentLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
;