P_EBWAccountDetermination

DDL: P_EBWACCOUNTDETERMINATION SQL: PFIEBWACCTDETMN Type: view BASIC

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)

SourceAliasJoin 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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 */
;