finoc_spl_ccode

DDL: FINOC_SPL_CCODE SQL: FINOCV_SPL_CC Type: view

Split reconstruction: company codes

finoc_spl_ccode is a CDS View that provides data about "Split reconstruction: company codes" in SAP S/4HANA. It reads from 4 data sources (bvor, fagl_split_actc, bkpf, fins_mig_status) and exposes 3 fields.

Data Sources (4)

SourceAliasJoin Type
bvor b left_outer
fagl_split_actc c left_outer
bkpf h inner
fins_mig_status mig left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINOCV_SPL_CC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Split reconstruction: company codes view

Fields (3)

KeyFieldSource TableSource FieldDescription
bukrs s bukrs Value
gjahr s gjahr Settlement Year
cross_cc

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 finoc_spl_ccode.
-- 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: FINOCV_SPL_CC

CREATE VIEW finoc_spl_ccode AS
SELECT
  s.bukrs AS bukrs,
  s.gjahr AS gjahr,
  case when b.bukrs is not null then 'X' else ' 'end AS cross_cc
INNER JOIN bkpf AS h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fagl_split_actc AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bvor AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fins_mig_status AS mig ON /* join condition not captured in parsed metadata */
;