R_ColltrlREPartAccessoryTP

DDL: R_COLLTRLREPARTACCESSORYTP Type: view_entity TRANSACTIONAL
39 Fields 1 Data Sources 1 Associations

Colltrl Real Estate Part Accessory - TP

R_ColltrlREPartAccessoryTP is a Transactional CDS View that provides data about "Colltrl Real Estate Part Accessory - TP" in SAP S/4HANA. It reads from 1 data source (I_ColltrlREPartAccessory) and exposes 39 fields with key field ColltrlREPartAccessoryUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ColltrlREPartAccessory I_ColltrlREPartAccessory from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_CollateralRealEstateTP _CollateralRealEstate $projection.collateralrealestateuuid = _CollateralRealEstate.CollateralRealEstateUUID

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ColltrlRealEstatePartAccessory view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Colltrl Real Estate Part Accessory - TP view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ColltrlREPartAccessoryUUID ColltrlREPartAccessoryUUID Acs GUID
CollateralRealEstatePartUUID CollateralRealEstatePartUUID Part GUID
CollateralRealEstatePartID CollateralRealEstatePartID Partner
ColltrlRealEstateAccessoryType ColltrlRealEstateAccessoryType Type
ColltrlRENumberOfAccessory ColltrlRENumberOfAccessory Units
ColltrlREAccessoryAmount ColltrlREAccessoryAmount Value
ColltrlREAccessoryCurrency ColltrlREAccessoryCurrency Currency
ColltrlREIsSubAssetCreated ColltrlREIsSubAssetCreated Sub Asset
ColltrlREAccessoryDescription ColltrlREAccessoryDescription Description
ColltrlRealEstateAccessoryID ColltrlRealEstateAccessoryID ID
CollateralRealEstateRiskCode CollateralRealEstateRiskCode Risk code
ColltrlRESafetyDiscountSign ColltrlRESafetyDiscountSign Safety Discount
ColltrlRESafetyDiscountPercent ColltrlRESafetyDiscountPercent Safety disc (%)
ColltrlRESafetyDiscountAmount ColltrlRESafetyDiscountAmount Sfty disc (amt)
ColltrlRESftyDiscountCurrency ColltrlRESftyDiscountCurrency Currency
ColltrlRealEstateValuationType ColltrlRealEstateValuationType Valuation type
ColltrlREValuationFrequency ColltrlREValuationFrequency ValuationPeriod
ColltrlREValuationPeriod ColltrlREValuationPeriod Valuation freq
ColltrlRELastRevaluationDate ColltrlRELastRevaluationDate Last Revaln dt
ColltrlRERevaluationStartDate ColltrlRERevaluationStartDate Valn start date
ColltrlRERevaluationEndDate ColltrlRERevaluationEndDate Valn End date
ColltrlRealEstateLendingSign ColltrlRealEstateLendingSign Lending Rate
ColltrlRE1stLendingRate ColltrlRE1stLendingRate Rate 1
ColltrlRE2ndLendingRate ColltrlRE2ndLendingRate Rate 2
ColltrlRE3rdLendingRate ColltrlRE3rdLendingRate Rate 3
ColltrlRE4thLendingRate ColltrlRE4thLendingRate Rate 4
ColltrlRE5thLendingRate ColltrlRE5thLendingRate Rate 5
CollateralRealEstateEnteredBy CollateralRealEstateEnteredBy Version Created By
ColltrlRealEstateEnteredDate ColltrlRealEstateEnteredDate Time Stamp
ColltrlRealEstateEnteredTime ColltrlRealEstateEnteredTime Time Stamp
ColltrlRealEstateEnteredSource ColltrlRealEstateEnteredSource Source Of Entry
ColltrlRealEstateLastChangedBy ColltrlRealEstateLastChangedBy Last Changed by
ColltrlRELastChangedDate ColltrlRELastChangedDate Last Changed on
ColltrlRELastChangedTime ColltrlRELastChangedTime Last Changed at
ColltrlRELastChangedSource ColltrlRELastChangedSource Processing Src
CollateralRealEstateUUID
_ColltrlREPrtAccessoryAsset _ColltrlREPrtAccessoryAsset
_CollateralRealEstatePart _CollateralRealEstatePart
_CollateralRealEstate _CollateralRealEstate

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_ColltrlREPartAccessoryTP.
-- 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_ColltrlREPartAccessoryTP AS
SELECT
  ColltrlREPartAccessoryUUID,
  CollateralRealEstatePartUUID,
  CollateralRealEstatePartID,
  ColltrlRealEstateAccessoryType,
  ColltrlRENumberOfAccessory,
  ColltrlREAccessoryAmount,
  ColltrlREAccessoryCurrency,
  ColltrlREIsSubAssetCreated,
  ColltrlREAccessoryDescription,
  ColltrlRealEstateAccessoryID,
  CollateralRealEstateRiskCode,
  ColltrlRESafetyDiscountSign,
  ColltrlRESafetyDiscountPercent,
  ColltrlRESafetyDiscountAmount,
  ColltrlRESftyDiscountCurrency,
  ColltrlRealEstateValuationType,
  ColltrlREValuationFrequency,
  ColltrlREValuationPeriod,
  ColltrlRELastRevaluationDate,
  ColltrlRERevaluationStartDate,
  ColltrlRERevaluationEndDate,
  ColltrlRealEstateLendingSign,
  ColltrlRE1stLendingRate,
  ColltrlRE2ndLendingRate,
  ColltrlRE3rdLendingRate,
  ColltrlRE4thLendingRate,
  ColltrlRE5thLendingRate,
  CollateralRealEstateEnteredBy,
  ColltrlRealEstateEnteredDate,
  ColltrlRealEstateEnteredTime,
  ColltrlRealEstateEnteredSource,
  ColltrlRealEstateLastChangedBy,
  ColltrlRELastChangedDate,
  ColltrlRELastChangedTime,
  ColltrlRELastChangedSource,
  I_ColltrlREPartAccessory._CollateralRealEstatePart.CollateralRealEstateUUID AS CollateralRealEstateUUID
FROM I_ColltrlREPartAccessory
LEFT OUTER JOIN R_CollateralRealEstateTP AS _CollateralRealEstate ON collateralrealestateuuid = _CollateralRealEstate.CollateralRealEstateUUID  -- association [1..1]
;

Learn More