What is P_DwnPaytReqItem in SAP S/4HANA?

P_DwnPaytReqItem is a composite CDS view in SAP S/4HANA. Down Payment Request Items It contains 140 fields.

Which tables does P_DwnPaytReqItem read from?

P_DwnPaytReqItem reads data from: I_OperationalAcctgDocItem, I_ParkedOplAcctgDocPyblsItem.

What VDM layer is P_DwnPaytReqItem?

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

P_DwnPaytReqItem

DDL: P_DWNPAYTREQITEM Type: view_entity COMPOSITE Package: ODATA_VERIFY_SUPPLIER_DPRS

140 Fields 2 Data Sources

Down Payment Request Items

P_DwnPaytReqItem is a Composite CDS View that provides data about "Down Payment Request Items" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_ParkedOplAcctgDocPyblsItem) and exposes 140 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem, FiscalYear. Part of development package ODATA_VERIFY_SUPPLIER_DPRS.

Data Sources (2)

Source	Alias	Join Type
I_OperationalAcctgDocItem	I_OperationalAcctgDocItem	union_all
I_ParkedOplAcctgDocPyblsItem	I_ParkedOplAcctgDocPyblsItem	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Down Payment Request Items	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (140)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode			Source CoCode
KEY	FiscalYear		SourceFiscalYear	G/L Fiscal Year
KEY	AccountingDocument		SourceAccountingDocument	Journal Entry
KEY	AccountingDocumentItem		SourceAccountingDocumentItem	Posting View Item
	Supplier		Supplier	Supplier
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	TransactionCurrency		TransactionCurrency	Transaction Currency
	DocumentItemText		DocumentItemText	Text
	AssignmentReference			Assignment Reference
	BPBankAccountInternalID		BPBankAccountInternalID	BP Bank Account
	TaxCode		TaxCode	Tax Code
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	PaymentReference		PaymentReference	Payment Reference
	DunningArea		DunningArea	Dunning Area
	LastDunningDate		LastDunningDate	Last Dunned
	DunningLevel		DunningLevel	Dunning Level
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	CashDiscount1Percent		CashDiscount1Percent	Disc. Percent 1
	DueCalculationBaseDate		DueCalculationBaseDate	Due Calculation Base Date
	AlternativePayeePayer		AlternativePayeePayer	Alternative Payee/Payer
	PaymentMethod		PaymentMethod	Pymt Meth.
	PaymentMethodSupplement		PaymentMethodSupplement	Pmnt Meth. Sup.
	PaymentBlockingReason		PaymentBlockingReason	Pmnt block
	BranchCode		BranchCode	Branch Code
	DataExchangeInstruction1		DataExchangeInstruction1	Instruction 1
	DataExchangeInstruction2		DataExchangeInstruction2	Instruction 2
	DataExchangeInstruction3		DataExchangeInstruction3	Instruction 3
	DataExchangeInstruction4		DataExchangeInstruction4	Instruction 4
	HouseBank		HouseBank	House Bank
	GLAccount		GLAccount	General Ledger
	HouseBankAccount		HouseBankAccount	House Bank Account
	SpecialGLAccountAssignment		SpecialGLAccountAssignment	Special G/L Assignmt
	DunningBlockingReason		DunningBlockingReason	Set Dunning Block
	DunningKey		DunningKey	Dunning Key
	PaymentDifferenceReason		PaymentDifferenceReason	Reason Code
	VATRegistration		VATRegistration	VAT Registration No.
	Reference1IDByBusinessPartner		Reference1IDByBusinessPartner	Reference Key 1
	Reference2IDByBusinessPartner		Reference2IDByBusinessPartner	Reference Key 2
	Reference3IDByBusinessPartner		Reference3IDByBusinessPartner	Reference Key 3
	SupplyingCountry		SupplyingCountry	Supplying Ctry/Reg.
	StateCentralBankPaymentReason		StateCentralBankPaymentReason	SCB Ind.
	PaymentReason		PaymentReason	Payment Reason
	BusinessPlace		BusinessPlace	Business place
	PaymentCurrency		PaymentCurrency	Payment Currency
	TaxSection		TaxSection	Tax Section
	BusinessArea		BusinessArea	Business Area
	Fund		Fund	Sender Fund
	BudgetPeriod		BudgetPeriod	Budget Period
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	FinancialTransactionType		FinancialTransactionType	Transact. Type
	CashDiscountAmount		CashDiscountAmount	CD Amount
	AmountInPaymentCurrency		AmountInPaymentCurrency	Amount in Payment Currency
	ControllingArea		ControllingArea	Controlling Area
	CostCenter		CostCenter	Cost Center
	FixedAsset		FixedAsset	Sub-number
	OrderID		OrderID	Order ID
	OrderInternalBillOfOperations		OrderInternalBillOfOperations	Order Internal Bill of Operations
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	ProjectNetwork		ProjectNetwork	Order
	ProfitCenter		ProfitCenter	Profit Center
	Segment		Segment	Segment number
	SalesDocument		SalesDocument	SD Document
	SalesDocumentItem		SalesDocumentItem	Sales Document Item
	LineItemIsCompleted		LineItemIsCompleted	Item Completed
	ScheduleLine		ScheduleLine	Schedule Line
	TargetSpecialGLCode		TargetSpecialGLCode	Trg.Sp.G/L Ind.
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	AccountingDocumentItem		AccountingDocumentItem	Posting View Item
	Supplier		Supplier	Supplier
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	TransactionCurrency		TransactionCurrency	Transaction Currency
	DocumentItemText		DocumentItemText	Text
	AssignmentReference		AssignmentReference	Assignment Reference
	BPBankAccountInternalID		BPBankAccountInternalID	BP Bank Account
	TaxCode		TaxCode	Tax Code
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	PaymentReference		PaymentReference	Payment Reference
	DunningArea		DunningArea	Dunning Area
	LastDunningDate		LastDunningDate	Last Dunned
	DunningLevel		DunningLevel	Dunning Level
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	CashDiscount1Percent		CashDiscount1Percent	Disc. Percent 1
	DueCalculationBaseDate		DueCalculationBaseDate	Due Calculation Base Date
	AlternativePayeePayer		AlternativePayeePayer	Alternative Payee/Payer
	PaymentMethod		PaymentMethod	Pymt Meth.
	PaymentMethodSupplement		PaymentMethodSupplement	Pmnt Meth. Sup.
	PaymentBlockingReason		PaymentBlockingReason	Pmnt block
	BranchCode		BranchCode	Branch Code
	DataExchangeInstruction1		DataExchangeInstruction1	Instruction 1
	DataExchangeInstruction2		DataExchangeInstruction2	Instruction 2
	DataExchangeInstruction3		DataExchangeInstruction3	Instruction 3
	DataExchangeInstruction4		DataExchangeInstruction4	Instruction 4
	HouseBank		HouseBank	House Bank
	GLAccount		GLAccount	General Ledger
	HouseBankAccount		HouseBankAccount	House Bank Account
	SpecialGLAccountAssignment		SpecialGLAccountAssignment	Special G/L Assignmt
	DunningBlockingReason		DunningBlockingReason	Set Dunning Block
	DunningKey		DunningKey	Dunning Key
	PaymentDifferenceReason		PaymentDifferenceReason	Reason Code
	VATRegistration		VATRegistration	VAT Registration No.
	Reference1IDByBusinessPartner		Reference1IDByBusinessPartner	Reference Key 1
	Reference2IDByBusinessPartner		Reference2IDByBusinessPartner	Reference Key 2
	Reference3IDByBusinessPartner		Reference3IDByBusinessPartner	Reference Key 3
	SupplyingCountry		SupplyingCountry	Supplying Ctry/Reg.
	StateCentralBankPaymentReason		StateCentralBankPaymentReason	SCB Ind.
	PaymentReason		PaymentReason	Payment Reason
	BusinessPlace		BusinessPlace	Business place
	PaymentCurrency		PaymentCurrency	Payment Currency
	TaxSection		TaxSection	Tax Section
	BusinessArea		BusinessArea	Business Area
	Fund		Fund	Sender Fund
	BudgetPeriod		BudgetPeriod	Budget Period
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	FinancialTransactionType		FinancialTransactionType	Transact. Type
	CashDiscountAmount		CashDiscountAmount	CD Amount
	AmountInPaymentCurrency		AmountInPaymentCurrency	Amount in Payment Currency
	ControllingArea		ControllingArea	Controlling Area
	CostCenter		CostCenter	Cost Center
	FixedAsset		FixedAsset	Sub-number
	OrderID		OrderID	Order ID
	OrderInternalBillOfOperations		OrderInternalBillOfOperations	Order Internal Bill of Operations
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	ProjectNetwork		ProjectNetwork	Order
	ProfitCenter		ProfitCenter	Profit Center
	Segment		Segment	Segment number
	SalesDocument		SalesDocument	SD Document
	SalesDocumentItem		SalesDocumentItem	Sales Document Item
	LineItemIsCompleted			Item Completed
	ScheduleLine		ScheduleLine	Schedule Line
	TargetSpecialGLCode		TargetSpecialGLCode	Trg.Sp.G/L Ind.
	WBSElementExternalID	_WBSElementBasicData	WBSElementExternalID	WBS Element External ID

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_DwnPaytReqItem.
-- 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_DwnPaytReqItem AS
SELECT
  cast( SourceCompanyCode as fis_bukrs ) AS CompanyCode,
  SourceFiscalYear AS FiscalYear,
  SourceAccountingDocument AS AccountingDocument,
  SourceAccountingDocumentItem AS AccountingDocumentItem,
  Supplier,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  AmountInTransactionCurrency,
  TransactionCurrency,
  DocumentItemText,
  cast( AssignmentReference as dzuonr) AS AssignmentReference,
  BPBankAccountInternalID,
  TaxCode,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  PaymentReference,
  DunningArea,
  LastDunningDate,
  DunningLevel,
  TaxCountry,
  CashDiscount1Percent,
  DueCalculationBaseDate,
  AlternativePayeePayer,
  PaymentMethod,
  PaymentMethodSupplement,
  PaymentBlockingReason,
  BranchCode,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  HouseBank,
  GLAccount,
  HouseBankAccount,
  SpecialGLAccountAssignment,
  DunningBlockingReason,
  DunningKey,
  PaymentDifferenceReason,
  VATRegistration,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  SupplyingCountry,
  StateCentralBankPaymentReason,
  PaymentReason,
  BusinessPlace,
  PaymentCurrency,
  TaxSection,
  BusinessArea,
  Fund,
  BudgetPeriod,
  FunctionalArea,
  FinancialTransactionType,
  CashDiscountAmount,
  AmountInPaymentCurrency,
  ControllingArea,
  CostCenter,
  FixedAsset,
  OrderID,
  OrderInternalBillOfOperations,
  MasterFixedAsset,
  WBSElementInternalID,
  ProjectNetwork,
  ProfitCenter,
  Segment,
  SalesDocument,
  SalesDocumentItem,
  LineItemIsCompleted,
  ScheduleLine,
  TargetSpecialGLCode,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID
FROM I_ParkedOplAcctgDocPyblsItem
-- UNION ALL with additional select branch(es): I_OperationalAcctgDocItem
;

Depth:

P_DwnPaytReqItem view_entity

I_ParkedOplAcctgDocPyblsItem view_entity
I_OperationalAcctgDocItem view_entity

I_DwnPaytReqItemToBeVerified view_entity
P_DwnPaytReqTotalAmt view_entity