I_CustMgmtMasterAgrmtItem

DDL: I_CUSTMGMTMASTERAGRMTITEM SQL: IMAGRITM Type: view BASIC
16 Fields 1 Data Sources

Master Agreement Item Data

I_CustMgmtMasterAgrmtItem is a Basic CDS View that provides data about "Master Agreement Item Data" in SAP S/4HANA. It reads from 1 data source (crms4d_magr_i) and exposes 16 fields with key fields ServiceObjectType, CustMgmtMasterAgreement, CustMgmtMstrAgrmtItem.

Data Sources (1)

SourceAliasJoin Type
crms4d_magr_i MasterAgrmt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMAGRITM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
EndUserText.label Master Agreement Item Data view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType objtype_h Trans. Cat.
KEY CustMgmtMasterAgreement object_id Transaction ID
KEY CustMgmtMstrAgrmtItem number_int Item Number in Doc.
ServiceDocumentType process_type Type of Data
ServiceDocItemCreationDateTime created_at_i Created On
ServiceDocItemChangedDateTime changed_at_i Changed On
ServiceDocItemCreatedByUser created_by_i Created By
ServiceDocItemChangedByUser changed_by_i Changed By
CustMgmtMstrAgreementItemUUID item_guid Push ItemGU
CustMgmtMasterAgreementUUID header_guid Unique Identifier
Product product_id Simulated Product ID
OriginallyRequestedProduct ordered_prod Product
ServiceDocumentItemObjectType objtype_i Object Type
ParentServiceDocumentItemUUID parent UUID
ServiceDocumentItemDescription description_i Short Text
CustMgmtMstrAgrmtCustomProdID product_id_ma Custom 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 I_CustMgmtMasterAgrmtItem.
-- 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: IMAGRITM

CREATE VIEW I_CustMgmtMasterAgrmtItem AS
SELECT
  objtype_h AS ServiceObjectType,
  object_id AS CustMgmtMasterAgreement,
  number_int AS CustMgmtMstrAgrmtItem,
  process_type AS ServiceDocumentType,
  created_at_i AS ServiceDocItemCreationDateTime,
  changed_at_i AS ServiceDocItemChangedDateTime,
  created_by_i AS ServiceDocItemCreatedByUser,
  changed_by_i AS ServiceDocItemChangedByUser,
  item_guid AS CustMgmtMstrAgreementItemUUID,
  header_guid AS CustMgmtMasterAgreementUUID,
  product_id AS Product,
  ordered_prod AS OriginallyRequestedProduct,
  objtype_i AS ServiceDocumentItemObjectType,
  parent AS ParentServiceDocumentItemUUID,
  description_i AS ServiceDocumentItemDescription,
  product_id_ma AS CustMgmtMstrAgrmtCustomProdID
FROM crms4d_magr_i AS MasterAgrmt
;

Learn More