R_ColltrlRealEstatePartAssetTP

DDL: R_COLLTRLREALESTATEPARTASSETTP Type: view_entity TRANSACTIONAL
67 Fields 1 Data Sources 1 Associations

Collateral Real Estate Part Asset - TP

R_ColltrlRealEstatePartAssetTP is a Transactional CDS View that provides data about "Collateral Real Estate Part Asset - TP" in SAP S/4HANA. It reads from 1 data source (I_CollateralAssetData) and exposes 67 fields with key field CollateralAssetUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CollateralAssetData I_CollateralAssetData 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 CollateralRealEstatePartAsset 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 Collateral Real Estate Part Asset - TP view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY CollateralAssetUUID CollateralAssetUUID AST_GUID
CollateralAssetIdentifier CollateralAssetIdentifier Asset ID
CollateralAssetType CollateralAssetType Asset Type
CollateralAssetParentUUID CollateralAssetParentUUID UUID
ColltrlSubsqntAssetIdentifier ColltrlSubsqntAssetIdentifier Sub-asset ID
ColltrlSubsequentAssetType ColltrlSubsequentAssetType Sub-asset type
CollateralAssetDescription CollateralAssetDescription Well Code Des.
CollateralAssetReferenceNumber CollateralAssetReferenceNumber Obj referenceID
CollateralObjectUUID
CollateralAssetCountryKey CollateralAssetCountryKey SCB Cntry/Reg. Ind.
CollateralAssetRiskCode CollateralAssetRiskCode Risk code
ColltrlAssetSafetyDiscountSign ColltrlAssetSafetyDiscountSign Safety Discount
ColltrlAssetSafetyDiscountPct ColltrlAssetSafetyDiscountPct Safety disc (%)
ColltrlAssetSafetyDiscountAmt ColltrlAssetSafetyDiscountAmt Sfty disc (amt)
ColltrlAssetSafetyDiscountCrcy ColltrlAssetSafetyDiscountCrcy Currency
CollateralReferenceSystem CollateralReferenceSystem Obj System ID
CollateralAssetValuationType CollateralAssetValuationType Valuation type
ColltrlAssetValuationFrequency ColltrlAssetValuationFrequency ValuationPeriod
CollateralAssetValuationPeriod CollateralAssetValuationPeriod Valuation freq
ColltrlAstLastRevaluationDate ColltrlAstLastRevaluationDate Last Revaln dt
ColltrlAstRevaluationStartDte ColltrlAstRevaluationStartDte Valn start date
ColltrlAssetRevaluationEndDate ColltrlAssetRevaluationEndDate Valn End date
CollateralAssetLendingRateSign CollateralAssetLendingRateSign Lending Rate
CollateralAssetLendingRate CollateralAssetLendingRate Rate 1
CollateralAssetLendingRate2 CollateralAssetLendingRate2 Rate 2
CollateralAssetLendingRate3 CollateralAssetLendingRate3 Rate 3
CollateralAssetLendingRate4 CollateralAssetLendingRate4 Rate 4
CollateralAssetLendingRate5 CollateralAssetLendingRate5 Rate 5
CollateralAssetLiquidationType CollateralAssetLiquidationType Liquidation typ
ColltrlAssetLiquidationReason ColltrlAssetLiquidationReason Liquidation Rsn
ColltrlAssetLiquidationDate ColltrlAssetLiquidationDate Liquidation Dt
ColltrlAssetLiquidationAmount ColltrlAssetLiquidationAmount Liquidation Amt
ColltrlAstLiquidationCurrency ColltrlAstLiquidationCurrency Currency
ColltrlAstLqdtnExpdProceedAmt ColltrlAstLqdtnExpdProceedAmt ExpPrcd
ColltrlAstLqdtnExpdProceedCrcy ColltrlAstLqdtnExpdProceedCrcy ExpPrcCurr
ColltrlAstLqdtnExpdAccrualDate ColltrlAstLqdtnExpdAccrualDate AccrualDate
ColltrlAstLqdtnExpdProceedDate ColltrlAstLqdtnExpdProceedDate Expected Time
ColltrlAstLqdtnAccountNumber ColltrlAstLqdtnAccountNumber Acc. number
ColltrlAstLqdtnBankCountry ColltrlAstLqdtnBankCountry Ctry/Region Key
ColltrlAssetLiquidationBankKey ColltrlAssetLiquidationBankKey Bank key
ColltrlAstLqdtnBankControlKey ColltrlAstLqdtnBankControlKey Control Key
ColltrlAstVerificatFrequency ColltrlAstVerificatFrequency VerifcationUnit
ColltrlAssetVerificationPeriod ColltrlAssetVerificationPeriod Verf. Period
ColltrlAssetVerificationDate ColltrlAssetVerificationDate Last Verf. Date
CollateralAssetNominalAmount CollateralAssetNominalAmount Nominal value
CollateralAssetNominalCurrency CollateralAssetNominalCurrency Currency
CollateralAssetFinalAmount CollateralAssetFinalAmount Value
CollateralAssetFinalCurrency CollateralAssetFinalCurrency Currency
CollateralAssetQuantity CollateralAssetQuantity Value
CollateralAssetQuantityUoM CollateralAssetQuantityUoM Unit of Measure
ColltrlAssetRecordingDateTime ColltrlAssetRecordingDateTime Recorded At
CollateralAssetPurchasePrice CollateralAssetPurchasePrice Purchase price
ColltrlAssetPurchaseCurrency ColltrlAssetPurchaseCurrency Pur Price crcy
CollateralAssetPurchaseDate CollateralAssetPurchaseDate Pur price date
CollateralAssetOriginalAmount CollateralAssetOriginalAmount Orig.Pro. Value
ColltrlAssetOriginalCurrency ColltrlAssetOriginalCurrency Currency
CollateralAdminOrgUnit CollateralAdminOrgUnit AdminOrg
CollateralBankArea CollateralBankArea Bankarea
CollateralAssetEnteredBy CollateralAssetEnteredBy Version Created By
CollateralAssetEnteredDateTime CollateralAssetEnteredDateTime Uploaded On
CollateralAssetLastChangedBy CollateralAssetLastChangedBy User Name
ColltrlAstLastChangedDateTime ColltrlAstLastChangedDateTime Timestamp
CollateralAssetEnteredSource CollateralAssetEnteredSource Source Of Entry
ColltrlAstNextRevaluationDate ColltrlAstNextRevaluationDate Nxt Revaluation date
CollateralRealEstateUUID
_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_ColltrlRealEstatePartAssetTP.
-- 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_ColltrlRealEstatePartAssetTP AS
SELECT
  CollateralAssetUUID,
  CollateralAssetIdentifier,
  CollateralAssetType,
  CollateralAssetParentUUID,
  ColltrlSubsqntAssetIdentifier,
  ColltrlSubsequentAssetType,
  CollateralAssetDescription,
  CollateralAssetReferenceNumber,
  hextobin( ColltrlAstRefNumberConverted ) AS CollateralObjectUUID,
  CollateralAssetCountryKey,
  CollateralAssetRiskCode,
  ColltrlAssetSafetyDiscountSign,
  ColltrlAssetSafetyDiscountPct,
  ColltrlAssetSafetyDiscountAmt,
  ColltrlAssetSafetyDiscountCrcy,
  CollateralReferenceSystem,
  CollateralAssetValuationType,
  ColltrlAssetValuationFrequency,
  CollateralAssetValuationPeriod,
  ColltrlAstLastRevaluationDate,
  ColltrlAstRevaluationStartDte,
  ColltrlAssetRevaluationEndDate,
  CollateralAssetLendingRateSign,
  CollateralAssetLendingRate,
  CollateralAssetLendingRate2,
  CollateralAssetLendingRate3,
  CollateralAssetLendingRate4,
  CollateralAssetLendingRate5,
  CollateralAssetLiquidationType,
  ColltrlAssetLiquidationReason,
  ColltrlAssetLiquidationDate,
  ColltrlAssetLiquidationAmount,
  ColltrlAstLiquidationCurrency,
  ColltrlAstLqdtnExpdProceedAmt,
  ColltrlAstLqdtnExpdProceedCrcy,
  ColltrlAstLqdtnExpdAccrualDate,
  ColltrlAstLqdtnExpdProceedDate,
  ColltrlAstLqdtnAccountNumber,
  ColltrlAstLqdtnBankCountry,
  ColltrlAssetLiquidationBankKey,
  ColltrlAstLqdtnBankControlKey,
  ColltrlAstVerificatFrequency,
  ColltrlAssetVerificationPeriod,
  ColltrlAssetVerificationDate,
  CollateralAssetNominalAmount,
  CollateralAssetNominalCurrency,
  CollateralAssetFinalAmount,
  CollateralAssetFinalCurrency,
  CollateralAssetQuantity,
  CollateralAssetQuantityUoM,
  ColltrlAssetRecordingDateTime,
  CollateralAssetPurchasePrice,
  ColltrlAssetPurchaseCurrency,
  CollateralAssetPurchaseDate,
  CollateralAssetOriginalAmount,
  ColltrlAssetOriginalCurrency,
  CollateralAdminOrgUnit,
  CollateralBankArea,
  CollateralAssetEnteredBy,
  CollateralAssetEnteredDateTime,
  CollateralAssetLastChangedBy,
  ColltrlAstLastChangedDateTime,
  CollateralAssetEnteredSource,
  ColltrlAstNextRevaluationDate,
  I_CollateralAssetData._CollateralRealEstatePart.CollateralRealEstateUUID AS CollateralRealEstateUUID
FROM I_CollateralAssetData
LEFT OUTER JOIN R_CollateralRealEstateTP AS _CollateralRealEstate ON collateralrealestateuuid = _CollateralRealEstate.CollateralRealEstateUUID  -- association [1..1]
;

Learn More