P_FR_AuditFECContrAcctLineItem

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_FR_AuditFECContrAcctLineItem.
-- 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: PFRAUDITCALINITM
-- Parameters: P_AlternativeGLAccountIsUsed : fis_disalteracct, P_MrgDocItmTextIsActive : fr_fec_merge_doc_itemtxt

CREATE VIEW P_FR_AuditFECContrAcctLineItem AS
SELECT
  FICAitems.CompanyCode AS CompanyCode,
  cast(FICAitems.FiscalYear as fis_gjahr preserving type) AS FiscalYear,
  FICAitems.AccountingDocument AS AccountingDocument,
  cast ( FICAitems.AccountingDocumentItem as fis_docln ) AS LedgerGLLineItem,
  FICAitems.Ledger AS Ledger,
  CAReconciliationKey,
  CATotalsRecordSequenceNumber,
  CADocumentNumber,
  CABPItemNumber,
  CASubItemNumber,
  CAClearedDocument,
  FICAitems.LedgerFiscalYear AS LedgerFiscalYear,
  FICAitems.AccountingDocumentType AS AccountingDocumentType,
  _AccountingDocumentTypeText[1:Language = 'F'].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  FICAitems.FiscalPeriod AS FiscalPeriod,
  FICAitems.ChartOfAccounts AS ChartOfAccounts,
  FICAitems.CountryChartOfAccounts AS CountryChartOfAccounts,
  FICAitems.GLAccount AS GLAccount,
  cast( 'S' as farp_koart preserving type) AS FinancialAccountType,
  _GLAcctinCompany.AlternativeGLAccount AS AlternativeGLAccount,
  FICAitems.HouseBank AS HouseBank,
  FICAitems.HouseBankAccount AS HouseBankAccount,
  FICAitems.PostingDate AS PostingDate,
  FICAitems.BusinessPartner AS BusinessPartner,
  cast(FICAitems._BusinessPartner.BusinessPartnerName as businesspartnername) AS BusinessPartnerName,
  cast( FICAitems.BusinessPartner as fifr_subledgeraccount_fec preserving type ) AS FR_FECSubledgerAccount,
  cast (FICAitems._BusinessPartner.BusinessPartnerName as fifr_subledgeraccountname_fec ) AS FR_FECSubledgerAccountName,
  cast ( FICAitems.CAReferenceDocument as fis_xblnr ) AS FR_FECPieceReference,
  FICAitems.DocumentDate AS DocumentDate,
  FICAitems.TransactionCurrency AS TransactionCurrency,
  FICAitems.CAAmountInTransactionCurrency AS AmountInTransactionCurrency,
  FICAitems.CompanyCodeCurrency AS CompanyCodeCurrency,
  FICAitems.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  FICAitems.CAClearingDate AS ClearingDate,
  FICAitems.AccountingDocumentCreationDate AS AccountingDocumentCreationDate
FROM I_FR_CAAuditFECData AS FICAitems
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAcctinCompany ON GLAccount = _GLAcctinCompany.GLAccount AND CompanyCode = _GLAcctinCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAltAcctCOAText ON CountryChartOfAccounts = _GLAltAcctCOAText.ChartOfAccounts AND AlternativeGLAccount = _GLAltAcctCOAText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON _HouseBankAccountText.Language = $session.system_language AND _HouseBankAccountText.CompanyCode = CompanyCode AND _HouseBankAccountText.HouseBank = HouseBank AND _HouseBankAccountText.HouseBankAccount = HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAcctTypeDetails ON ChartOfAccounts = _GLAcctTypeDetails.ChartOfAccounts AND GLAccount = _GLAcctTypeDetails.GLAccount  -- association [0..1]
;