I_ProcmtCurrentSettingCategory

DDL: I_PROCMTCURRENTSETTINGCATEGORY SQL: ICURSETMMPURCAT Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Procurement Current Setting Category

I_ProcmtCurrentSettingCategory is a Basic CDS View that provides data about "Procurement Current Setting Category" in SAP S/4HANA. It reads from 1 data source (tcurset_pur) and exposes 5 fields with key fields ProcmtCurSttgCatUUID, ProcmtCurrentSettingID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tcurset_pur tcurset_pur from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProcurementCurrentSetting _Item tcurset_pur.c_guid = _Item.ProcmtCurSttgCatUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICURSETMMPURCAT view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Procurement Current Setting Category view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProcmtCurSttgCatUUID tcurset_pur c_guid ID
KEY ProcmtCurrentSettingID tcurset_pur guid UUID 22 char.
sscui_nameendasProcmtCurSttgCatName
sscui_nameendasCustomsProcedureCodeDesc
_Item _Item

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_ProcmtCurrentSettingCategory.
-- 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: ICURSETMMPURCAT

CREATE VIEW I_ProcmtCurrentSettingCategory AS
SELECT
  tcurset_pur.c_guid AS ProcmtCurSttgCatUUID,
  tcurset_pur.guid AS ProcmtCurrentSettingID,
  case when /cfg/ssc_t.spras = $session.system_language then /cfg/ssc_t.sscui_name end as ProcmtCurSttgCatName AS sscui_nameendasProcmtCurSttgCatName,
  case /cfg/ssc_t.spras when 'E' then /cfg/ssc_t.sscui_name end as CustomsProcedureCodeDesc AS sscui_nameendasCustomsProcedureCodeDesc
FROM tcurset_pur
LEFT OUTER JOIN I_ProcurementCurrentSetting AS _Item ON tcurset_pur.c_guid = _Item.ProcmtCurSttgCatUUID  -- association [1..*]
;

Learn More