# View: sony_internal_prod_sapca_profit_center

**View Name:** sony_internal_prod_sapca_profit_center
**Table Source:** `Derived from: Prod.Sapca_Profit_Center, Sony_Internal, Sony_Internal.Prod`
**File Path:** `sony_internal_prod_sapca_profit_center.view.lkml`

## Overview

- **File Size:** 576 bytes
- **Lines of Code:** 26
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `sap_profit_center_cd` | string |
| `orchard_label_id` | number |

## Derived Table

```sql
sql: select orchard_label_id, listagg(sap_profit_center_cd, ', ') as sap_profit_center_cd
          from sony_internal.prod.sapca_profit_center
          where sap_profit_center_cd like 'CA6%'
          group by 1;;
```