I_REAssgmtTypeForObjectType

DDL: I_REASSGMTTYPEFOROBJECTTYPE SQL: IREBDAOBJTYPE Type: view BASIC Package: VDM_RE_BD
11 Fields 1 Data Sources 2 Associations

Allowed Assignment Type for Object Type

I_REAssgmtTypeForObjectType is a Basic CDS View that provides data about "Allowed Assignment Type for Object Type" in SAP S/4HANA. It reads from 1 data source (tivbdobjass) and exposes 11 fields with key fields RealEstateObjectType, REObjectTypeDiffntn, REObjectTypeTarget, REObjectTypeDiffntnTarget. It has 2 associations to related views. Part of development package VDM_RE_BD.

Data Sources (1)

SourceAliasJoin Type
tivbdobjass tivbdobjass from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_REObjectType _REObjectType $projection.RealEstateObjectType = _REObjectType.RealEstateObjectType
[1..1] I_REObjectType _REObjectTypeTarget $projection.REObjectTypeTarget = _REObjectTypeTarget.RealEstateObjectType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREBDAOBJTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Allowed Assignment Type for Object Type view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey REObjectTypeDiffntn view
ObjectModel.semanticKey REObjectTypeDiffntn view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RealEstateObjectType objtype Translation OType
KEY REObjectTypeDiffntn objtypediff Diff. Criterion
KEY REObjectTypeTarget objtypetrg Asgn.Obj.Type
KEY REObjectTypeDiffntnTarget objtypedifftrg Diff. Criterion
REObjectAssgmtIsPermitted assignobject Obj.Assg.Permit
REObjectDistrIsPermitted assigndistri DistAssgmntPerm
REObjectObjGroupIsPermitted assigngrp Grp Assignment
REObjectAssgmtInfoOption assigninfoind Assignment Opt.
REObjectSubObjectIsPermitted assignsubobj Subobjects
_REObjectType _REObjectType
_REObjectTypeTarget _REObjectTypeTarget

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_REAssgmtTypeForObjectType.
-- 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: IREBDAOBJTYPE

CREATE VIEW I_REAssgmtTypeForObjectType AS
SELECT
  objtype AS RealEstateObjectType,
  objtypediff AS REObjectTypeDiffntn,
  objtypetrg AS REObjectTypeTarget,
  objtypedifftrg AS REObjectTypeDiffntnTarget,
  assignobject AS REObjectAssgmtIsPermitted,
  assigndistri AS REObjectDistrIsPermitted,
  assigngrp AS REObjectObjGroupIsPermitted,
  assigninfoind AS REObjectAssgmtInfoOption,
  assignsubobj AS REObjectSubObjectIsPermitted
FROM tivbdobjass
LEFT OUTER JOIN I_REObjectType AS _REObjectType ON RealEstateObjectType = _REObjectType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_REObjectType AS _REObjectTypeTarget ON REObjectTypeTarget = _REObjectTypeTarget.RealEstateObjectType  -- association [1..1]
;

Learn More