I_ServiceTeam

DDL: I_SERVICETEAM Type: view BASIC

Service Team

I_ServiceTeam is a Basic CDS View that provides data about "Service Team" in SAP S/4HANA. It reads from 2 data sources (hrv1222a, I_BusinessPartner) and exposes 18 fields with key field BusinessPartner.

Data Sources (2)

SourceAliasJoin Type
hrv1222a _Attrib inner
I_BusinessPartner I_BusinessPartner from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISERVICETEAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Service Team view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName I_BusinessPartner BusinessPartnerName Extracted Customer Name
OrganizationBPName1 I_BusinessPartner OrganizationBPName1 Name 1
OrganizationBPName2 I_BusinessPartner OrganizationBPName2 Name 2
AuthorizationGroup I_BusinessPartner AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted Purpose Completed
DataControllerSet I_BusinessPartner DataControllerSet Data Ctrlr. Set
DataController1 I_BusinessPartner DataController1 Data Controller
DataController2 I_BusinessPartner DataController2 Data Controller
DataController3 I_BusinessPartner DataController3 Data Controller
DataController4 I_BusinessPartner DataController4 Data Controller
DataController5 I_BusinessPartner DataController5 Data Controller
DataController6 I_BusinessPartner DataController6 Data Controller
DataController7 I_BusinessPartner DataController7 Data Controller
DataController8 I_BusinessPartner DataController8 Data Controller
DataController9 I_BusinessPartner DataController9 Data Controller
DataController10 I_BusinessPartner DataController10 Data Controller
_CurrentDefaultAddress I_BusinessPartner _CurrentDefaultAddress

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_ServiceTeam.
-- 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.

CREATE VIEW I_ServiceTeam AS
SELECT
  I_BusinessPartner.BusinessPartner AS BusinessPartner,
  I_BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  I_BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  I_BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  I_BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  I_BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_BusinessPartner.DataControllerSet AS DataControllerSet,
  I_BusinessPartner.DataController1 AS DataController1,
  I_BusinessPartner.DataController2 AS DataController2,
  I_BusinessPartner.DataController3 AS DataController3,
  I_BusinessPartner.DataController4 AS DataController4,
  I_BusinessPartner.DataController5 AS DataController5,
  I_BusinessPartner.DataController6 AS DataController6,
  I_BusinessPartner.DataController7 AS DataController7,
  I_BusinessPartner.DataController8 AS DataController8,
  I_BusinessPartner.DataController9 AS DataController9,
  I_BusinessPartner.DataController10 AS DataController10,
  I_BusinessPartner._CurrentDefaultAddress AS _CurrentDefaultAddress
FROM I_BusinessPartner
INNER JOIN hrv1222a AS _Attrib ON /* join condition not captured in parsed metadata */
;