P_EBWAccountDetermination
P_EBWAccountDetermination is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (fcoc_ebw_assg_cc, fcoc_ebw_assg_it, fcoc_ebw_src_cat, fcoc_ebw_src_itm, t001) and exposes 11 fields with key fields CompanyCode, SourceAccountFrom, SourceAccountTo.
Data Sources (5)
| Source | Alias | Join Type |
|---|---|---|
| fcoc_ebw_assg_cc | fcoc_ebw_assg_cc | from |
| fcoc_ebw_assg_it | fcoc_ebw_assg_it | inner |
| fcoc_ebw_src_cat | fcoc_ebw_src_cat | inner |
| fcoc_ebw_src_itm | fcoc_ebw_src_itm | inner |
| t001 | t001 | inner |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PFIEBWACCTDETMN | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (11)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | fcoc_ebw_assg_cc | company_code | Company Code |
| KEY | SourceAccountFrom | fcoc_ebw_src_itm | account_from | From Account Number |
| KEY | SourceAccountTo | fcoc_ebw_src_itm | account_to | Up to Account No. |
| ChartOfAccount | t001 | ktopl | G/L Chart of Accounts | |
| AssignmentID | fcoc_ebw_assg_cc | assgmt_id | WIP Accnt Determ | |
| SourceCategory | fcoc_ebw_src_cat | category | Violation Category | |
| WIPSourceID | fcoc_ebw_src_cat | source_id | UUID | |
| WIPAccount | fcoc_ebw_assg_it | wip_bs_acct | WIP (B/S Acct) | |
| ReservesAccount | fcoc_ebw_assg_it | rsrv_bs_acct | Reserves (B/S Acct) | |
| WIPOffsettingAccount | fcoc_ebw_assg_it | wip_pl_acct | WIP Offset (P/L) | |
| RsrvOffsettingAccount | fcoc_ebw_assg_it | rsrv_pl_acct | Rsrvs Offset (P/L) |
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_EBWAccountDetermination.
-- 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: PFIEBWACCTDETMN
CREATE VIEW P_EBWAccountDetermination AS
SELECT
fcoc_ebw_assg_cc.company_code AS CompanyCode,
fcoc_ebw_src_itm.account_from AS SourceAccountFrom,
fcoc_ebw_src_itm.account_to AS SourceAccountTo,
t001.ktopl AS ChartOfAccount,
fcoc_ebw_assg_cc.assgmt_id AS AssignmentID,
fcoc_ebw_src_cat.category AS SourceCategory,
fcoc_ebw_src_cat.source_id AS WIPSourceID,
fcoc_ebw_assg_it.wip_bs_acct AS WIPAccount,
fcoc_ebw_assg_it.rsrv_bs_acct AS ReservesAccount,
fcoc_ebw_assg_it.wip_pl_acct AS WIPOffsettingAccount,
fcoc_ebw_assg_it.rsrv_pl_acct AS RsrvOffsettingAccount
FROM fcoc_ebw_assg_cc
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
INNER JOIN fcoc_ebw_assg_it ON /* join condition not captured in parsed metadata */
INNER JOIN fcoc_ebw_src_itm ON /* join condition not captured in parsed metadata */
INNER JOIN fcoc_ebw_src_cat ON /* join condition not captured in parsed metadata */
;
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