A_REContrOrglAssgmtTerm

DDL: A_RECONTRORGLASSGMTTERM Type: view_entity CONSUMPTION Package: ODATA_RE_CN
19 Fields 1 Data Sources 1 OData Services

Organizational Assignments

A_REContrOrglAssgmtTerm is a Consumption CDS View that provides data about "Organizational Assignments" in SAP S/4HANA. It reads from 1 data source (R_REContrOrglAssgmtTermTP) and exposes 19 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, ValidityStartEndDateValue. It is exposed through 1 OData service (API_RECONTRACT). Part of development package ODATA_RE_CN.

Data Sources (1)

SourceAliasJoin Type
R_REContrOrglAssgmtTermTP R_REContrOrglAssgmtTermTP projection

Annotations (9)

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

OData Services (1)

ServiceBindingVersionContractRelease
API_RECONTRACT API_REAL_ESTATE_CONTRACT V4 C2 C1

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RETermName RETermName Name of Term
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
REStatusObject REStatusObject Val. Obj. No.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
Fund Fund Sender Fund
FundsCenter FundsCenter Funds Center
CommitmentItem CommitmentItem Commitment item
FunctionalArea FunctionalArea Sendr Fctl Area
BudgetPeriod BudgetPeriod Budget Period
ControllingArea _REOrglAssgmtTermAddl ControllingArea Controlling Area
TaxCalculationProcedure _REOrglAssgmtTermAddl TaxCalculationProcedure Tax Procedure
FinancialManagementArea _REOrglAssgmtTermAddl FinancialManagementArea FM Area

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_REContrOrglAssgmtTerm.
-- 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_REContrOrglAssgmtTerm AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  ValidityStartEndDateValue,
  ValidityStartDate,
  ValidityEndDate,
  RETermName,
  BusinessArea,
  ProfitCenter,
  REStatusObject,
  TaxJurisdiction,
  Fund,
  FundsCenter,
  CommitmentItem,
  FunctionalArea,
  BudgetPeriod,
  _REOrglAssgmtTermAddl.ControllingArea AS ControllingArea,
  _REOrglAssgmtTermAddl.TaxCalculationProcedure AS TaxCalculationProcedure,
  _REOrglAssgmtTermAddl.FinancialManagementArea AS FinancialManagementArea
FROM R_REContrOrglAssgmtTermTP
;

Learn More