P_EBPPARItem
EBPP AR Item
P_EBPPARItem is a Composite CDS View that provides data about "EBPP AR Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 101 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package FINS_AR_CCP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_OperationalAcctgDocItem | I_OperationalAcctgDocItem | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (101)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | CompanyCode | Receiver Company Code | |
| KEY | AccountingDocument | AccountingDocument | Journal Entry | |
| KEY | FiscalYear | FiscalYear | G/L Fiscal Year | |
| KEY | AccountingDocumentItem | AccountingDocumentItem | Posting View Item | |
| AccountingDocumentItemType | AccountingDocumentItemType | Line Item ID | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingCreationDate | ClearingCreationDate | Clrg Creation Date | ||
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| ClearingJournalEntry | ClearingJournalEntry | Clrng doc. | ||
| PostingKey | PostingKey | Posting Key | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| SpecialGLCode | SpecialGLCode | Special G/L Ind | ||
| SpecialGLTransactionType | SpecialGLTransactionType | Transact.Type | ||
| DebitCreditCode | DebitCreditCode | Single-Character Flag | ||
| BusinessArea | BusinessArea | Business Area | ||
| TaxCode | TaxCode | Tax Code | ||
| WithholdingTaxCode | WithholdingTaxCode | WTax Code | ||
| AssignmentReference | AssignmentReference | Assignment Reference | ||
| DocumentItemText | DocumentItemText | Text | ||
| CostCenter | CostCenter | Cost Center | ||
| OrderID | OrderID | Order ID | ||
| BillingDocument | BillingDocument | SD Document | ||
| SalesDocument | SalesDocument | SD Document | ||
| SalesDocumentItem | SalesDocumentItem | Sales Document Item | ||
| MasterFixedAsset | MasterFixedAsset | Fixed Asset | ||
| FixedAsset | FixedAsset | Sub-number | ||
| IsSalesRelated | IsSalesRelated | Is Sales Related | ||
| DownPaymentIsNetProcedure | DownPaymentIsNetProcedure | Indicator: Down Payment in Net Procedure? | ||
| IsUsedInPaymentTransaction | IsUsedInPaymentTransaction | Is Used In Payment Transaction | ||
| OperationalGLAccount | OperationalGLAccount | Operational G/L Acct | ||
| GLAccount | GLAccount | General Ledger | ||
| Customer | Customer | Sold-to Party | ||
| BranchAccount | BranchAccount | Branch Account No. | ||
| DueCalculationBaseDate | DueCalculationBaseDate | Due Calculation Base Date | ||
| PaymentTerms | PaymentTerms | Pyt Terms | ||
| CashDiscount1Days | CashDiscount1Days | Days from Baseline Date for Payment | ||
| CashDiscount2Days | CashDiscount2Days | Days from Baseline Date for Payment | ||
| NetPaymentDays | NetPaymentDays | Net Pmt Terms Period | ||
| CashDiscount1Percent | CashDiscount1Percent | Disc. Percent 1 | ||
| CashDiscount2Percent | CashDiscount2Percent | Disc. Percent 2 | ||
| CashDiscount1DueDate | CashDiscount1DueDate | Cash Discount 1 | ||
| CashDiscount2DueDate | CashDiscount2DueDate | Cash Discount 2 | ||
| NetDueDate | NetDueDate | Net Due Date | ||
| PaymentMethod | PaymentMethod | Pymt Meth. | ||
| PaymentBlockingReason | PaymentBlockingReason | Pmnt block | ||
| FixedCashDiscount | FixedCashDiscount | Fixed Cash Discount | ||
| HouseBank | HouseBank | House Bank | ||
| BPBankAccountInternalID | BPBankAccountInternalID | BP Bank Account | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | ||
| InvoiceItemReference | InvoiceItemReference | Item | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| DunningKey | DunningKey | Dunning Key | ||
| DunningBlockingReason | DunningBlockingReason | Set Dunning Block | ||
| LastDunningDate | LastDunningDate | Last Dunned | ||
| DunningLevel | DunningLevel | Dunning Level | ||
| DunningArea | DunningArea | Dunning Area | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| ClearingIsReversed | ClearingIsReversed | Clearing Is Reversed | ||
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | Reference Key 1 | ||
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | Reference Key 2 | ||
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | Reference Key 3 | ||
| IsNegativePosting | IsNegativePosting | Negative Posting | ||
| PaymentCardItem | PaymentCardItem | Payment Card Item | ||
| HasPaymentOrder | HasPaymentOrder | Payment Sent | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| PaymentServiceProvider | PaymentServiceProvider | Payt Srvc Provider | ||
| PaymentRefByPaytSrvcProvider | PaymentRefByPaytSrvcProvider | Reference by PSP | ||
| DigitalPaymentType | DigitalPaymentType | Payment Type | ||
| PaymentByDigitalPaymentService | PaymentByDigitalPaymentService | Transaction/Payt ID | ||
| ReferenceDocumentType | ReferenceDocumentType | Reference Document Type | ||
| OriginalReferenceDocument | OriginalReferenceDocument | Reference Key | ||
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | Ref. Doc. Lgcl Syst. | ||
| FiscalPeriod | FiscalPeriod | Tax period | ||
| AccountingDocumentCategory | AccountingDocumentCategory | Journal Entry Category | ||
| PostingDate | PostingDate | Posting Date for GR | ||
| DocumentDate | DocumentDate | Journal Entry Date | ||
| AccountingDocumentType | AccountingDocumentType | Journal Entry Type | ||
| OffsettingAccount | OffsettingAccount | Offsetting Acct | ||
| OffsettingAccountType | OffsettingAccountType | Offset Acct Type | ||
| CompanyCodeCurrency | CompanyCodeCurrency | Local Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Local Crcy Amt | ||
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | Tax Amount in Company Code Currency | ||
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | Discount Amt | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| AmountInTransactionCurrency | AmountInTransactionCurrency | Pt Crcy Amt | ||
| TaxAmount | TaxAmount | Tax Amt in Rptg Crcy | ||
| CashDiscountAmount | CashDiscountAmount | CD Amount | ||
| CashDiscountBaseAmount | CashDiscountBaseAmount | Cash Dscnt Base Amt | ||
| NetPaymentAmount | NetPaymentAmount | Net Payment Amount | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| AdditionalCurrency1 | AdditionalCurrency1 | Local curr. 2 | ||
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | Amount in Additional Currency 1 | ||
| TaxAmountInAdditionalCurrency1 | TaxAmountInAdditionalCurrency1 | LC 2 Tax | ||
| AdditionalCurrency2 | AdditionalCurrency2 | Local curr. 3 | ||
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | LC2 Amount | ||
| TaxAmountInAdditionalCurrency2 | TaxAmountInAdditionalCurrency2 | LC 3 Tax | ||
| PaymentCurrency | PaymentCurrency | Payment Currency | ||
| AmountInPaymentCurrency | AmountInPaymentCurrency | Amount in Payment Currency | ||
| user_dateendasValueDate |
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_EBPPARItem.
-- 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_EBPPARItem AS
SELECT
CompanyCode,
AccountingDocument,
FiscalYear,
AccountingDocumentItem,
AccountingDocumentItemType,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntryFiscalYear,
ClearingJournalEntry,
PostingKey,
FinancialAccountType,
SpecialGLCode,
SpecialGLTransactionType,
DebitCreditCode,
BusinessArea,
TaxCode,
WithholdingTaxCode,
AssignmentReference,
DocumentItemText,
CostCenter,
OrderID,
BillingDocument,
SalesDocument,
SalesDocumentItem,
MasterFixedAsset,
FixedAsset,
IsSalesRelated,
DownPaymentIsNetProcedure,
IsUsedInPaymentTransaction,
OperationalGLAccount,
GLAccount,
Customer,
BranchAccount,
DueCalculationBaseDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays,
CashDiscount1Percent,
CashDiscount2Percent,
CashDiscount1DueDate,
CashDiscount2DueDate,
NetDueDate,
PaymentMethod,
PaymentBlockingReason,
FixedCashDiscount,
HouseBank,
BPBankAccountInternalID,
InvoiceReference,
InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType,
DunningKey,
DunningBlockingReason,
LastDunningDate,
DunningLevel,
DunningArea,
ProfitCenter,
ClearingIsReversed,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
Reference3IDByBusinessPartner,
IsNegativePosting,
PaymentCardItem,
HasPaymentOrder,
FunctionalArea,
PaymentServiceProvider,
PaymentRefByPaytSrvcProvider,
DigitalPaymentType,
PaymentByDigitalPaymentService,
ReferenceDocumentType,
OriginalReferenceDocument,
ReferenceDocumentLogicalSystem,
FiscalPeriod,
AccountingDocumentCategory,
PostingDate,
DocumentDate,
AccountingDocumentType,
OffsettingAccount,
OffsettingAccountType,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
TaxAmountInCoCodeCrcy,
CashDiscountAmtInCoCodeCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
TaxAmount,
CashDiscountAmount,
CashDiscountBaseAmount,
NetPaymentAmount,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
AdditionalCurrency1,
AmountInAdditionalCurrency1,
TaxAmountInAdditionalCurrency1,
AdditionalCurrency2,
AmountInAdditionalCurrency2,
TaxAmountInAdditionalCurrency2,
PaymentCurrency,
AmountInPaymentCurrency,
case when ClearingDate is not initial then ClearingDate else $session.user_date end as ValueDate AS user_dateendasValueDate
FROM I_OperationalAcctgDocItem
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA