I_CustomerAccountAssgmtGroup

DDL: I_CUSTOMERACCOUNTASSGMTGROUP SQL: ISDCUSACCASSGRP Type: view BASIC
2 Fields 1 Data Sources 1 Associations 1 OData Services

Customer Account Assignment Group

I_CustomerAccountAssgmtGroup is a Basic CDS View (Dimension) that provides data about "Customer Account Assignment Group" in SAP S/4HANA. It reads from 1 data source (tvkt) and exposes 2 fields with key field CustomerAccountAssignmentGroup. It has 1 association to related views. It is exposed through 1 OData service (C_SALESORDERMANAGE_SD).

Data Sources (1)

SourceAliasJoin Type
tvkt tvkt from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CustomerAccountAssgmtGroupT _Text $projection.CustomerAccountAssignmentGroup = _Text.CustomerAccountAssignmentGroup

Annotations (21)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.sapObjectNodeType.name CustomerAccountAssignmentGroup view
ObjectModel.representativeKey CustomerAccountAssignmentGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
EndUserText.label Customer Account Assignment Group view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDCUSACCASSGRP view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CustomerAccountAssignmentGroup ktgrd AccAssmtGrpCust
_Text _Text

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_CustomerAccountAssgmtGroup.
-- 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: ISDCUSACCASSGRP

CREATE VIEW I_CustomerAccountAssgmtGroup AS
SELECT
  ktgrd AS CustomerAccountAssignmentGroup
FROM tvkt
LEFT OUTER JOIN I_CustomerAccountAssgmtGroupT AS _Text ON CustomerAccountAssignmentGroup = _Text.CustomerAccountAssignmentGroup  -- association [0..*]
;

Learn More