CRMS4_REF_OBJECT

DDL: CRMS4_REF_OBJECT SQL: CRMS4_REFOBJ Type: view
10 Fields 1 Data Sources

Reference Object for Service Item

CRMS4_REF_OBJECT is a CDS View that provides data about "Reference Object for Service Item" in SAP S/4HANA. It reads from 1 data source (crms4d_refobj) and exposes 10 fields with key fields objtype_h, object_id, number_int, counter.

Data Sources (1)

SourceAliasJoin Type
crms4d_refobj crms4d_refobj from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4_REFOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Reference Object for Service Item view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY objtype_h objtype_h Trans. Cat.
KEY object_id object_id Transaction ID
KEY number_int number_int Item Number in Doc.
KEY counter counter Version
type_object type_object Object Type
guid_object guid_object Object GUID
product_id product_id Simulated Product ID
main_object main_object Main Object
product_guid product_guid Product
equipment_id equipment_id Equipment ID

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 CRMS4_REF_OBJECT.
-- 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: CRMS4_REFOBJ

CREATE VIEW CRMS4_REF_OBJECT AS
SELECT
  objtype_h,
  object_id,
  number_int,
  counter,
  type_object,
  guid_object,
  product_id,
  main_object,
  product_guid,
  equipment_id
FROM crms4d_refobj
;

Learn More