C_PrftCtrCompCodeAssgmtTP_2

DDL: C_PRFTCTRCOMPCODEASSGMTTP_2 Type: view_entity CONSUMPTION Package: RAP_FIN_GL_PROFIT_CENTER_UI
19 Fields 1 Data Sources 1 OData Services

Profit Center Company Code Assignment

C_PrftCtrCompCodeAssgmtTP_2 is a Consumption CDS View that provides data about "Profit Center Company Code Assignment" in SAP S/4HANA. It reads from 1 data source (R_PrftCtrCompCodeAssgmtTP) and exposes 19 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate, CompanyCode. It is exposed through 1 OData service (UI_PROFITCENTER_MANAGE). Part of development package RAP_FIN_GL_PROFIT_CENTER_UI.

Data Sources (1)

SourceAliasJoin Type
R_PrftCtrCompCodeAssgmtTP R_PrftCtrCompCodeAssgmtTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Profit Center Company Code Assignment view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PROFITCENTER_MANAGE UI_PROFITCENTER_MANAGE V4 C1 NOT_RELEASED

Fields (19)

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

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 C_PrftCtrCompCodeAssgmtTP_2.
-- 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 C_PrftCtrCompCodeAssgmtTP_2 AS
SELECT
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  CompanyCode,
  CompanyCodeForEdit,
  CompanyCodeName,
  PrftCtrIsAssignedToCompCode,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  cast ( JointVentureObjectType as rap_fin_jv_object_type preserving type ) AS JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass,
  cast ( _JointVentureMaster.JointVentureName as rap_fin_joint_venture_name preserving type ) AS JointVentureName,
  cast ( _JointVentureRecovery._Text[1:Language = $session.system_language].JointVentureRecoveryCodeName as rap_fin_jv_recovary_code_name preserving type ) AS JointVentureRecoveryCodeName,
  cast ( _JntVntrEquityTypeMaster._JntVntrEquityTypeDesc[1:Language = $session.system_language].JointVentureEquityTypeName as rap_fin_jv_equity_type_name preserving type ) AS JointVentureEquityTypeName,
  cast ( _JntVntrCostCtrType._JntVntrCostCtrTypeText[1:Language = $session.system_language].JntVntrCostCtrTypeText as rap_fin_jv_object_type_name preserving type ) AS JntVntrCostCtrTypeText,
  cast ( _JntIntrstBillgClass._JntIntrstBillgClassText[1:Language = $session.system_language].JntIntrstBillgClassText as rap_fin_jv_class_name preserving type ) AS JntIntrstBillgClassText,
  cast ( _JntIntrstBillgSubclass._JntIntrstBillgSubclassT[1:Language = $session.system_language].JntIntrstBillgSubClassText as rap_fin_jv_subclass_name preserving type ) AS JntIntrstBillgSubClassText
FROM R_PrftCtrCompCodeAssgmtTP
;

Learn More