R_IHBGroupAssignmentTP

DDL: R_IHBGROUPASSIGNMENTTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources

IHB Group Assignment - TP

R_IHBGroupAssignmentTP is a Transactional CDS View that provides data about "IHB Group Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_IHBGroupAssignmentComposite) and exposes 15 fields with key field IHBGroupAssignmentUUID.

Data Sources (1)

SourceAliasJoin Type
I_IHBGroupAssignmentComposite I_IHBGroupAssignmentComposite from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label IHB Group Assignment - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey IHBGroupAssignmentUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY IHBGroupAssignmentUUID IHBGroupAssignmentUUID UUID
IHBObjectUUID IHBObjectUUID UUID
IHBGroupAssignmentRefUUID IHBGroupAssignmentRefUUID UUID
IHBObjectCategory IHBObjectCategory Object Category
IHBObjectKeyUUID IHBObjectKeyUUID UUID
IHBAccountNumber _IHBAccount IHBAccountNumber Account Number
IHBGroupAssgmtValidFromDate IHBGroupAssgmtValidFromDate Valid From Date
IHBGroupAssgmtValidToDate IHBGroupAssgmtValidToDate Valid To Date
IHBObjectTotalChangedDateTime IHBObjectTotalChangedDateTime Changed On
IHBObjectCreatedDateTime IHBObjectCreatedDateTime Created At
IHBObjectCreatedByUser IHBObjectCreatedByUser Created By
IHBObjectChangedDateTime IHBObjectChangedDateTime Changed at
IHBObjectChangedByUser IHBObjectChangedByUser Changed by
_IHBMasterDataObjectTP _IHBMasterDataObjectTP
_IHBAccount _IHBAccount

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 R_IHBGroupAssignmentTP.
-- 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.

CREATE VIEW R_IHBGroupAssignmentTP AS
SELECT
  IHBGroupAssignmentUUID,
  IHBObjectUUID,
  IHBGroupAssignmentRefUUID,
  IHBObjectCategory,
  IHBObjectKeyUUID,
  _IHBAccount.IHBAccountNumber AS IHBAccountNumber,
  IHBGroupAssgmtValidFromDate,
  IHBGroupAssgmtValidToDate,
  IHBObjectTotalChangedDateTime,
  IHBObjectCreatedDateTime,
  IHBObjectCreatedByUser,
  IHBObjectChangedDateTime,
  IHBObjectChangedByUser
FROM I_IHBGroupAssignmentComposite
;

Learn More