FAC_AD_CDS_TBSL_TYPE_DKS

DDL: FAC_AD_CDS_TBSL_TYPE_DKS SQL: FACADV_TBSL_DKS Type: view

Help View of Posting Key(Acc Type D,K,S)

FAC_AD_CDS_TBSL_TYPE_DKS is a CDS View that provides data about "Help View of Posting Key(Acc Type D,K,S)" in SAP S/4HANA. It reads from 3 data sources (dd07t, tbsl, tbslt) and exposes 18 fields with key fields bschl, spras, umskz, domname, ddlanguage.

Data Sources (3)

SourceAliasJoin Type
dd07t dd07t left_outer
tbsl tbsl from
tbslt tbslt left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_TBSL_DKS view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Help View of Posting Key(Acc Type D,K,S) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY bschl tbsl bschl Posting Key
KEY spras tbslt spras Off. Language
KEY umskz tbslt umskz Special G/L Ind
KEY domname dd07t domname Domain
KEY ddlanguage dd07t ddlanguage Lang.
KEY as4local dd07t as4local Activation State
KEY valpos dd07t valpos Value key
KEY as4vers dd07t as4vers Version
ltext tbslt ltext Text exists
koart tbsl koart Account type
ddtext dd07t ddtext Short text
xumsw tbsl xumsw Sales-Related
xzahl tbsl xzahl Payt Tran.
xsonu tbsl xsonu Special G/L
shkzg tbsl shkzg Returns
stbsl tbsl stbsl Reversal Posting Key
faus1 tbsl faus1 General Data
faus2 tbsl faus2 General Data

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_TBSL_TYPE_DKS.
-- 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_TBSL_DKS

CREATE VIEW FAC_AD_CDS_TBSL_TYPE_DKS AS
SELECT
  tbsl.bschl AS bschl,
  tbslt.spras AS spras,
  tbslt.umskz AS umskz,
  dd07t.domname AS domname,
  dd07t.ddlanguage AS ddlanguage,
  dd07t.as4local AS as4local,
  dd07t.valpos AS valpos,
  dd07t.as4vers AS as4vers,
  tbslt.ltext AS ltext,
  tbsl.koart AS koart,
  dd07t.ddtext AS ddtext,
  tbsl.xumsw AS xumsw,
  tbsl.xzahl AS xzahl,
  tbsl.xsonu AS xsonu,
  tbsl.shkzg AS shkzg,
  tbsl.stbsl AS stbsl,
  tbsl.faus1 AS faus1,
  tbsl.faus2 AS faus2
FROM tbsl
LEFT OUTER JOIN dd07t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tbslt ON /* join condition not captured in parsed metadata */
;