R_PrftCtrCompCodeAssgmtTP

DDL: R_PRFTCTRCOMPCODEASSGMTTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 1 Associations

Prft Center Company Code Assignment - TP

R_PrftCtrCompCodeAssgmtTP is a Transactional CDS View that provides data about "Prft Center Company Code Assignment - TP" in SAP S/4HANA. It reads from 1 data source (R_PrftCtrCompCodeCompndAssgmt) and exposes 13 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate, CompanyCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PrftCtrCompCodeCompndAssgmt R_PrftCtrCompCodeCompndAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PrftCtrCompCodeAssgmt _Assignment $projection.ControllingArea = _Assignment.ControllingArea and $projection.ProfitCenter = _Assignment.ProfitCenter and $projection.CompanyCode = _Assignment.CompanyCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Prft Center Company Code Assignment - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate ValidityEndDate ValidTo
KEY CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
PrftCtrIsAssignedToCompCode PrftCtrIsAssignedToCompCode Assigned
JointVenture _Assignment JointVenture Joint venture
JointVentureRecoveryCode _Assignment JointVentureRecoveryCode Recovery Ind.
JointVentureEquityType _Assignment JointVentureEquityType Joint Venture Equity Type
JointVentureObjectType _Assignment JointVentureObjectType JV Object Type
JointVentureClass _Assignment JointVentureClass JIB/JIBE Class
JointVentureSubClass _Assignment JointVentureSubClass JIB/JIBE SbClsA
_ProfitCenterTP _ProfitCenterTP

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_PrftCtrCompCodeAssgmtTP.
-- 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_PrftCtrCompCodeAssgmtTP AS
SELECT
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  CompanyCode,
  CompanyCodeName,
  PrftCtrIsAssignedToCompCode,
  _Assignment.JointVenture AS JointVenture,
  _Assignment.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  _Assignment.JointVentureEquityType AS JointVentureEquityType,
  _Assignment.JointVentureObjectType AS JointVentureObjectType,
  _Assignment.JointVentureClass AS JointVentureClass,
  _Assignment.JointVentureSubClass AS JointVentureSubClass
FROM R_PrftCtrCompCodeCompndAssgmt
LEFT OUTER JOIN I_PrftCtrCompCodeAssgmt AS _Assignment ON ControllingArea = _Assignment.ControllingArea AND ProfitCenter = _Assignment.ProfitCenter AND CompanyCode = _Assignment.CompanyCode  -- association [0..1]
;

Learn More