A_ColltrlREPartAccessory

DDL: A_COLLTRLREPARTACCESSORY Type: view_entity CONSUMPTION

Collateral Real Estate Part Accessory

A_ColltrlREPartAccessory is a Consumption CDS View that provides data about "Collateral Real Estate Part Accessory" in SAP S/4HANA. It reads from 1 data source (R_ColltrlREPartAccessoryTP) and exposes 36 fields with key field ColltrlREPartAccessoryUUID.

Data Sources (1)

SourceAliasJoin Type
R_ColltrlREPartAccessoryTP R_ColltrlREPartAccessoryTP projection

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_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
OData.entityType.name ColltrlRealEstatePartAccessory_Type view
EndUserText.label Collateral Real Estate Part Accessory view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ColltrlREPartAccessoryUUID ColltrlREPartAccessoryUUID
CollateralRealEstatePartUUID CollateralRealEstatePartUUID
CollateralRealEstatePartID CollateralRealEstatePartID
ColltrlRealEstateAccessoryType ColltrlRealEstateAccessoryType
ColltrlRENumberOfAccessory ColltrlRENumberOfAccessory
ColltrlREAccessoryAmount ColltrlREAccessoryAmount
ColltrlREAccessoryCurrency ColltrlREAccessoryCurrency
ColltrlREIsSubAssetCreated ColltrlREIsSubAssetCreated
ColltrlREAccessoryDescription ColltrlREAccessoryDescription
ColltrlRealEstateAccessoryID ColltrlRealEstateAccessoryID
CollateralRealEstateRiskCode CollateralRealEstateRiskCode
ColltrlRESafetyDiscountSign ColltrlRESafetyDiscountSign
ColltrlRESafetyDiscountPercent ColltrlRESafetyDiscountPercent
ColltrlRESafetyDiscountAmount ColltrlRESafetyDiscountAmount
ColltrlRESftyDiscountCurrency ColltrlRESftyDiscountCurrency
ColltrlRealEstateValuationType ColltrlRealEstateValuationType
ColltrlREValuationFrequency ColltrlREValuationFrequency
ColltrlREValuationPeriod ColltrlREValuationPeriod
ColltrlRELastRevaluationDate ColltrlRELastRevaluationDate
ColltrlRERevaluationStartDate ColltrlRERevaluationStartDate
ColltrlRERevaluationEndDate ColltrlRERevaluationEndDate
ColltrlRealEstateLendingSign ColltrlRealEstateLendingSign
ColltrlRE1stLendingRate ColltrlRE1stLendingRate
ColltrlRE2ndLendingRate ColltrlRE2ndLendingRate
ColltrlRE3rdLendingRate ColltrlRE3rdLendingRate
ColltrlRE4thLendingRate ColltrlRE4thLendingRate
ColltrlRE5thLendingRate ColltrlRE5thLendingRate
CollateralRealEstateEnteredBy CollateralRealEstateEnteredBy
ColltrlRealEstateEnteredDate ColltrlRealEstateEnteredDate
ColltrlRealEstateEnteredTime ColltrlRealEstateEnteredTime
ColltrlRealEstateEnteredSource ColltrlRealEstateEnteredSource
ColltrlRealEstateLastChangedBy ColltrlRealEstateLastChangedBy
ColltrlRELastChangedDate ColltrlRELastChangedDate
ColltrlRELastChangedTime ColltrlRELastChangedTime
ColltrlRELastChangedSource ColltrlRELastChangedSource
CollateralRealEstateUUID CollateralRealEstateUUID

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 A_ColltrlREPartAccessory.
-- 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 A_ColltrlREPartAccessory 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,
  CollateralRealEstateUUID
FROM R_ColltrlREPartAccessoryTP
;