ProfitCentersMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - ProfitCentersMD
Descripción general
Esta vista de informes proporciona una descripción general completa de los datos del centro de beneficio de los sistemas SAP. Combina datos de las tablas CEPC y CEPCT para proporcionar una única fuente de información real del centro de beneficio.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| CEPC | Datos maestros del centro de beneficio |
| CEPCT | Textos del centro de beneficio |
Casos de uso clave
- Informes sobre datos del centro de beneficio
- Análisis del rendimiento del centro de beneficio
- Identificación de tendencias del centro de beneficio
- Planificación y previsión para centros de beneficio
Lógica de consulta
La lógica de consulta primero une las tablas CEPC y CEPCT en los campos MANDT, PRCTR, DATBI y KOKRS. Luego filtra los resultados para incluir solo los centros de beneficio válidos a la fecha actual. Finalmente, la consulta selecciona una amplia gama de datos del centro de beneficio, incluyendo información general, datos financieros e información de contacto.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| KP06 | Crear centro de beneficio |
| KP07 | Cambiar centro de beneficio |
| KP08 | Mostrar centro de beneficio |
| KP09 | Eliminar centro de beneficio |
| KP10 | Mantenimiento masivo de centros de beneficio |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| 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 |