FAA_ACCT_ASSIGN_OBJ

DDL: FAA_ACCT_ASSIGN_OBJ SQL: FAAV_ACCT_ASSIGN Type: view

FIAA account determination objects

FAA_ACCT_ASSIGN_OBJ is a CDS View that provides data about "FIAA account determination objects" in SAP S/4HANA. It reads from 4 data sources (faa_bf_active, faa_bf_active, t093_accobjt, faac_acctasn0_t) and exposes 5 fields with key field ACCT_ASSIGN_OBJ.

Data Sources (4)

SourceAliasJoin Type
faa_bf_active bf_status inner
faa_bf_active bf_status inner
t093_accobjt t left_outer
faac_acctasn0_t t left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ACCT_ASSIGN view
EndUserText.label FIAA account determination objects view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ACCT_ASSIGN_OBJ v1 aaaccobj AcctAssgnObject
AAACCOBJ v1 aaaccobj AcctAssgnObject
acct_assign_objasACCT_ASSIGN_OBJ
AAACCOBJ v1 acct_assign_obj AcctAssgnObject
description_shortasDESCRIPTION_SHORT

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_ACCT_ASSIGN_OBJ.
-- 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_ACCT_ASSIGN

CREATE VIEW FAA_ACCT_ASSIGN_OBJ AS
SELECT
  v1.aaaccobj AS ACCT_ASSIGN_OBJ,
  v1.aaaccobj AS AAACCOBJ
INNER JOIN faa_bf_active AS bf_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093_accobjt AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN faac_acctasn0_t AS t ON /* join condition not captured in parsed metadata */
;