What is P_Arbsitmopenitem in SAP S/4HANA?

P_Arbsitmopenitem is a composite CDS view in SAP S/4HANA. It contains 54 fields.

Which tables does P_Arbsitmopenitem read from?

P_Arbsitmopenitem reads data from: adrc, P_ARBSITMCOMPANY, I_Customer, I_ReceivablesPayablesItem, I_Supplier.

What VDM layer is P_Arbsitmopenitem?

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

P_Arbsitmopenitem

DDL: P_ARBSITMOPENITEM SQL: PARBSITMOI Type: view COMPOSITE

54 Fields 5 Data Sources

P_Arbsitmopenitem is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (adrc, P_ARBSITMCOMPANY, I_Customer, I_ReceivablesPayablesItem, I_Supplier) and exposes 54 fields.

Data Sources (5)

Source	Alias	Join Type
adrc	Address	left_outer
P_ARBSITMCOMPANY	CompanyCtryKey	left_outer
I_Customer	cust	left_outer
I_ReceivablesPayablesItem	OpenItem	from
I_Supplier	supl	left_outer

Parameters (1)

Name	Type	Default
P_FinAccTyp	koart

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PARBSITMOI	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (54)

Field	Source Table	Source Field	Description
CompanyCode	I_ReceivablesPayablesItem	CompanyCode	Receiver Company Code
CountryKey	P_ARBSITMCOMPANY	CountryKey	Country/Reg.
FiscalYear	I_ReceivablesPayablesItem	FiscalYear	G/L Fiscal Year
AccountingDocument	I_ReceivablesPayablesItem	AccountingDocument	Journal Entry
AccountingDocumentItem	I_ReceivablesPayablesItem	AccountingDocumentItem	Posting View Item
AccountingDocumentType	I_ReceivablesPayablesItem	AccountingDocumentType	Journal Entry Type
PostingDate	I_ReceivablesPayablesItem	PostingDate	Posting Date for GR
DocumentReferenceID
AssignmentReference	I_ReceivablesPayablesItem	AssignmentReference	Assignment Reference
PaymentReference	I_ReceivablesPayablesItem	PaymentReference	Payment Reference
BillingDocument	I_ReceivablesPayablesItem	BillingDocument	SD Document
ClearingDocFiscalYear	I_ReceivablesPayablesItem	ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry
ClearingAccountingDocument	I_ReceivablesPayablesItem	ClearingAccountingDocument	Clearing Journal Entry
ClearingDate	I_ReceivablesPayablesItem	ClearingDate	Clearing Date
CompanyCodeCurrency	I_ReceivablesPayablesItem	CompanyCodeCurrency	Local Currency
TransactionCurrency	I_ReceivablesPayablesItem	TransactionCurrency	Transaction Currency
AmountInCompanyCodeCurrency	I_ReceivablesPayablesItem	AmountInCompanyCodeCurrency	Local Crcy Amt
AmountInTransactionCurrency	I_ReceivablesPayablesItem	AmountInTransactionCurrency	Pt Crcy Amt
TaxAmountInCoCodeCrcy	I_ReceivablesPayablesItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
TaxAmount	I_ReceivablesPayablesItem	TaxAmount	Tax Amt in Rptg Crcy
CashDiscountAmtInCoCodeCrcy	I_ReceivablesPayablesItem	CashDiscountAmtInCoCodeCrcy	Discount Amt
CashDiscountAmount	I_ReceivablesPayablesItem	CashDiscountAmount	CD Amount
DebitCreditCode	I_ReceivablesPayablesItem	DebitCreditCode	Single-Character Flag
DocumentItemText	I_ReceivablesPayablesItem	DocumentItemText	Text
FinancialAccountType	I_ReceivablesPayablesItem	FinancialAccountType	Fin. Account Type
InvoiceReference	I_ReceivablesPayablesItem	InvoiceReference	Invoice Reference
InvoiceReferenceFiscalYear	I_ReceivablesPayablesItem	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
InvoiceItemReference	I_ReceivablesPayablesItem	InvoiceItemReference	Item
FollowOnDocumentType	I_ReceivablesPayablesItem	FollowOnDocumentType	Follow-On Document Type
Debtor
OrganizationBPName1
OrganizationBPName2
OrganizationBPName3
OrganizationBPName4
CityName
Country
AccountingDocumentHeaderText
PartnerCompany	I_ReceivablesPayablesItem	PartnerCompany	Trading Partner
NetDueDate	I_ReceivablesPayablesItem	NetDueDate	Net Due Date
CashDiscount1Percent	I_ReceivablesPayablesItem	CashDiscount1Percent	Disc. Percent 1
CashDiscount1DueDate	I_ReceivablesPayablesItem	CashDiscount1DueDate	Cash Discount 1
CashDiscount2Percent	I_ReceivablesPayablesItem	CashDiscount2Percent	Disc. Percent 2
CashDiscount2DueDate	I_ReceivablesPayablesItem	CashDiscount2DueDate	Cash Discount 2
Reference1IDByBusinessPartner	I_ReceivablesPayablesItem	Reference1IDByBusinessPartner	Reference Key 1
Reference2IDByBusinessPartner	I_ReceivablesPayablesItem	Reference2IDByBusinessPartner	Reference Key 2
Reference3IDByBusinessPartner	I_ReceivablesPayablesItem	Reference3IDByBusinessPartner	Reference Key 3
SpecialGLCode	I_ReceivablesPayablesItem	SpecialGLCode	Special G/L Ind
ReceivableKey
nation	adrc	nation	Country/Region
name1	adrc	name1	PA text
name2	adrc	name2	Name2/First nme
name3	adrc	name3	Name 3
name4	adrc	name4	Name 4
CustomerFullName	I_Customer	CustomerFullName	Customer Name

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_Arbsitmopenitem.
-- 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: PARBSITMOI
-- Parameters: P_FinAccTyp : koart

CREATE VIEW P_Arbsitmopenitem AS
SELECT
  OpenItem.CompanyCode AS CompanyCode,
  CompanyCtryKey.CountryKey AS CountryKey,
  OpenItem.FiscalYear AS FiscalYear,
  OpenItem.AccountingDocument AS AccountingDocument,
  OpenItem.AccountingDocumentItem AS AccountingDocumentItem,
  OpenItem.AccountingDocumentType AS AccountingDocumentType,
  OpenItem.PostingDate AS PostingDate,
  OpenItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  OpenItem.AssignmentReference AS AssignmentReference,
  OpenItem.PaymentReference AS PaymentReference,
  OpenItem.BillingDocument AS BillingDocument,
  OpenItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  OpenItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  OpenItem.ClearingDate AS ClearingDate,
  OpenItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  OpenItem.TransactionCurrency AS TransactionCurrency,
  OpenItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OpenItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  OpenItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  OpenItem.TaxAmount AS TaxAmount,
  OpenItem.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  OpenItem.CashDiscountAmount AS CashDiscountAmount,
  OpenItem.DebitCreditCode AS DebitCreditCode,
  OpenItem.DocumentItemText AS DocumentItemText,
  OpenItem.FinancialAccountType AS FinancialAccountType,
  OpenItem.InvoiceReference AS InvoiceReference,
  OpenItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OpenItem.InvoiceItemReference AS InvoiceItemReference,
  OpenItem.FollowOnDocumentType AS FollowOnDocumentType,
  case when OpenItem.FinancialAccountType='K' then OpenItem.Creditor else OpenItem.Debtor end AS Debtor,
  case when OpenItem.FinancialAccountType='K' then OpenItem._Supplier.OrganizationBPName1 else OpenItem._Customer.OrganizationBPName1 end AS OrganizationBPName1,
  case when OpenItem.FinancialAccountType='K' then OpenItem._Supplier.OrganizationBPName2 else OpenItem._Customer.OrganizationBPName2 end AS OrganizationBPName2,
  '' AS OrganizationBPName3,
  '' AS OrganizationBPName4,
  case when OpenItem.FinancialAccountType='K' then OpenItem._Supplier.CityName else OpenItem._Customer.CityName end AS CityName,
  case when OpenItem.FinancialAccountType='K' then OpenItem._Supplier.Country else OpenItem._Customer.Country end AS Country,
  OpenItem._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  OpenItem.PartnerCompany AS PartnerCompany,
  OpenItem.NetDueDate AS NetDueDate,
  OpenItem.CashDiscount1Percent AS CashDiscount1Percent,
  OpenItem.CashDiscount1DueDate AS CashDiscount1DueDate,
  OpenItem.CashDiscount2Percent AS CashDiscount2Percent,
  OpenItem.CashDiscount2DueDate AS CashDiscount2DueDate,
  OpenItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  OpenItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  OpenItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  OpenItem.SpecialGLCode AS SpecialGLCode,
  cast('' as abap.sstring( 64)) AS ReceivableKey,
  Address.nation AS nation,
  Address.name1 AS name1,
  Address.name2 AS name2,
  Address.name3 AS name3,
  Address.name4 AS name4,
  cust.CustomerFullName AS CustomerFullName
FROM I_ReceivablesPayablesItem AS OpenItem
LEFT OUTER JOIN I_Customer AS cust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS supl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS Address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ARBSITMCOMPANY AS CompanyCtryKey ON /* join condition not captured in parsed metadata */
;

Depth:

P_Arbsitmopenitem view