I_ProfitCenterTP

DDL: I_PROFITCENTERTP Type: view TRANSACTIONAL

Profit Center Master Record

I_ProfitCenterTP is a Transactional CDS View that provides data about "Profit Center Master Record" in SAP S/4HANA. It reads from 1 data source (P_ProfitCenterTP) and exposes 63 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProfitCenterTP P_ProfitCenterTP from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterTextTP _MultiLangText $projection.ControllingArea = _MultiLangText.ControllingArea and $projection.ProfitCenter = _MultiLangText.ProfitCenter and $projection.ValidityEndDate = _MultiLangText.ValidityEndDate
[1] I_ControllingArea _ControllingAreaForEdit $projection.ControllingAreaForEdit = _ControllingAreaForEdit.ControllingArea
[0..*] I_ProfitCenterHierarchyNode _ProfitCenterHierNodeForEdit $projection.ControllingAreaForEdit = _ProfitCenterHierNodeForEdit.ControllingArea and $projection.ProfitCenterForEdit = _ProfitCenterHierNodeForEdit.ProfitCenter
[0..*] I_PrftCtrCompCodeAssgmtTP _CompanyCodeAssignment $projection.ControllingArea = _CompanyCodeAssignment.ControllingArea and $projection.ProfitCenter = _CompanyCodeAssignment.ProfitCenter and $projection.ValidityEndDate = _CompanyCodeAssignment.ValidityEndDate
[1..1] E_ProfitCenter _Extension $projection.ControllingArea = _Extension.ControllingArea and $projection.ProfitCenter = _Extension.ProfitCenter and $projection.ValidityEndDate = _Extension.ValidityEndDate

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName IFIPRFTCTRTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Profit Center Master Record view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence CEPC_DRAFT view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.sapObjectNodeType.name ProfitCenter view
Metadata.allowExtensions true view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea
KEY ProfitCenter ProfitCenter
KEY ValidityEndDate ValidityEndDate
ControllingAreaForEdit ControllingArea
ProfitCenterForEdit ProfitCenter
ValidityEndDateForEdit ValidityEndDate
ValidityStartDate ValidityStartDate
ProfitCenterName ProfitCenterName
ProfitCenterLongName ProfitCenterLongName
CompanyCode CompanyCode
ProfitCtrResponsiblePersonName ProfitCtrResponsiblePersonName
ProfitCtrResponsibleUser ProfitCtrResponsibleUser
ProfitCenterCreationDate ProfitCenterCreationDate
ProfitCenterCreatedByUser ProfitCenterCreatedByUser
Department Department
ProfitCenterStandardHierarchy ProfitCenterStandardHierarchy
Segment Segment
ProfitCenterIsBlocked ProfitCenterIsBlocked
Country Country
FormOfAddress FormOfAddress
AddressName AddressName
AdditionalName AdditionalName
CityName CityName
District District
ProfitCenterAddrName3 ProfitCenterAddrName3
ProfitCenterAddrName4 ProfitCenterAddrName4
StreetAddressName StreetAddressName
POBox POBox
PostalCode PostalCode
POBoxPostalCode POBoxPostalCode
Region Region
TaxJurisdiction TaxJurisdiction
Language Language
TeleboxNumber TeleboxNumber
PhoneNumber1 PhoneNumber1
PhoneNumber2 PhoneNumber2
FaxNumber FaxNumber
TelexNumber TelexNumber
TeletexNumber TeletexNumber
DataCommunicationPhoneNumber DataCommunicationPhoneNumber
ProfitCenterPrinterName ProfitCenterPrinterName
ControllingAreaName ControllingAreaName
CompanyCodeName CompanyCodeName
CreatedByUserFullName CreatedByUserFullName
ETag
ChangeDocObject ChangeDocObject
ProfitCenterResponsibilityArea ProfitCenterResponsibilityArea
ProfitCenterHierarchyRespyArea ProfitCenterHierarchyRespyArea
PrftCtrTransaclProcgAction
ProfitCenterValidityPeriod
_Text _Text
_Country _Country
_ControllingArea _ControllingArea
_ControllingAreaForEdit _ControllingAreaForEdit
_ProfitCenterHierarchyNode _ProfitCenterHierarchyNode
_ProfitCenterHierNodeForEdit _ProfitCenterHierNodeForEdit
_Language _Language
_Company _Company
_Region _Region
_ControllingAreaText _ControllingAreaText
_CompanyCodeAssignment _CompanyCodeAssignment
_MultiLangText _MultiLangText
_UserCrtedContactCard _UserCrtedContactCard
@AbapCatalog: {
  sqlViewName: 'IFIPRFTCTRTP',
  compiler.compareFilter: true
}

@VDM.viewType: #TRANSACTIONAL

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: [ '_UserCrtedContactCard' ]

@EndUserText.label: 'Profit Center Master Record'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE

// BOPF

@ObjectModel: {
    compositionRoot: true,
    modelCategory: #BUSINESS_OBJECT,
    transactionalProcessingEnabled: true,
    writeDraftPersistence: 'CEPC_DRAFT',
    draftEnabled: true,
    createEnabled: true,
    updateEnabled: 'EXTERNAL_CALCULATION',
    deleteEnabled: 'EXTERNAL_CALCULATION',
    semanticKey: [ 'ValidityEndDate', 'ControllingArea', 'ProfitCenter' ],
    entityChangeStateId: 'EXTERNAL_CALCULATION',
    usageType: {
        sizeCategory: #L,
        serviceQuality: #D,
        dataClass: #ORGANIZATIONAL
    },
    sapObjectNodeType.name: 'ProfitCenter'
}

@Metadata.allowExtensions: true


define view I_ProfitCenterTP
  as select from P_ProfitCenterTP

  association [0..*] to I_ProfitCenterTextTP        as _MultiLangText               on  $projection.ControllingArea = _MultiLangText.ControllingArea
                                                                                    and $projection.ProfitCenter    = _MultiLangText.ProfitCenter
                                                                                    and $projection.ValidityEndDate = _MultiLangText.ValidityEndDate

  association [1]    to I_ControllingArea           as _ControllingAreaForEdit      on  $projection.ControllingAreaForEdit = _ControllingAreaForEdit.ControllingArea
  association [0..*] to I_ProfitCenterHierarchyNode as _ProfitCenterHierNodeForEdit on  $projection.ControllingAreaForEdit = _ProfitCenterHierNodeForEdit.ControllingArea
                                                                                    and $projection.ProfitCenterForEdit    = _ProfitCenterHierNodeForEdit.ProfitCenter

  association [0..*] to I_PrftCtrCompCodeAssgmtTP   as _CompanyCodeAssignment       on  $projection.ControllingArea = _CompanyCodeAssignment.ControllingArea
                                                                                    and $projection.ProfitCenter    = _CompanyCodeAssignment.ProfitCenter
                                                                                    and $projection.ValidityEndDate = _CompanyCodeAssignment.ValidityEndDate

  //Extention Include

  association [1..1] to E_ProfitCenter              as _Extension                   on  $projection.ControllingArea = _Extension.ControllingArea
                                                                                    and $projection.ProfitCenter    = _Extension.ProfitCenter
                                                                                    and $projection.ValidityEndDate = _Extension.ValidityEndDate
{
  key ControllingArea,
  key ProfitCenter,
  key ValidityEndDate,
      @ObjectModel.foreignKey.association: '_ControllingAreaForEdit'
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.editableFieldFor: 'ControllingArea'
      ControllingArea                                                                              as ControllingAreaForEdit,
      @ObjectModel.hierarchy.association: '_ProfitCenterHierNodeForEdit'
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.editableFieldFor: 'ProfitCenter'
      ProfitCenter                                                                                 as ProfitCenterForEdit,
      @Semantics.businessDate.to: true
      @ObjectModel.mandatory: true
      @ObjectModel.editableFieldFor: 'ValidityEndDate'
      ValidityEndDate                                                                              as ValidityEndDateForEdit,
      @Semantics.businessDate.from: true
      @ObjectModel.mandatory: true
      ValidityStartDate,
      @ObjectModel.mandatory: true
      ProfitCenterName,
      ProfitCenterLongName,
      //      @ObjectModel.mandatory: true

      //@ObjectModel.foreignKey.association: '_CompanyCode'

      CompanyCode,
      @ObjectModel.mandatory: true
      ProfitCtrResponsiblePersonName,
      ProfitCtrResponsibleUser,
      @ObjectModel.readOnly: true
      ProfitCenterCreationDate,
      @ObjectModel.readOnly: true
      ProfitCenterCreatedByUser,
      Department,
      @ObjectModel.mandatory: true
      ProfitCenterStandardHierarchy,
      Segment,
      ProfitCenterIsBlocked,
      Country,
      FormOfAddress,  //Title anred

      AddressName,    //Name1 name1

      AdditionalName, //Name2 name2

      CityName,       //City  ort01

      District,       //District ort02

      ProfitCenterAddrName3, //Name3 name3

      ProfitCenterAddrName4, //Name4 name4

      StreetAddressName,     //Street stras

      POBox,                 //P.O.Box PFACH

      PostalCode,            //Postal Code PSTLZ

      POBoxPostalCode,
      Region,                //Region REGIO

      TaxJurisdiction, //Tax Jur. TXJCD

      Language,        //Language spras

      TeleboxNumber,   //Telebox   telbx

      PhoneNumber1,    //Telephone 1 telf1

      PhoneNumber2,    //Telephone 2 telf2

      FaxNumber,       //Fax Number telfx

      TelexNumber,     //Telex telx1

      TeletexNumber,
      DataCommunicationPhoneNumber, //Data line datlt

      ProfitCenterPrinterName, //Printer name drnam

      @ObjectModel.readOnly: true
      ControllingAreaName,
      @ObjectModel.readOnly: true
      CompanyCodeName,
      @ObjectModel.readOnly: true
      CreatedByUserFullName,

      cast(concat ( concat( ControllingArea, ProfitCenter), ValidityEndDate ) as hash160)          as ETag,
      ChangeDocObject,

      // following 2 fields are for authority check.

      @ObjectModel.readOnly: true
      ProfitCenterResponsibilityArea,
      @ObjectModel.readOnly: true
      ProfitCenterHierarchyRespyArea,

      cast('' as fac_mpc_tp_action)                                                                as PrftCtrTransaclProcgAction,

      @ObjectModel.readOnly: true
      cast( concat(ValidityStartDate, concat('-',ValidityEndDate)) as profitcentervalidityperiod ) as ProfitCenterValidityPeriod,

      _Text,
      _Country,
      _ControllingArea,
      _ControllingAreaForEdit,
      _ProfitCenterHierarchyNode,
      _ProfitCenterHierNodeForEdit,
      _Language,
      _Company,
      _Region,
      _ControllingAreaText,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _CompanyCodeAssignment,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _MultiLangText,

      _UserCrtedContactCard

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PROFITCENTERTP"
],
"ASSOCIATED":
[
"E_PROFITCENTER",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_LANGUAGE",
"I_PRFTCTRCOMPCODEASSGMTTP",
"I_PROFITCENTERHIERARCHYNODE",
"I_PROFITCENTERTEXT",
"I_PROFITCENTERTEXTTP",
"I_REGION",
"I_USERCONTACTCARD"
],
"BASE":
[
"P_PROFITCENTERTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/