c_sgbt_nte_cds_attr

DDL: C_SGBT_NTE_CDS_ATTR SQL: VCSGBTNTECDSATTR Type: view CONSUMPTION Package: S_GBT_NTE
10 Fields 1 Data Sources 1 Associations 7 OData Services

Zusatzattribute

c_sgbt_nte_cds_attr is a Consumption CDS View that provides data about "Zusatzattribute" in SAP S/4HANA. It reads from 1 data source (i_sgbt_nte_cds_attr) and exposes 10 fields with key field AttrId. It has 1 association to related views. It is exposed through 7 OData services (ASQL_F0702A, ASQL_F3883, ASQL_F4443, ...). Part of development package S_GBT_NTE.

Data Sources (1)

SourceAliasJoin Type
i_sgbt_nte_cds_attr i_sgbt_nte_cds_attr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_Sgbt_Nte_Cds_Apitp _cont $projection.Noteid = _cont.NoteID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VCSGBTNTECDSATTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Zusatzattribute view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

OData Services (7)

ServiceBindingVersionContractRelease
ASQL_F0702A ASQL_F0702A C2 NOT_RELEASED
ASQL_F3883 ASQL_F3883 C2 NOT_RELEASED
ASQL_F4443 ASQL_F4443 C2 NOT_RELEASED
ASQL_F4707 ASQL_F4707 C2 NOT_RELEASED
ASQL_F4709 ASQL_F4709 C2 NOT_RELEASED
ASQL_F4710 ASQL_F4710 C2 NOT_RELEASED
ASQL_F6120 ASQL_F6120 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AttrId AttrId Attribute Value ID
Noteid Noteid Unique ID
AttrPosition AttrPosition Position
AttrValue AttrValue Attribute Value
Creator Creator User ID
Created Created UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Changer Changer Last Changed By
Changed Changed Time Stamp
readonly readonly Yes/No
_cont _cont

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 c_sgbt_nte_cds_attr.
-- 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: VCSGBTNTECDSATTR

CREATE VIEW c_sgbt_nte_cds_attr AS
SELECT
  AttrId,
  Noteid,
  AttrPosition,
  AttrValue,
  Creator,
  Created,
  Changer,
  Changed,
  readonly
FROM i_sgbt_nte_cds_attr
LEFT OUTER JOIN C_Sgbt_Nte_Cds_Apitp AS _cont ON Noteid = _cont.NoteID  -- association [1..1]
;

Learn More