I_SiteProfile

DDL: I_SITEPROFILE SQL: ISITEPROFILE Type: view BASIC
6 Fields 1 Data Sources

CDS view for Site Profile

I_SiteProfile is a Basic CDS View that provides data about "CDS view for Site Profile" in SAP S/4HANA. It reads from 1 data source (twrf2) and exposes 6 fields with key field SiteProfile.

Data Sources (1)

SourceAliasJoin Type
twrf2 twrf2 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITEPROFILE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view for Site Profile view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SiteProfile betrp Plant profile
ReferenceSite ref_wkfil Plant
SiteCategory vlfkz Plant Cat.
SiteIsWithSupplier site_with_bp_grp_suppl With Supp.
BusinessPartnerGrouping bp_grp_site BP Grouping
BusinessPartnerRoleGrouping rltgr Role Grouping

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 I_SiteProfile.
-- 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: ISITEPROFILE

CREATE VIEW I_SiteProfile AS
SELECT
  betrp AS SiteProfile,
  ref_wkfil AS ReferenceSite,
  vlfkz AS SiteCategory,
  site_with_bp_grp_suppl AS SiteIsWithSupplier,
  bp_grp_site AS BusinessPartnerGrouping,
  rltgr AS BusinessPartnerRoleGrouping
FROM twrf2
;

Learn More