A_REContrSalesReportingTerm

DDL: A_RECONTRSALESREPORTINGTERM Type: view_entity CONSUMPTION
27 Fields 1 Data Sources 1 OData Services

Sales Reporting Terms

A_REContrSalesReportingTerm is a Consumption CDS View that provides data about "Sales Reporting Terms" in SAP S/4HANA. It reads from 1 data source (R_REContrSalesReportingTermTP) and exposes 27 fields with key fields InternalRealEstateNumber, RETermNumber, RETermType, ValidityStartEndDateValue, RESalesRhythmType. It is exposed through 1 OData service (API_RECONTRACT).

Data Sources (1)

SourceAliasJoin Type
R_REContrSalesReportingTermTP R_REContrSalesReportingTermTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name REContrSalesReportingTerm_Type view
EndUserText.label Sales Reporting Terms view

OData Services (1)

ServiceBindingVersionContractRelease
API_RECONTRACT API_REAL_ESTATE_CONTRACT V4 C2 C1

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermNumber RETermNumber Number
KEY RETermType RETermType Term Category
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
KEY RESalesRhythmType RESalesRhythmType
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RETermName RETermName Name of Term
RealEstateObjectType RealEstateObjectType Object Type
REStatusObject REStatusObject Val. Obj. No.
RESalesType RESalesType
RESalesReportType RESalesReportType
REIsStatisticalRule REIsStatisticalRule
RESalesReportingIsUsingMsmt RESalesReportingIsUsingMsmt
REMeasurementType REMeasurementType
REStatusObjectMeasurement REStatusObjectMeasurement
MeasuringPoint MeasuringPoint
RERgnlLocKeyHeatingValDays RERgnlLocKeyHeatingValDays
REFrequencyStartDate REFrequencyStartDate Frequency Start
RENumberOfFrequencyUnits RENumberOfFrequencyUnits Frequency
REFrequencyUnit REFrequencyUnit Frequency Unit
REFixedPeriod REFixedPeriod Fixed Periods
RESalesReportingTolerance RESalesReportingTolerance
RESalesReportingToleranceUnit RESalesReportingToleranceUnit
RESalesRptgToleranceCalendar RESalesRptgToleranceCalendar
REFrequencyExcludedStartDate REFrequencyExcludedStartDate
REFrequencyExcludedEndDate REFrequencyExcludedEndDate

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_REContrSalesReportingTerm.
-- 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_REContrSalesReportingTerm AS
SELECT
  InternalRealEstateNumber,
  RETermNumber,
  RETermType,
  ValidityStartEndDateValue,
  RESalesRhythmType,
  ValidityStartDate,
  ValidityEndDate,
  RETermName,
  RealEstateObjectType,
  REStatusObject,
  RESalesType,
  RESalesReportType,
  REIsStatisticalRule,
  RESalesReportingIsUsingMsmt,
  REMeasurementType,
  REStatusObjectMeasurement,
  MeasuringPoint,
  RERgnlLocKeyHeatingValDays,
  REFrequencyStartDate,
  RENumberOfFrequencyUnits,
  REFrequencyUnit,
  REFixedPeriod,
  RESalesReportingTolerance,
  RESalesReportingToleranceUnit,
  RESalesRptgToleranceCalendar,
  REFrequencyExcludedStartDate,
  REFrequencyExcludedEndDate
FROM R_REContrSalesReportingTermTP
;

Learn More