Fac_Ad_Cds_Apar_Key_U

DDL: FAC_AD_CDS_APAR_TRANSKEY SQL: FACADV_APAR_KEY Type: view

Transation keys for Transfer&Sort AP/AR

Fac_Ad_Cds_Apar_Key_U is a CDS View that provides data about "Transation keys for Transfer&Sort AP/AR" in SAP S/4HANA. It reads from 5 data sources (t044l, t030a, t030a, t030u, t030u) and exposes 13 fields with key fields ktopl, bwber, ktosl, hkont, bwber.

Data Sources (5)

SourceAliasJoin Type
t044l bi2 from
t030a bi3 union_all
t030a t030a inner
t030u t030u inner
t030u t030u inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_APAR_KEY view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Transation keys for Transfer&Sort AP/AR view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ktopl t030u ktopl G/L Chart of Accounts
KEY bwber t030u bwber Valuation Area
KEY ktosl t030u ktosl Transaction
KEY hkont t030u hkont Transfer acct
korrk t030u korrk Adjustment Acct
zielk t030u zielk Target Account
ktopl G/L Chart of Accounts
KEY bwber t030u bwber Valuation Area
KEY ktosl t030u ktosl Transaction
KEY hkont t030u hkont Transfer acct
korrk t030u korrk Adjustment Acct
zielk t030u zielk Target Account
grupp t030a grupp Planning group

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_Apar_Key_U.
-- 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_APAR_KEY

CREATE VIEW Fac_Ad_Cds_Apar_Key_U AS
SELECT
  t030u.ktopl AS ktopl,
  t030u.bwber AS bwber,
  t030u.ktosl AS ktosl,
  t030u.hkont AS hkont,
  t030u.korrk AS korrk,
  t030u.zielk AS zielk,
  bi3.grupp AS grupp
FROM t044l AS bi2
INNER JOIN t030a ON /* join condition not captured in parsed metadata */
INNER JOIN t030u ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): t030a
;