A_CharcAttribSeldCodeSet

DDL: A_CHARCATTRIBSELDCODESET SQL: ACHATTRSELCSET Type: view BASIC
10 Fields 1 Data Sources 3 Associations

Characteristic Attribute Selected Sets

A_CharcAttribSeldCodeSet is a Basic CDS View that provides data about "Characteristic Attribute Selected Sets" in SAP S/4HANA. It reads from 1 data source (I_CharcAttribSelectedCodeSet) and exposes 10 fields with key fields SelectedCodeSetPlant, SelectedCodeSet. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CharcAttribSelectedCodeSet I_CharcAttribSelectedCodeSet from

Associations (3)

CardinalityTargetAliasCondition
[0..*] A_CharcAttribSeldSetCode _CharcAttribSeldSetCode
[0..*] A_CharcAttribSeldSetCodeT _CharcAttribSeldSetCodeT
[0..*] A_CharcAttribSeldSetT _CharcAttribSeldSetT

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACHATTRSELCSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Attribute Selected Sets view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant I_CharcAttribSelectedCodeSet SelectedCodeSetPlant Receiving Plant
KEY SelectedCodeSet I_CharcAttribSelectedCodeSet SelectedCodeSet CodeGrp/SelSet
InspectionSelectedSetStatus I_CharcAttribSelectedCodeSet InspectionSelectedSetStatus Workflow Status
CharcAttribSeldSetCreatedBy I_CharcAttribSelectedCodeSet CharcAttribSeldSetCreatedBy Created By
CharcAttribSeldSetCrtedOn I_CharcAttribSelectedCodeSet CharcAttribSeldSetCrtedOn Creation Date
CharcAttribSeldSetLastChgdBy I_CharcAttribSelectedCodeSet CharcAttribSeldSetLastChgdBy Changed By
CharcAttribSeldSetLastChgdOn I_CharcAttribSelectedCodeSet CharcAttribSeldSetLastChgdOn Changed On
_CharcAttribSeldSetCode _CharcAttribSeldSetCode
_CharcAttribSeldSetCodeT _CharcAttribSeldSetCodeT
_CharcAttribSeldSetT _CharcAttribSeldSetT

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 A_CharcAttribSeldCodeSet.
-- 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: ACHATTRSELCSET

CREATE VIEW A_CharcAttribSeldCodeSet AS
SELECT
  I_CharcAttribSelectedCodeSet.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  I_CharcAttribSelectedCodeSet.SelectedCodeSet AS SelectedCodeSet,
  I_CharcAttribSelectedCodeSet.InspectionSelectedSetStatus AS InspectionSelectedSetStatus,
  I_CharcAttribSelectedCodeSet.CharcAttribSeldSetCreatedBy AS CharcAttribSeldSetCreatedBy,
  I_CharcAttribSelectedCodeSet.CharcAttribSeldSetCrtedOn AS CharcAttribSeldSetCrtedOn,
  I_CharcAttribSelectedCodeSet.CharcAttribSeldSetLastChgdBy AS CharcAttribSeldSetLastChgdBy,
  I_CharcAttribSelectedCodeSet.CharcAttribSeldSetLastChgdOn AS CharcAttribSeldSetLastChgdOn
FROM I_CharcAttribSelectedCodeSet
LEFT OUTER JOIN A_CharcAttribSeldSetCode AS _CharcAttribSeldSetCode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_CharcAttribSeldSetCodeT AS _CharcAttribSeldSetCodeT ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_CharcAttribSeldSetT AS _CharcAttribSeldSetT ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More