ProfitCentersMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - 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
- Reporting on profit center data
- Analysis of profit center performance
- Identification of profit center trends
- Planning and forecasting for profit centers
Query Logic
The query logic first joins the CEPC and CEPCT tables on the MANDT, PRCTR, DATBI, and KOKRS fields. It then filters the results to only include profit centers that are valid as of the current date. Finally, the query selects a wide range of profit center data, including general information, financial data, and contact information.
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 |
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 |