I_PrftCtrCompCodeAssgmtTP

DDL: I_PRFTCTRCOMPCODEASSGMTTP SQL: IFIPCTRCOMASTP Type: view TRANSACTIONAL Package: ODATA_PROFIT_CENTER_V2
13 Fields 1 Data Sources 1 Associations

Assignment of company code to PrftCtr

I_PrftCtrCompCodeAssgmtTP is a Transactional CDS View that provides data about "Assignment of company code to PrftCtr" in SAP S/4HANA. It reads from 1 data source (P_PrftCtrCompCodeAssgmtJVA) and exposes 13 fields with key fields ControllingArea, ProfitCenter, CompanyCode, ValidityEndDate. It has 1 association to related views. Part of development package ODATA_PROFIT_CENTER_V2.

Data Sources (1)

SourceAliasJoin Type
P_PrftCtrCompCodeAssgmtJVA P_PrftCtrCompCodeAssgmtJVA from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProfitCenterTP _ParentNode $projection.ControllingArea = _ParentNode.ControllingArea and $projection.ProfitCenter = _ParentNode.ProfitCenter and $projection.ValidityEndDate = _ParentNode.ValidityEndDate

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IFIPCTRCOMASTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Assignment of company code to PrftCtr view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.writeDraftPersistence CEPC_BUKRS_DRAFT view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

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

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 I_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.
-- SQL view name: IFIPCTRCOMASTP

CREATE VIEW I_PrftCtrCompCodeAssgmtTP AS
SELECT
  ControllingArea,
  ProfitCenter,
  CompanyCode,
  ValidityEndDate,
  CompanyCodeName,
  PrftCtrIsAssignedToCompCode,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass
FROM P_PrftCtrCompCodeAssgmtJVA
LEFT OUTER JOIN I_ProfitCenterTP AS _ParentNode ON ControllingArea = _ParentNode.ControllingArea AND ProfitCenter = _ParentNode.ProfitCenter AND ValidityEndDate = _ParentNode.ValidityEndDate  -- association [1..1]
;

Learn More