P_JournalEntryOneTimeAcctReuse

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 P_JournalEntryOneTimeAcctReuse.
-- 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 P_JournalEntryOneTimeAcctReuse AS
SELECT
  cast('' as fota_sourcedoctype) AS OneTimeAccountSourceDocType,
  cast('' as fota_sourcedocid) AS OneTimeAccountSourceDocument,
  cast('0000000000' as posnr_acc) AS OneTimeAccountSourceDocItem,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  cast ('' as fota_image_type) AS OneTimeAccountImageType,
  CompanyCode AS CompanyCodeForEdit,
  AccountingDocument AS AccountingDocumentForEdit,
  FiscalYear AS FiscalYearForEdit,
  AccountingDocumentItem AS AccountingDocumentItemForEdit,
  OneTimeAccountBPSalutationText,
  Language,
  BusinessPartnerName1,
  BusinessPartnerName2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  StreetName,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  PostOfficeBankAccount,
  CityName,
  PostalCode,
  Country,
  Region,
  EmailAddress,
  AddressID,
  BankInternalID,
  BankCountry,
  BankAccount,
  BankControlKey,
  BankReference,
  _Bank.SWIFTCode AS SWIFTCode,
  _Bank.Bank AS Bank,
  _IBAN.IBAN AS IBAN,
  cast('' as qriban ) AS QuickResponseIBAN,
  _IBAN.IBANValidityStartDate AS IBANValidityStartDate,
  PaymentRecipient,
  PaymentSystem,
  AliasType,
  BPBankAccountAliasName,
  cast(_OperationalAcctgDocItem.VATRegistration as farp_stceg preserving type) AS VATRegistration,
  DataExchangeInstructionKey,
  DataMediumExchangeIndicator,
  TaxID1,
  TaxID2,
  TaxID3,
  TaxID4,
  TaxID5,
  AccountTaxType,
  TaxNumberType,
  IsNaturalPerson,
  OneTmeAcctIsEqualizationTxSubj,
  BusinessType,
  IndustryType,
  IsVATLiable,
  RepresentativeName,
  OneTimeAcctCntrySpecificRef1,
  cast('' as scrtext_m) AS OneTimeAcctCntrySpcfcRef1Text,
  cast('' as fota_transactiontype) AS OneTimeAccountTransactionType,
  _AccountingDocument.FiscalPeriod AS FiscalPeriod,
  _AccountingDocument.TransactionCurrency AS TransactionCurrency,
  _AccountingDocument.IsReversal AS IsReversal,
  _AccountingDocument.IsReversed AS IsReversed,
  _OperationalAcctgDocItem.AddressAndBankIsSetManually AS AddressAndBankIsSetManually,
  _OperationalAcctgDocItem.FinancialAccountType AS FinancialAccountType,
  _OperationalAcctgDocItem.Customer AS Customer,
  _OperationalAcctgDocItem.Supplier AS Supplier,
  _OperationalAcctgDocItem.InvoiceReference AS InvoiceReference,
  _OperationalAcctgDocItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _OperationalAcctgDocItem.PostingKey AS PostingKey,
  _OperationalAcctgDocItem.SpecialGLCode AS SpecialGLCode,
  _OperationalAcctgDocItem.IsSalesRelated AS IsSalesRelated,
  _OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  _OperationalAcctgDocItem.GLAccount AS GLAccount,
  _OperationalAcctgDocItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  _OperationalAcctgDocItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  _OperationalAcctgDocItem.HasPaymentOrder AS HasPaymentOrder,
  _OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode,
  _OperationalAcctgDocItem.FollowOnDocumentType AS FollowOnDocumentType,
  _OperationalAcctgDocItem.BPBankAccountInternalID AS BPBankAccountInternalID,
  _OperationalAcctgDocItem.PaytSlipWthRefSubscriber AS PaytSlipWthRefSubscriber,
  _OperationalAcctgDocItem.PaytSlipWthRefReference AS PaytSlipWthRefReference,
  _OperationalAcctgDocItem.AlternativePayeePayer AS AlternativePayeePayer,
  IsOneTimeAccount,
  OneTimeAcctBankDetIsFromPayt,
  _AccountingDocument.LastChangeDate AS LastChangeDate,
  cast(OneTimeAccountAuthznGroup as begru) AS OneTimeAccountAuthznGroup,
  cast(OneTimeAccountDataAgingDate as data_temperature) AS OneTimeAccountDataAgingDate,
  cast('' as char70 ) AS OneTimeAccountFieldStatusValue,
  cast(' ' as xfeld ) AS OneTimeAcctDetnIsNotRequired,
  cast(' ' as xfeld ) AS AcctgDocHasQuickRspBillgSupp,
  cast(' ' as xfeld ) AS IBANIsQuickResponse,
  cast(' ' as xfeld ) AS OneTimeAcctChgIsNotAllowed,
  cast(' ' as fota_ref_account_for_iban ) AS ReferenceAccountForIBAN,
  cast(' ' as xfeld ) AS QuickRepIBANIsUsdInOneTmeAcct,
  cast(' ' as xfeld ) AS SEPAMandtIsUsdInOneTimeAcct,
  cast(' ' as xfeld ) AS OneTimeAccountIsCreatedFromAPI,
  cast(' ' as xfeld ) AS QuickRepRefEditIsSupported
FROM I_JournalEntryOneTimeAccount
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_AccountType AS _AccountTaxTypeText ON FinancialAccountType = _AccountTaxTypeText.AccountType AND AccountTaxType = _AccountTaxTypeText.AccountTaxType  -- association [0..*]
LEFT OUTER JOIN I_AR_TaxNumberTypeText AS _TaxNumberTypeText ON TaxNumberType = _TaxNumberTypeText.TaxNumberType  -- association [0..*]
;