ProfitCentersMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - ProfitCentersMD
Overview
This reporting view provides a comprehensive overview of profit center data from SAP systems. It combines data from the CEPC and CEPCT tables to provide a single source of truth for profit center information.
Data Sources
| Source Table/View | Description |
|---|---|
| CEPC | Profit Center Master Data |
| CEPCT | Profit Center Texts |
Key Use Cases
- Profit center analysis and reporting
- Financial planning and budgeting
- Cost center management
- Transfer pricing
- Joint venture accounting
Query Logic
The view filters the data from the CEPC and CEPCT tables based on the current date to ensure that only the most up-to-date information is displayed. It also joins the two tables on the MANDT, PRCTR, DATBI, and KOKRS fields to ensure that the data is consistent.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| KP06 | Create Profit Center |
| KP07 | Change Profit Center |
| KP08 | Display Profit Center |
| KP09 | Delete Profit Center |
| KP10 | Mass Maintenance of Profit Centers |
| KP11 | Profit Center Hierarchy |
| KP12 | Profit Center Planning |
| KP13 | Profit Center Actuals |
| KP14 | Profit Center Forecast |
| KP15 | Profit Center Budget |
| KP16 | Profit Center Profitability Analysis |
| KP17 | Profit Center Cost Analysis |
| KP18 | Profit Center Revenue Analysis |
| KP19 | Profit Center Balance Sheet |
| KP20 | Profit Center Cash Flow Statement |
| KP21 | Profit Center Trial Balance |
| KP22 | Profit Center Ledger |
| KP23 | Profit Center Document Display |
| KP24 | Profit Center Document Posting |
| KP25 | Profit Center Document Reversal |
| KP26 | Profit Center Document Cancellation |
| KP27 | Profit Center Document Voiding |
| KP28 | Profit Center Document Printing |
| KP29 | Profit Center Document Archiving |
| KP30 | Profit Center Document Deletion |
| KP31 | Profit Center Document Mass Reversal |
| KP32 | Profit Center Document Mass Cancellation |
| KP33 | Profit Center Document Mass Voiding |
| KP34 | Profit Center Document Mass Printing |
| KP35 | Profit Center Document Mass Archiving |
| KP36 | Profit Center Document Mass Deletion |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| ProfitCenter_PRCTR | Profit Center | |
| ValidToDate_DATBI | Valid To Date | |
| ControllingArea_KOKRS | Controlling Area | |
| ValidFromDate_DATAB | Valid From Date | |
| CreatedOn_ERSDA | Created On | |
| EnteredBy_USNAM | Entered By | |
| FieldNameOfCoPaCharacteristic_MERKMAL | Field Name Of CoPa Characteristic | |
| Department_ABTEI | Department | |
| PersonResponsibleForProfitCenter_VERAK | Person Responsible For Profit Center | |
| UserResponsibleForTheProfitCenter_VERAK_USER | User Responsible For The Profit Center | |
| CurrencyKey_WAERS | Currency Key | |
| SuccessorProfitCenter_NPRCTR | Successor Profit Center | |
| CountryKey_LAND1 | Country Key | |
| Title_ANRED | Title | |
| NAME1 | Name 1 | |
| NAME2 | Name 2 | |
| NAME3 | Name 3 | |
| NAME4 | Name 4 | |
| City_ORT01 | City | |
| District_ORT02 | District | |
| StreetAndHouseNumber_STRAS | Street And House Number | |
| PoBox_PFACH | Po Box | |
| PostalCode_PSTLZ | Postal Code | |
| POBoxPostalCode_PSTL2 | PO Box Postal Code | |
| CtrLanguage_SPRAS | Ctr Language | |
| TeleboxNumber_TELBX | Telebox Number | |
| FirstTelephoneNumber_TELF1 | First Telephone Number | |
| SecondTelephoneNumber_TELF2 | Second Telephone Number | |
| FaxNumber_TELFX | Fax Number | |
| TeletexNumber_TELTX | Teletex Number | |
| TelexNumber_TELX1 | Telex Number | |
| DataCommunicationLineNo_DATLT | Data Communication Line No | |
| PrinterNameForProfitCenter_DRNAM | Printer Name For Profit Center | |
| ProfitCenterArea_KHINR | Profit Center Area | |
| CompanyCode_BUKRS | Company Code | |
| JointVenture_VNAME | Joint Venture | |
| RecoveryIndicator_RECID | Recovery Indicator | |
| EquityType_ETYPE | Equity Type | |
| TaxJurisdiction_TXJCD | Tax Jurisdiction | |
| Region_state_REGIO | Region/state | |
| UsageOfTheConditionTable_KVEWE | Usage Of The Condition Table | |
| Application_KAPPL | Application | |
| Procedure__pricing__KALSM | Procedure (pricing) | |
| LockIndicator_LOCK_IND | Lock Indicator | |
| TemplateForFormulaPlanningInProfitCenters_PCA_TEMPLATE | Template For Formula Planning In Profit Centers | |
| SegmentForSegmentalReporting_SEGMENT | Segment For Segmental Reporting | |
| Language_SPRAS | Language | |
| TxtValidToDate_DATBI | Txt Valid To Date | |
| GeneralName_KTEXT | General Name | |
| LongText_LTEXT | Long Text | |
| SearchTermForMatchcodeSearch_MCTXT | Search Term For Matchcode Search |