fac_ad_cds_account_buv

DDL: FAC_AD_CDS_ACCOUNT_BUV SQL: FACADV_ACC_BUV Type: view

Help View for Account in Trans-Key BUV

fac_ad_cds_account_buv is a CDS View that provides data about "Help View for Account in Trans-Key BUV" in SAP S/4HANA. It reads from 6 data sources and exposes 8 fields with key fields company_code, account, account_type, account, account_type.

Data Sources (6)

SourceAliasJoin Type
kna1 kna1 left_outer
knb1 knb1 union
lfa1 lfa1 left_outer
lfb1 lfb1 union
skb1 skb1 from
t001 t001 left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_ACC_BUV view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Help View for Account in Trans-Key BUV view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY company_code skb1 bukrs Value
KEY account skb1 saknr Stock customer
KEY account_type
KEY account lfb1 lifnr Stock customer
KEY account_type
KEY account knb1 kunnr Stock customer
KEY account_type
description PA text

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 fac_ad_cds_account_buv.
-- 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: FACADV_ACC_BUV

CREATE VIEW fac_ad_cds_account_buv AS
SELECT
  skb1.bukrs AS company_code,
  skb1.saknr AS account,
  'S' AS account_type,
  cast(name1 as abap.char(50)) AS description
FROM skb1
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN kna1 ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): lfb1, knb1
;