CostCentersMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CostCentersMD
Descripción general
Esta vista de informes proporciona una descripción general completa de los datos maestros del centro de coste en los sistemas SAP. Combina datos de las tablas CSKS y CSKT para proporcionar una única fuente de información del centro de coste.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| CSKS | Tabla de Datos Maestros del Centro de Coste |
| CSKT | Tabla de Textos del Centro de Coste |
Casos de uso clave
- Informes y análisis del centro de coste
- Presupuesto y planificación
- Asignación de costes y precios de transferencia
- Integración con otros módulos SAP, como FI y CO
Lógica de consulta
La vista filtra los datos de las tablas CSKS y CSKT en función de la fecha actual para garantizar que solo se incluyan los centros de coste activos. También une las tablas en los campos MANDT, KOKRS y KOSTL para garantizar que los textos del centro de coste se asocien correctamente con los datos maestros del centro de coste.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| KS01 | Crear Centro de Coste |
| KS02 | Cambiar Centro de Coste |
| KS03 | Mostrar Centro de Coste |
| KS04 | Bloquear Centro de Coste |
| KS05 | Desbloquear Centro de Coste |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| Client_MANDT | Client | |
| ControllingArea_KOKRS | Controlling Area | |
| CostCenter_KOSTL | Cost Center | |
| ValidTo_DATBI | Valid To | |
| ValidFromDate_DATAB | Valid From Date | |
| LockIndicatorForActualPrimaryPostings_BKZKP | Lock Indicator For Actual Primary Postings | |
| LockIndicatorForPlanPrimaryCosts_PKZKP | Lock Indicator For Plan Primary Costs | |
| CompanyCode_BUKRS | Company Code | |
| BusinessArea_GSBER | Business Area | |
| CostCenterCategory_KOSAR | Cost Center Category | |
| PersonResponsible_VERAK | Person Responsible | |
| UserResponsible_VERAK_USER | User Responsible | |
| CurrencyKey_WAERS | Currency Key | |
| CostingSheet_KALSM | Costing Sheet | |
| TaxJurisdiction_TXJCD | Tax Jurisdiction | |
| ProfitCenter_PRCTR | Profit Center | |
| Plant_WERKS | Plant | |
| LogicalSystem_LOGSYSTEM | Logical System | |
| CreatedOn_ERSDA | Created On | |
| EnteredBy_USNAM | Entered By | |
| LockIndicatorForActualSecondaryCosts_BKZKS | Lock Indicator For Actual Secondary Costs | |
| LockIndicatorForActualRevenuePostings_BKZER | Lock Indicator For Actual Revenue Postings | |
| LockIndicatorForCommitmentUpdate_BKZOB | Lock Indicator For Commitment Update | |
| LockIndicatorForPlanSecondaryCosts_PKZKS | Lock Indicator For Plan Secondary Costs | |
| LockIndicatorForPlanningRevenues_PKZER | Lock Indicator For Planning Revenues | |
| IndicatorForAllowedAllocationMethods_VMETH | Indicator For Allowed Allocation Methods | |
| IndicatorForRecordingConsumptionQuantities_MGEFL | Indicator For Recording Consumption Quantities | |
| Department_ABTEI | Department | |
| SubsequentCostCenter_NKOST | Subsequent Cost Center | |
| UsageOfTheConditionTable_KVEWE | Usage Of The Condition Table | |
| Application_KAPPL | Application | |
| CoCcaOverheadKey_KOSZSCHL | CoCca Overhead Key | |
| CountryKey_LAND1 | Country Key | |
| Title_ANRED | Title | |
| Name1_NAME1 | Name1 | |
| Name2_NAME2 | Name2 | |
| Name3_NAME3 | Name3 | |
| Name4_NAME4 | Name4 | |
| 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 | |
| Region_REGIO | Region | |
| LanguageKey_SPRAS | Language Key | |
| 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 | |
| PrinterDestinationForCctrReport_DRNAM | Printer Destination For Cctr Report | |
| StandardHierarchyArea_KHINR | Standard Hierarchy Area | |
| CostCollectorKey_CCKEY | Cost Collector Key | |
| CompletionFlagForTheCostCenterMasterRecord_KOMPL | Completion Flag For The Cost Center Master Record | |
| IndicatorObjectIsStatistical_STAKZ | Indicator Object Is Statistical | |
| ObjectNumber_OBJNR | Object Number | |
| FunctionOfCostCenter_FUNKT | Function Of Cost Center | |
| AlternativeFunctionOfCostCenter_AFUNK | Alternative Function Of Cost Center | |
| TemplateForActivityIndependentFormulaPlanning_CPI_TEMPL | Template For Activity Independent Formula Planning | |
| TemplateForActivityDependentFormulaPlanning_CPD_TEMPL | Template For Activity Dependent Formula Planning | |
| FunctionalArea_FUNC_AREA | Functional Area | |
| Template_ActivityIndependentAllocationToCostCenter_SCI_TEMPL | Template Activity Independent Allocation To Cost Center | |
| Template_ActivityDependentAllocationToCostCenter_SCD_TEMPL | Template Activity Dependent Allocation To Cost Center | |
| Template_ActualStatisticalKeyFigureOnCostCenter_SKI_TEMPL | Template Actual Statistical Key Figure On Cost Center | |
| Template_ActStatKeyFigureCostCenteractivityType_SKD_TEMPL | Template Act Stat Key Figure Cost Centeractivity Type | |
| JointVenture_VNAME | Joint Venture | |
| RecoveryIndicator_RECID | Recovery Indicator | |
| EquityType_ETYPE | Equity Type | |
| JointVentureObjectType_JV_OTYPE | Joint Venture Object Type | |
| JibjibeClass_JV_JIBCL | Jibjibe Class | |
| JibjibeSubclassA_JV_JIBSA | Jibjibe Subclass A | |
| RegulatoryIndicator_FERC_IND | Regulatory Indicator | |
| Language_SPRAS | Language | |
| GeneralName_KTEXT | General Name | |
| Description_LTEXT | Description | |
| SearchTermForMatchcodeUse_MCTXT | Search Term For Matchcode Use |