I_InvgCsMObjectLogInStaff

DDL: I_INVGCSMOBJECTLOGINSTAFF SQL: IICMOBJLOGINSTF Type: view COMPOSITE
13 Fields 1 Data Sources 1 Associations

ICM Object Logged In Staff

I_InvgCsMObjectLogInStaff is a Composite CDS View that provides data about "ICM Object Logged In Staff" in SAP S/4HANA. It reads from 1 data source (I_InvgCsMStaffAndUnit) and exposes 13 fields with key field InvgCsMStaffUnitID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InvgCsMStaffAndUnit I_InvgCsMStaffAndUnit from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InvgCsMEmployee _Employee $projection.InvgCsMPartnerNumber = _Employee.BusinessPartner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IICMOBJLOGINSTF view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ICM Object Logged In Staff view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMStaffUnitID InvgCsMStaffUnitID Staff and Units ID
InvgCsMPartnerNumber InvgCsMPartnerNumber Partner Number
BusinessUser _Employee BusinessUser
InvgCsMRelationship InvgCsMRelationship Partner Function
InvgCsMRelatedEntityType InvgCsMRelatedEntityType Type
InvgCsMIsMainPartner InvgCsMIsMainPartner Main Partner
ValidFrom ValidFrom Vers.Valid From
ValidTo ValidTo Vers.Valid To
InvgCsMPartnerNumberType InvgCsMPartnerNumberType Internal No. Typ
BusinessPartner _Employee BusinessPartner Issuing Authority
AuthorizationGroup _Employee AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted _Employee IsBusinessPurposeCompleted Purpose Completed
_BusinessPartner _Employee _BusinessPartner

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_InvgCsMObjectLogInStaff.
-- 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: IICMOBJLOGINSTF

CREATE VIEW I_InvgCsMObjectLogInStaff AS
SELECT
  InvgCsMStaffUnitID,
  InvgCsMPartnerNumber,
  _Employee.BusinessUser AS BusinessUser,
  InvgCsMRelationship,
  InvgCsMRelatedEntityType,
  InvgCsMIsMainPartner,
  ValidFrom,
  ValidTo,
  InvgCsMPartnerNumberType,
  _Employee.BusinessPartner AS BusinessPartner,
  _Employee.AuthorizationGroup AS AuthorizationGroup,
  _Employee.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Employee._BusinessPartner AS _BusinessPartner
FROM I_InvgCsMStaffAndUnit
LEFT OUTER JOIN I_InvgCsMEmployee AS _Employee ON InvgCsMPartnerNumber = _Employee.BusinessPartner  -- association [1..1]
;

Learn More