I_IHBAcctLimitGroupAssgmtTP

DDL: I_IHBACCTLIMITGROUPASSGMTTP Type: view_entity TRANSACTIONAL Package: IHB_LIMIT

IHB Group Assignment - TP

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

Data Sources (1)

SourceAliasJoin Type
R_IHBGroupAssignmentTP R_IHBGroupAssignmentTP projection

Annotations (10)

NameValueLevelField
EndUserText.label IHB Group Assignment - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY IHBGroupAssignmentUUID IHBGroupAssignmentUUID UUID
IHBObjectUUID IHBObjectUUID UUID
IHBGroupAssignmentRefUUID IHBGroupAssignmentRefUUID UUID
IHBObjectCategory IHBObjectCategory Object Category
IHBObjectKeyUUID IHBObjectKeyUUID UUID
IHBAccountNumber IHBAccountNumber Account Number
IHBAccountCurrency IHBAccountCurrency Currency
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
_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 I_IHBAcctLimitGroupAssgmtTP.
-- 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 I_IHBAcctLimitGroupAssgmtTP AS
SELECT
  IHBGroupAssignmentUUID,
  IHBObjectUUID,
  IHBGroupAssignmentRefUUID,
  IHBObjectCategory,
  IHBObjectKeyUUID,
  IHBAccountNumber,
  IHBAccountCurrency,
  IHBGroupAssgmtValidFromDate,
  IHBGroupAssgmtValidToDate,
  IHBObjectTotalChangedDateTime,
  IHBObjectCreatedDateTime,
  IHBObjectCreatedByUser,
  IHBObjectChangedDateTime,
  IHBObjectChangedByUser
FROM R_IHBGroupAssignmentTP
;