What is P_GB_ClrdPaytPracticePerf1 in SAP S/4HANA?

P_GB_ClrdPaytPracticePerf1 is a composite CDS view in SAP S/4HANA. GB PPPR AP paid invoices Layer 1 It contains 50 fields.

Which tables does P_GB_ClrdPaytPracticePerf1 read from?

P_GB_ClrdPaytPracticePerf1 reads data from: I_JournalEntryItem.

What VDM layer is P_GB_ClrdPaytPracticePerf1?

P_GB_ClrdPaytPracticePerf1 is classified as a Composite view that combines data from multiple basic views.

P_GB_ClrdPaytPracticePerf1

DDL: P_GB_CLRDPAYTPRACTICEPERF1 Type: view_entity COMPOSITE

50 Fields 1 Data Sources 2 Associations

GB PPPR AP paid invoices Layer 1

P_GB_ClrdPaytPracticePerf1 is a Composite CDS View that provides data about "GB PPPR AP paid invoices Layer 1" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 50 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_JournalEntryItem	OpenPayables	from

Parameters (2)

Name	Type	Default
P_FromReportingDate	figen_rep_date_from
P_ToReportingDate	figen_rep_date_to

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_OperationalAcctgDocItem	_OperationalAcctgDocItem	`OpenPayables.CompanyCode = _OperationalAcctgDocItem.CompanyCode and OpenPayables.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument and OpenPayables.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem and OpenPayables.FiscalYear = _OperationalAcctgDocItem.FiscalYear`
[0..1]	I_PaymentDifferenceReason	_PaymentDifferenceReason	`$projection.PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason and $projection.CompanyCode = _PaymentDifferenceReason.CompanyCode`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
EndUserText.label	GB PPPR AP paid invoices Layer 1	view

Fields (50)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_JournalEntryItem	SourceLedger	Source Ledger
KEY	Ledger	I_JournalEntryItem	Ledger	Ledger
KEY	CompanyCode	I_JournalEntryItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_JournalEntryItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_JournalEntryItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_JournalEntryItem	LedgerGLLineItem	Journal Entry Item
	AccountingDocumentItem	I_JournalEntryItem	AccountingDocumentItem	Posting View Item
	AccountingDocumentCategory	I_JournalEntryItem	AccountingDocumentCategory	Journal Entry Category
	AccountingDocumentType	I_JournalEntryItem	AccountingDocumentType	Journal Entry Type
	InvoiceReference	I_JournalEntryItem	InvoiceReference	Invoice Reference
	InvoiceItemReference	I_JournalEntryItem	InvoiceItemReference	Item
	InvoiceReferenceFiscalYear	I_JournalEntryItem	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	ClearingDate	I_JournalEntryItem	ClearingDate	Clearing Date
	PostingDate	I_JournalEntryItem	PostingDate	Posting Date for GR
	DocumentDate	I_JournalEntryItem	DocumentDate	Journal Entry Date
	InvoiceReceiptDate
	FinancialAccountType	I_JournalEntryItem	FinancialAccountType	Fin. Account Type
	Supplier	I_JournalEntryItem	Supplier	Supplier
	FollowOnDocumentType	I_JournalEntryItem	FollowOnDocumentType	Follow-On Document Type
	SpecialGLCode	I_JournalEntryItem	SpecialGLCode	Special G/L Ind
	GLAccount	I_JournalEntryItem	GLAccount	General Ledger
	CostCenter	I_JournalEntryItem	CostCenter	Cost Center
	ProfitCenter	I_JournalEntryItem	ProfitCenter	Profit Center
	FunctionalArea	I_JournalEntryItem	FunctionalArea	Sendr Fctl Area
	BusinessArea	I_JournalEntryItem	BusinessArea	Business Area
	ControllingArea	I_JournalEntryItem	ControllingArea	Controlling Area
	Segment	I_JournalEntryItem	Segment	Segment number
	PurchasingDocument	I_JournalEntryItem	PurchasingDocument	Purchasing Document
	AssignmentReference	I_JournalEntryItem	AssignmentReference	Assignment Reference
	CompanyCodeCurrency	I_JournalEntryItem	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency
	TaxBaseAmountInCoCodeCrcy
	TaxAmountInCoCodeCrcy
	TaxCode	I_JournalEntryItem	TaxCode	Tax Code
	TransactionTypeDetermination	Taxitem	TransactionTypeDetermination	Transaction Key
	ConditionType	Taxitem	ConditionType	Condition type
	TaxRateValidityStartDate	Taxitem	TaxRateValidityStartDate	Tax Rate Validity Start Date
	TransactionCurrency	I_JournalEntryItem	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency
	TaxBaseAmountInTransCrcy
	TaxAmountInTransCrcy
	SupplierFullName
	CityName
	PostalCode
	StreetName
	_Supplier	I_JournalEntryItem	_Supplier
	ClearingDatethen0endasOverdueDays
	PaymentDifferenceReason	_OperationalAcctgDocItem	PaymentDifferenceReason	Reason Code
	_OperationalAcctgDocItem		_OperationalAcctgDocItem
	_PaymentDifferenceReason		_PaymentDifferenceReason

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_GB_ClrdPaytPracticePerf1.
-- 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.
-- Parameters: P_FromReportingDate : figen_rep_date_from, P_ToReportingDate : figen_rep_date_to

CREATE VIEW P_GB_ClrdPaytPracticePerf1 AS
SELECT
  OpenPayables.SourceLedger AS SourceLedger,
  OpenPayables.Ledger AS Ledger,
  OpenPayables.CompanyCode AS CompanyCode,
  OpenPayables.FiscalYear AS FiscalYear,
  OpenPayables.AccountingDocument AS AccountingDocument,
  OpenPayables.LedgerGLLineItem AS LedgerGLLineItem,
  OpenPayables.AccountingDocumentItem AS AccountingDocumentItem,
  OpenPayables.AccountingDocumentCategory AS AccountingDocumentCategory,
  OpenPayables.AccountingDocumentType AS AccountingDocumentType,
  OpenPayables.InvoiceReference AS InvoiceReference,
  OpenPayables.InvoiceItemReference AS InvoiceItemReference,
  OpenPayables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OpenPayables.ClearingDate AS ClearingDate,
  OpenPayables.PostingDate AS PostingDate,
  OpenPayables.DocumentDate AS DocumentDate,
  OpenPayables._JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
  OpenPayables.FinancialAccountType AS FinancialAccountType,
  OpenPayables.Supplier AS Supplier,
  OpenPayables.FollowOnDocumentType AS FollowOnDocumentType,
  OpenPayables.SpecialGLCode AS SpecialGLCode,
  OpenPayables.GLAccount AS GLAccount,
  OpenPayables.CostCenter AS CostCenter,
  OpenPayables.ProfitCenter AS ProfitCenter,
  OpenPayables.FunctionalArea AS FunctionalArea,
  OpenPayables.BusinessArea AS BusinessArea,
  OpenPayables.ControllingArea AS ControllingArea,
  OpenPayables.Segment AS Segment,
  OpenPayables.PurchasingDocument AS PurchasingDocument,
  OpenPayables.AssignmentReference AS AssignmentReference,
  OpenPayables.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( -OpenPayables.AmountInCompanyCodeCurrency as glo_amount_compcode_crcy) AS AmountInCompanyCodeCurrency,
  cast ( Taxitem.TaxBaseAmountInCoCodeCrcy as glo_tax_base_amount ) AS TaxBaseAmountInCoCodeCrcy,
  cast ( Taxitem.TaxAmountInCoCodeCrcy as glo_taxamount_incompcodecrcy ) AS TaxAmountInCoCodeCrcy,
  OpenPayables.TaxCode AS TaxCode,
  Taxitem.TransactionTypeDetermination AS TransactionTypeDetermination,
  Taxitem.ConditionType AS ConditionType,
  Taxitem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  OpenPayables.TransactionCurrency AS TransactionCurrency,
  cast ( OpenPayables.AmountInTransactionCurrency as glo_amount_trans_crcy ) AS AmountInTransactionCurrency,
  cast( Taxitem.TaxBaseAmountInTransCrcy as glo_taxbase_amount_trans_crcy) AS TaxBaseAmountInTransCrcy,
  cast( Taxitem.TaxAmount as glo_taxamount_calc_intranscrcy ) AS TaxAmountInTransCrcy,
  OpenPayables._Supplier.BPSupplierFullName AS SupplierFullName,
  OpenPayables._Supplier.CityName AS CityName,
  OpenPayables._Supplier.PostalCode AS PostalCode,
  OpenPayables._Supplier.StreetName AS StreetName,
  OpenPayables._Supplier AS _Supplier,
  case when OpenPayables.NetDueDate < OpenPayables.ClearingDate and OpenPayables.ClearingDate <> '00000000' then ( dats_days_between(OpenPayables.NetDueDate, OpenPayables.ClearingDate) ) when OpenPayables.NetDueDate >= OpenPayables.ClearingDate then 0 end as OverdueDays AS ClearingDatethen0endasOverdueDays,
  _OperationalAcctgDocItem.PaymentDifferenceReason AS PaymentDifferenceReason
FROM I_JournalEntryItem AS OpenPayables
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON OpenPayables.CompanyCode = _OperationalAcctgDocItem.CompanyCode AND OpenPayables.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND OpenPayables.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem AND OpenPayables.FiscalYear = _OperationalAcctgDocItem.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReason AS _PaymentDifferenceReason ON PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason AND CompanyCode = _PaymentDifferenceReason.CompanyCode  -- association [0..1]
;

Depth:

P_GB_ClrdPaytPracticePerf1 view_entity

I_JournalEntryItem view_entity

P_GB_ClrdPaytPracticePerf2 view_entity