C_PE_StRpPurLdgrFrgnSuplrC

DDL: C_PE_STRPPURLDGRFRGNSUPLRC SQL: CPEPRLDFRC Type: view CONSUMPTION
21 Fields 2 Data Sources

Purchase Ledger Foreign Vendors - Cube

C_PE_StRpPurLdgrFrgnSuplrC is a Consumption CDS View (Cube) that provides data about "Purchase Ledger Foreign Vendors - Cube" in SAP S/4HANA. It reads from 2 data sources (P_PE_PurFrgnSuplrEntryAggrgd, I_StRpJournalEntryLog) and exposes 21 fields with key fields CompanyCode, FiscalYear, AccountingDocument, StatryRptCategory, StatryRptgEntity.

Data Sources (2)

SourceAliasJoin Type
P_PE_PurFrgnSuplrEntryAggrgd JournalEntry from
I_StRpJournalEntryLog StRpJournalEntryLog inner

Parameters (6)

NameTypeDefault
P_PE_ClassfctnRevenueType hryid
P_PE_ClassfctnServiceType hryid
P_ReportingCurrency glo_reporting_currency
P_CompanyCode fis_bukrs
P_FiscalYear fis_gjahr_no_conv
P_Ledger rldnr

Annotations (13)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PE_PurFrgnSuplrEntryAggrgd CompanyCode Receiver Company Code
KEY FiscalYear P_PE_PurFrgnSuplrEntryAggrgd FiscalYear G/L Fiscal Year
KEY AccountingDocument P_PE_PurFrgnSuplrEntryAggrgd AccountingDocument Journal Entry
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
KEY Ledger P_PE_PurFrgnSuplrEntryAggrgd Ledger Ledger
ReportingDate P_PE_PurFrgnSuplrEntryAggrgd ReportingDate
FiscalPeriod P_PE_PurFrgnSuplrEntryAggrgd FiscalPeriod Tax period
CalendarYearMonth P_PE_PurFrgnSuplrEntryAggrgd CalendarYearMonth
FiscalPeriodDate P_PE_PurFrgnSuplrEntryAggrgd FiscalPeriodDate
DocumentDate P_PE_PurFrgnSuplrEntryAggrgd DocumentDate Journal Entry Date
PE_DocumentSerialNumber P_PE_PurFrgnSuplrEntryAggrgd PE_DocumentSerialNumber
PE_OfficialDocumentNumber P_PE_PurFrgnSuplrEntryAggrgd PE_OfficialDocumentNumber
TransactionCurrency P_PE_PurFrgnSuplrEntryAggrgd TransactionCurrency Transaction Currency
CountryCurrency P_PE_PurFrgnSuplrEntryAggrgd CountryCurrency Currency
ReportingCurrency
PE_SUNATCountryCode P_PE_PurFrgnSuplrEntryAggrgd PE_SUNATCountryCode
SupplierName P_PE_PurFrgnSuplrEntryAggrgd SupplierName Supplier Name
TaxNumber1 P_PE_PurFrgnSuplrEntryAggrgd TaxNumber1 VAT Reg. No.
PE_ConventionAvoidDoubleTxn P_PE_PurFrgnSuplrEntryAggrgd PE_ConventionAvoidDoubleTxn

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_StRpPurLdgrFrgnSuplrC.
-- 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: CPEPRLDFRC
-- Parameters: P_PE_ClassfctnRevenueType : hryid, P_PE_ClassfctnServiceType : hryid, P_ReportingCurrency : glo_reporting_currency, P_CompanyCode : fis_bukrs, P_FiscalYear : fis_gjahr_no_conv, P_Ledger : rldnr

CREATE VIEW C_PE_StRpPurLdgrFrgnSuplrC AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  JournalEntry.Ledger AS Ledger,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.CalendarYearMonth AS CalendarYearMonth,
  JournalEntry.FiscalPeriodDate AS FiscalPeriodDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.PE_DocumentSerialNumber AS PE_DocumentSerialNumber,
  JournalEntry.PE_OfficialDocumentNumber AS PE_OfficialDocumentNumber,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  JournalEntry.CountryCurrency AS CountryCurrency,
  cast( $parameters.P_ReportingCurrency as glo_reporting_currency ) AS ReportingCurrency,
  JournalEntry.PE_SUNATCountryCode AS PE_SUNATCountryCode,
  JournalEntry.SupplierName AS SupplierName,
  JournalEntry.TaxNumber1 AS TaxNumber1,
  JournalEntry.PE_ConventionAvoidDoubleTxn AS PE_ConventionAvoidDoubleTxn
FROM P_PE_PurFrgnSuplrEntryAggrgd AS JournalEntry
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;

Learn More