R_PrftCtrCompCodeAssgmtTP

DDL: R_PRFTCTRCOMPCODEASSGMTTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_GL_PROFIT_CENTER
20 Fields 1 Data Sources 7 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 20 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate, CompanyCode. It has 7 associations to related views. Part of development package RAP_FIN_GL_PROFIT_CENTER.

Data Sources (1)

SourceAliasJoin Type
R_PrftCtrCompCodeCompndAssgmt R_PrftCtrCompCodeCompndAssgmt from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_PrftCtrCompCodeAssgmt _Assignment $projection.ControllingArea = _Assignment.ControllingArea and $projection.ProfitCenter = _Assignment.ProfitCenter and $projection.CompanyCode = _Assignment.CompanyCode
[0..1] I_JointVentureMaster _JointVentureMaster $projection.jointventure = _JointVentureMaster.JointVenture and $projection.CompanyCode = _JointVentureMaster.CompanyCode
[0..1] I_JointVentureRecovery _JointVentureRecovery $projection.jointventurerecoverycode = _JointVentureRecovery.JointVentureRecoveryCode and $projection.CompanyCode = _JointVentureRecovery.CompanyCode
[0..1] I_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster $projection.jointventureequitytype = _JntVntrEquityTypeMaster.JointVentureEquityType and $projection.CompanyCode = _JntVntrEquityTypeMaster.CompanyCode
[0..1] I_JntVntrCostCtrType _JntVntrCostCtrType $projection.jointventureobjecttype = _JntVntrCostCtrType.JntVntrCostCtrType and $projection.CompanyCode = _JntVntrCostCtrType.CompanyCode
[0..1] I_JntIntrstBillgClass _JntIntrstBillgClass $projection.jointventureclass = _JntIntrstBillgClass.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgClass.CompanyCode
[0..1] I_JntIntrstBillgSubclass _JntIntrstBillgSubclass $projection.CompanyCode = _JntIntrstBillgSubclass.CompanyCode and $projection.jointventureclass = _JntIntrstBillgSubclass.JntIntrstBillgClass and $projection.jointventuresubclass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass

Annotations (10)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate ValidityEndDate ValidTo
KEY CompanyCode CompanyCode Receiver Company Code
CompanyCodeForEdit 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
_JointVentureMaster _JointVentureMaster
_JointVentureRecovery _JointVentureRecovery
_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster
_JntVntrCostCtrType _JntVntrCostCtrType
_JntIntrstBillgClass _JntIntrstBillgClass
_JntIntrstBillgSubclass _JntIntrstBillgSubclass
_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,
  CompanyCode AS CompanyCodeForEdit,
  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]
LEFT OUTER JOIN I_JointVentureMaster AS _JointVentureMaster ON jointventure = _JointVentureMaster.JointVenture AND CompanyCode = _JointVentureMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON jointventurerecoverycode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecovery.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster ON jointventureequitytype = _JntVntrEquityTypeMaster.JointVentureEquityType AND CompanyCode = _JntVntrEquityTypeMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrCostCtrType AS _JntVntrCostCtrType ON jointventureobjecttype = _JntVntrCostCtrType.JntVntrCostCtrType AND CompanyCode = _JntVntrCostCtrType.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClass AS _JntIntrstBillgClass ON jointventureclass = _JntIntrstBillgClass.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgClass.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass AS _JntIntrstBillgSubclass ON CompanyCode = _JntIntrstBillgSubclass.CompanyCode AND jointventureclass = _JntIntrstBillgSubclass.JntIntrstBillgClass AND jointventuresubclass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass  -- association [0..1]
;

Learn More