fac_ad_cds_t005

DDL: FAC_AD_CDS_T005 SQL: FACADV_T005 Type: view
5 Fields 3 Data Sources

Search Help CDS View for T005

fac_ad_cds_t005 is a CDS View that provides data about "Search Help CDS View for T005" in SAP S/4HANA. It reads from 3 data sources (t005, t005t, t007a) and exposes 5 fields with key fields land1, kalsm, mwskz.

Data Sources (3)

SourceAliasJoin Type
t005 t005 from
t005t t005t left_outer
t007a t007a left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACADV_T005 view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Search Help CDS View for T005 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY land1 t005 land1 Trip Ctry/Reg
KEY kalsm t007a kalsm Search Proced.
KEY mwskz t007a mwskz Tax Code
landx t005t landx Country/Region
natio t005t natio Nationality

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_t005.
-- 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_T005

CREATE VIEW fac_ad_cds_t005 AS
SELECT
  t005.land1 AS land1,
  t007a.kalsm AS kalsm,
  t007a.mwskz AS mwskz,
  t005t.landx AS landx,
  t005t.natio AS natio
FROM t005
LEFT OUTER JOIN t007a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t ON /* join condition not captured in parsed metadata */
;

Learn More