I_SpecialProcurementType

DDL: I_SPECIALPROCUREMENTTYPE SQL: ISPCLPROCMTTYPE Type: view BASIC
3 Fields 2 Data Sources

Special Procurement Type for BOM Item

I_SpecialProcurementType is a Basic CDS View that provides data about "Special Procurement Type for BOM Item" in SAP S/4HANA. It reads from 2 data sources (t460a, t460t) and exposes 3 fields with key fields SpecialProcurementType, Plant.

Data Sources (2)

SourceAliasJoin Type
t460a t460a from
t460t t460t inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISPCLPROCMTTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Special Procurement Type for BOM Item view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
ObjectModel.representativeKey SpecialProcurementType view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SpecialProcurementType t460a sobsl SpecProcuremKey
KEY Plant t460a werks Receiving Plant
SpecialProcurementTypeText t460t ltext Text exists

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_SpecialProcurementType.
-- 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: ISPCLPROCMTTYPE

CREATE VIEW I_SpecialProcurementType AS
SELECT
  t460a.sobsl AS SpecialProcurementType,
  t460a.werks AS Plant,
  t460t.ltext AS SpecialProcurementTypeText
FROM t460a
INNER JOIN t460t ON /* join condition not captured in parsed metadata */
;

Learn More