faa_comp_code_bf_off

DDL: FAA_COMP_CODE_BF_OFF SQL: FAAV_COMP_CODE_O Type: view
3 Fields 1 Data Sources

Asset CompCodes in FIN_AA_CONFIG_REDESIGN_1 BF-OFF Scenario

faa_comp_code_bf_off is a CDS View that provides data about "Asset CompCodes in FIN_AA_CONFIG_REDESIGN_1 BF-OFF Scenario" in SAP S/4HANA. It reads from 1 data source (faa_bf_active) and exposes 3 fields with key fields client, comp_code.

Data Sources (1)

SourceAliasJoin Type
faa_bf_active bf_status left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_COMP_CODE_O view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Asset CompCodes in FIN_AA_CONFIG_REDESIGN_1 BF-OFF Scenario view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY client t093c mandt Editing Client
KEY comp_code t093c bukrs Value
depr_chart t093c afapl Chart of Depr.

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 faa_comp_code_bf_off.
-- 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: FAAV_COMP_CODE_O

CREATE VIEW faa_comp_code_bf_off AS
SELECT
  t093c.mandt AS client,
  t093c.bukrs AS comp_code,
  t093c.afapl AS depr_chart
LEFT OUTER JOIN faa_bf_active AS bf_status ON /* join condition not captured in parsed metadata */
;

Learn More