I_SlsGrpOrgUnitIDSlsGrpAssgmt

DDL: I_SLSGRPORGUNITIDSLSGRPASSGMT Type: view BASIC

Sales Group Assigned to Service and SD

I_SlsGrpOrgUnitIDSlsGrpAssgmt is a Basic CDS View that provides data about "Sales Group Assigned to Service and SD" in SAP S/4HANA. It reads from 3 data sources (t77omattsc, t77s0, hrv1222a) and exposes 3 fields with key field SalesGroup. It has 1 association to related views.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
t77omattsc _t77omattsc inner
t77s0 _t77s0 inner
hrv1222a hrv1222a from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SalesOrganizationUnitText _SalesOrganizationUnitText $projection.OrganizationalUnit = _SalesOrganizationUnitText.OrganizationalUnit and _SalesOrganizationUnitText.StartDate <= $session.system_date and _SalesOrganizationUnitText.EndDate >= $session.system_date and _SalesOrganizationUnitText.Language = $session.system_language

Annotations (12)

NameValueLevelField
EndUserText.label Sales Group Assigned to Service and SD view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISGRPORGSGRPSD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SalesGroup
OrganizationalUnit hrv1222a objid
_SalesOrganizationUnitText _SalesOrganizationUnitText 
@EndUserText.label: 'Sales Group Assigned to Service and SD'
@VDM:
{
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl:
{
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel:
{
    usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #CUSTOMIZING}
}
@Metadata:
{
    ignorePropagatedAnnotations: true
}
@ClientHandling:
{
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog:
{
    sqlViewName: 'ISGRPORGSGRPSD',
    compiler.compareFilter: true,
    preserveKey: true
}

define view I_SlsGrpOrgUnitIDSlsGrpAssgmt
  as select from hrv1222a   as hrv1222a
    inner join   t77s0      as _t77s0      on  _t77s0.gsval = hrv1222a.plvar
                                           and _t77s0.grpid = 'PLOGI'
                                           and _t77s0.semid = 'PLOGI'

    inner join   t77omattsc as _t77omattsc on  _t77omattsc.subty    = hrv1222a.subty
                                           and _t77omattsc.scenario = 'SALE'

  association [0..1] to I_SalesOrganizationUnitText as _SalesOrganizationUnitText on  $projection.OrganizationalUnit       = _SalesOrganizationUnitText.OrganizationalUnit
                                                                                  and _SalesOrganizationUnitText.StartDate <= $session.system_date
                                                                                  and _SalesOrganizationUnitText.EndDate   >= $session.system_date
                                                                                  and _SalesOrganizationUnitText.Language  = $session.system_language
{
  key cast( hrv1222a.low as vkgrp ) as SalesGroup,

      hrv1222a.objid                as OrganizationalUnit,

      _SalesOrganizationUnitText
}

where
      hrv1222a.otype    =  'O'
  and hrv1222a.begda    <= $session.system_date
  and hrv1222a.endda    >= $session.system_date
  and hrv1222a.istat    =  '1'
  and hrv1222a.attrib   =  'R3_SA_GRP'
  and hrv1222a.excluded =  ''
  and hrv1222a.low      <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T77OMATTSC",
"T77S0",
"HRV1222A"
],
"ASSOCIATED":
[
"I_SALESORGANIZATIONUNITTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More