C_PE_StRpPurLdgrDmstcSuplrC

DDL: C_PE_STRPPURLDGRDMSTCSUPLRC SQL: CPEPURLDGRC Type: view CONSUMPTION
37 Fields 4 Data Sources

Purchase Ledger Domestic - Cube

C_PE_StRpPurLdgrDmstcSuplrC is a Consumption CDS View (Cube) that provides data about "Purchase Ledger Domestic - Cube" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, I_AddlCompanyCodeInformation, P_PE_PurDmstcSuplrTaxAggrgd, I_Supplier) and exposes 37 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger, StatryRptCategory.

Data Sources (4)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_AddlCompanyCodeInformation CompanyCodeInfo inner
P_PE_PurDmstcSuplrTaxAggrgd P_PE_PurDmstcSuplrTaxAggrgd from
I_Supplier Supplier inner

Parameters (6)

NameTypeDefault
P_FinancialStatementHierarchy hryid
P_ReportingCurrency glo_reporting_currency
P_TaxConversionIsNotEnabled fipe_deactivate_currency_conv
P_CompanyCode fis_bukrs
P_FiscalYear fis_gjahr_no_conv
P_Ledger rldnr

Annotations (13)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CPEPURLDGRC view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Ledger Domestic - Cube view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode PurchaseTaxEntry CompanyCode Receiver Company Code
KEY FiscalYear PurchaseTaxEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument PurchaseTaxEntry AccountingDocument Journal Entry
KEY Ledger PurchaseTaxEntry Ledger Ledger
KEY StatryRptCategory PurchaseTaxEntry StatryRptCategory Report ID
KEY StatryRptgEntity PurchaseTaxEntry StatryRptgEntity Reporting Entity
KEY StatryRptRunID PurchaseTaxEntry StatryRptRunID Report Run ID
ReportingDate PurchaseTaxEntry ReportingDate
FiscalPeriod PurchaseTaxEntry FiscalPeriod Tax period
ChartOfAccounts I_CompanyCode ChartOfAccounts Node Class
ExchangeRate PurchaseTaxEntry ExchangeRate Exchange rate
PE_CompanyCodeTaxNumber
CalendarYearMonth PurchaseTaxEntry CalendarYearMonth
DocumentDate PurchaseTaxEntry DocumentDate Journal Entry Date
PE_OfficialDocumentType PurchaseTaxEntry PE_OfficialDocumentType
TaxNumber1endasstcd1asTaxNumber1
ExchangeRateDate PurchaseTaxEntry ExchangeRateDate Translatn Date
TransactionCurrency PurchaseTaxEntry TransactionCurrency Transaction Currency
CountryCurrency PurchaseTaxEntry CountryCurrency Currency
ReportingCurrency PurchaseTaxEntry ReportingCurrency Currency
TaxBaseAmount PurchaseTaxEntry TaxBaseAmount TaxBaseAmtInRptgCrcy
TaxAmount PurchaseTaxEntry TaxAmount Tax Amt in Rptg Crcy
PE_TxBaseTxblSlsAmtInCtryCrcy PurchaseTaxEntry PE_TxBaseTxblSlsAmtInCtryCrcy
PE_TaxForTxblSlsAmtInCtryCrcy PurchaseTaxEntry PE_TaxForTxblSlsAmtInCtryCrcy
PE_BaseTxblNonAmtInCtryCrcy PurchaseTaxEntry PE_BaseTxblNonAmtInCtryCrcy
PE_TaxTxblNonTxblAmtInCtryCrcy PurchaseTaxEntry PE_TaxTxblNonTxblAmtInCtryCrcy
PE_TxBaseNonTxblAmtInCtryCrcy PurchaseTaxEntry PE_TxBaseNonTxblAmtInCtryCrcy
PE_TxNonTxblSalesAmtInCtryCrcy PurchaseTaxEntry PE_TxNonTxblSalesAmtInCtryCrcy
PE_NonTxblBaseAmtInCtryCrcy PurchaseTaxEntry PE_NonTxblBaseAmtInCtryCrcy
PE_SelectiveAcqnAmtInCtryCrcy PurchaseTaxEntry PE_SelectiveAcqnAmtInCtryCrcy
PE_TxOnPlasticBagAmtInCtryCrcy PurchaseTaxEntry PE_TxOnPlasticBagAmtInCtryCrcy
PE_OthTxAndChrgsAmtInCtryCrcy PurchaseTaxEntry PE_OthTxAndChrgsAmtInCtryCrcy
_CompanyCode PurchaseTaxEntry _CompanyCode
_FiscalYear PurchaseTaxEntry _FiscalYear
_Ledger PurchaseTaxEntry _Ledger
_FiscalPeriod PurchaseTaxEntry _FiscalPeriod
_TransactionCurrency PurchaseTaxEntry _TransactionCurrency

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 C_PE_StRpPurLdgrDmstcSuplrC.
-- 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: CPEPURLDGRC
-- Parameters: P_FinancialStatementHierarchy : hryid, P_ReportingCurrency : glo_reporting_currency, P_TaxConversionIsNotEnabled : fipe_deactivate_currency_conv, P_CompanyCode : fis_bukrs, P_FiscalYear : fis_gjahr_no_conv, P_Ledger : rldnr

CREATE VIEW C_PE_StRpPurLdgrDmstcSuplrC AS
SELECT
  PurchaseTaxEntry.CompanyCode AS CompanyCode,
  PurchaseTaxEntry.FiscalYear AS FiscalYear,
  PurchaseTaxEntry.AccountingDocument AS AccountingDocument,
  PurchaseTaxEntry.Ledger AS Ledger,
  PurchaseTaxEntry.StatryRptCategory AS StatryRptCategory,
  PurchaseTaxEntry.StatryRptgEntity AS StatryRptgEntity,
  PurchaseTaxEntry.StatryRptRunID AS StatryRptRunID,
  PurchaseTaxEntry.ReportingDate AS ReportingDate,
  PurchaseTaxEntry.FiscalPeriod AS FiscalPeriod,
  CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  PurchaseTaxEntry.ExchangeRate AS ExchangeRate,
  cast(CompanyCodeInfo.CompanyCodeParameterValue as fipe_company_code_tax_number) AS PE_CompanyCodeTaxNumber,
  PurchaseTaxEntry.CalendarYearMonth AS CalendarYearMonth,
  PurchaseTaxEntry.DocumentDate AS DocumentDate,
  PurchaseTaxEntry.PE_OfficialDocumentType AS PE_OfficialDocumentType,
  cast(case when OneTimeAccountBP.AccountingDocument is not null then OneTimeAccountBP.TaxID1 else Supplier.TaxNumber1 end as stcd1) as TaxNumber1 AS TaxNumber1endasstcd1asTaxNumber1,
  PurchaseTaxEntry.ExchangeRateDate AS ExchangeRateDate,
  PurchaseTaxEntry.TransactionCurrency AS TransactionCurrency,
  PurchaseTaxEntry.CountryCurrency AS CountryCurrency,
  PurchaseTaxEntry.ReportingCurrency AS ReportingCurrency,
  PurchaseTaxEntry.TaxBaseAmount AS TaxBaseAmount,
  PurchaseTaxEntry.TaxAmount AS TaxAmount,
  PurchaseTaxEntry.PE_TxBaseTxblSlsAmtInCtryCrcy AS PE_TxBaseTxblSlsAmtInCtryCrcy,
  PurchaseTaxEntry.PE_TaxForTxblSlsAmtInCtryCrcy AS PE_TaxForTxblSlsAmtInCtryCrcy,
  PurchaseTaxEntry.PE_BaseTxblNonAmtInCtryCrcy AS PE_BaseTxblNonAmtInCtryCrcy,
  PurchaseTaxEntry.PE_TaxTxblNonTxblAmtInCtryCrcy AS PE_TaxTxblNonTxblAmtInCtryCrcy,
  PurchaseTaxEntry.PE_TxBaseNonTxblAmtInCtryCrcy AS PE_TxBaseNonTxblAmtInCtryCrcy,
  PurchaseTaxEntry.PE_TxNonTxblSalesAmtInCtryCrcy AS PE_TxNonTxblSalesAmtInCtryCrcy,
  PurchaseTaxEntry.PE_NonTxblBaseAmtInCtryCrcy AS PE_NonTxblBaseAmtInCtryCrcy,
  PurchaseTaxEntry.PE_SelectiveAcqnAmtInCtryCrcy AS PE_SelectiveAcqnAmtInCtryCrcy,
  PurchaseTaxEntry.PE_TxOnPlasticBagAmtInCtryCrcy AS PE_TxOnPlasticBagAmtInCtryCrcy,
  PurchaseTaxEntry.PE_OthTxAndChrgsAmtInCtryCrcy AS PE_OthTxAndChrgsAmtInCtryCrcy,
  PurchaseTaxEntry._CompanyCode AS _CompanyCode,
  PurchaseTaxEntry._FiscalYear AS _FiscalYear,
  PurchaseTaxEntry._Ledger AS _Ledger,
  PurchaseTaxEntry._FiscalPeriod AS _FiscalPeriod,
  PurchaseTaxEntry._TransactionCurrency AS _TransactionCurrency
FROM P_PE_PurDmstcSuplrTaxAggrgd
INNER JOIN I_AddlCompanyCodeInformation AS CompanyCodeInfo ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
;

Learn More