P_REIntegObjToContrByKeyDate

DDL: P_REINTEGOBJTOCONTRBYKEYDATE Type: view_entity COMPOSITE
8 Fields 3 Data Sources

Integration Object Contract Assignment by Keydate

P_REIntegObjToContrByKeyDate is a Composite CDS View that provides data about "Integration Object Contract Assignment by Keydate" in SAP S/4HANA. It reads from 3 data sources (vicncn, viipobject, vibdobjass) and exposes 8 fields with key fields REStatusObjectSource, REObjectAssignmentType, CompanyCode, RealEstateContract, InternalRealEstateNumber.

Data Sources (3)

SourceAliasJoin Type
vicncn _REContract inner
viipobject _REIntegrationObject inner
vibdobjass _REObjectAssgmt from

Parameters (1)

NameTypeDefault
P_KeyDate recakeydate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Integration Object Contract Assignment by Keydate view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource vibdobjass objnrtrg Object Number
KEY REObjectAssignmentType vibdobjass objasstype Assignment Type
KEY CompanyCode vicncn bukrs Value
KEY RealEstateContract vicncn recnnr Contract No.
KEY InternalRealEstateNumber viipobject intreno Source Object
REStatusObjectTarget vibdobjass objnrsrc Object Number
REContractActivateDate
REContractName

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 P_REIntegObjToContrByKeyDate.
-- 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.
-- Parameters: P_KeyDate : recakeydate

CREATE VIEW P_REIntegObjToContrByKeyDate AS
SELECT
  _REObjectAssgmt.objnrtrg AS REStatusObjectSource,
  _REObjectAssgmt.objasstype AS REObjectAssignmentType,
  _REContract.bukrs AS CompanyCode,
  _REContract.recnnr AS RealEstateContract,
  _REIntegrationObject.intreno AS InternalRealEstateNumber,
  _REObjectAssgmt.objnrsrc AS REStatusObjectTarget,
  cast(_REContract.recndactiv as recnvdmdaktv preserving type ) AS REContractActivateDate,
  cast(_REContract.recntxt as recnvdmcnname preserving type ) AS REContractName
FROM vibdobjass AS _REObjectAssgmt
INNER JOIN viipobject AS _REIntegrationObject ON /* join condition not captured in parsed metadata */
INNER JOIN vicncn AS _REContract ON /* join condition not captured in parsed metadata */
;

Learn More