Accepted Solutions (1)
Data Source: Sales Order Item
Object Information
| Data Source Name | Sales Order Item |
| Data Source ID | CODCOIB |
| Description | Contains data on the quantities and values of sales order items. It allows you to analyze the distribution of sales order items across organizational units. |
| Type | Basic Data Source |
| Origin | SAP |
| Obsolete |
Documentation
Show full documentation
Hide documentationNo documentation available.
| Access Context Name | Access Context ID |
|---|---|
| Employee or Territory or Sales Data | 1015 |
Overview of Fields
| Characteristic Name | Characteristic ID | Data Type | Master Data - Data Source | Master Data - Characteristic | Visibility |
|---|---|---|---|---|---|
| Posting Date | ACO_DOC_POSTING_DATE | Date field (YYYYMMDD) stored as char(8) | Visible for Report Modelling | ||
| Month | ACO_DOC_POSTING_MONTH | Character String | Visible for Report Modelling | ||
| Quarter | ACO_DOC_POSTING_QUARTER | Character String | Visible for Report Modelling | ||
| Weekday | ACO_DOC_POSTING_WEEK_DAY_CODE | Character String | Visible for Report Modelling | ||
| Year | ACO_DOC_POSTING_YEAR | Character String | Visible for Report Modelling | ||
| Year Month | ACO_DOC_POSTING_YEAR_MONTH | Character String | Visible for Report Modelling | ||
| Year Quarter | ACO_DOC_POSTING_YEAR_QUARTER | Character String | Visible for Report Modelling | ||
| Year Week | ACO_DOC_POSTING_YEAR_WEEK | Character String | Visible for Report Modelling | ||
| Parent Item ID | ACO_ITM_PARENT_ITEM_ID | Alphanumeric Character String | Visible for Report Modelling | ||
| Item Posting Date | ACO_ITM_POSTING_DATE | Date field (YYYYMMDD) stored as char(8) | Visible for Report Modelling | ||
| Posting Month (Item) | ACO_ITM_POSTING_MONTH | Character String | Visible for Report Modelling | ||
| Posting Quarter (Item) | ACO_ITM_POSTING_QUARTER | Character String | Visible for Report Modelling | ||
| Posting Weekday (Item) | ACO_ITM_POSTING_WEEK_DAY_CODE | Character String | Visible for Report Modelling | ||
| Posting Year (Item) | ACO_ITM_POSTING_YEAR | Character String | Visible for Report Modelling | ||
| Posting Year Month (Item) | ACO_ITM_POSTING_YEAR_MONTH | Character String | Visible for Report Modelling | ||
| Posting Year Quarter (Item) | ACO_ITM_POSTING_YEAR_QUARTER | Character String | Visible for Report Modelling | ||
| Posting Year Week (Item) | ACO_ITM_POSTING_YEAR_WEEK | Character String | Visible for Report Modelling | ||
| Currency of Net Amount | ACO_ITV_NET_AMT_CURR | Character String | Visible for Report Modelling | ||
| Price Currency | ACO_ITV_NET_PRICE_AMOUNT_CURR | Character String | Visible for Report Modelling | ||
| Requested Quantity Unit | ACO_ITV_REQU_QTY_UNT | Character String | Visible for Report Modelling | ||
| Currency of Tax Amount | ACO_ITV_TAX_AMOUNT_CURR_CD | Character String | Visible for Report Modelling | ||
| Distribution Channel | CCO_DBA_DISTR_CHAN_CODE | Character String | Visible for Report Modelling | ||
| Division | CCO_DBA_DIVISION_CODE | Character String | Visible for Report Modelling | ||
| Sales Organization | CCO_DBA_SALES_ORG_UUID | Uninterpreted sequence of bytes | Functional Unit Master Data | Functional Unit | Visible for Report Modelling |
| Sales Territory | CCO_DBA_SLS_TERRITORY_ID | Character String | Visible for Report Modelling | ||
| External Reference | CCO_DOC_BUYER_ID | Alphanumeric Character String | Visible for Report Modelling | ||
| Changed By | CCO_DOC_CHANGED_BY_UUID | Uninterpreted sequence of bytes | CCAIDNTYB_SOL | IDNTYUUID | Visible for Report Modelling |
| Sales Order ID | CCO_DOC_ID | Alphanumeric Character String | Visible for Report Modelling | ||
| Sales Order | CCO_DOC_UUID | Uninterpreted sequence of bytes | Sales Order Header | Sales Order | Visible for Report Modelling |
| Sales Employee | CCO_DPY_SLS_EMP_PTY_UUID | Uninterpreted sequence of bytes | Employee Master Data (deprecated) | Employee | Visible for Report Modelling |
| Sales Partner | CCO_DPY_SLS_PRT_PTY_UUID | Uninterpreted sequence of bytes | Business Partner Master Data | Business Partner | Visible for Report Modelling |
| Original Product | CCO_IPR_ORIG_PRODUCT | Uninterpreted sequence of bytes | Visible for Report Modelling | ||
| Product Category | CCO_IPR_PRD_CATEGORY_ID | Alphanumeric Character String | Visible for Report Modelling | ||
| Product Type | CCO_IPR_PRD_TYPE_CD | Character String | Visible for Report Modelling | ||
| Product | CCO_IPR_PRODUCT | Uninterpreted sequence of bytes | Product Master Data | Product | Visible for Report Modelling |
| Quantity UoM | CCO_IPR_QTY_MEAS_UNT_CD | Character String | Visible for Report Modelling | ||
| Account | CCO_IPY_BUYER_PTY_UUID | Uninterpreted sequence of bytes | Account Master Data (deprecated) | Account | Visible for Report Modelling |
| Employee Responsible | CCO_IPY_EMPL_RSP_PTY_UUID | Uninterpreted sequence of bytes | Employee Master Data (deprecated) | Employee | Visible for Report Modelling |
| Ship-To | CCO_IPY_PROD_REC_PTY_UUID | Uninterpreted sequence of bytes | Business Partner Master Data | Business Partner | Visible for Report Modelling |
| Seller | CCO_IPY_SELLER_PTY_UUID | Uninterpreted sequence of bytes | Company Master Data | Company | Visible for Report Modelling |
| Sales Unit | CCO_IPY_SLS_UNIT_PTY_UUID | Uninterpreted sequence of bytes | Functional Unit Master Data | Functional Unit | Visible for Report Modelling |
| Product Availability Confirmation Commitment | CCO_ISL_ITM_AVAIL_CONFIRM_CD | Character String | Visible for Report Modelling | ||
| Item Confirmed Date | CCO_ISL_ITM_CONFIRMED_DATE | Counter or amount field with comma and sign | Visible for Report Modelling | ||
| Reason for Rejection | CCO_IST_CANCEL_REASON_CD | Character String | Visible for Report Modelling | ||
| Item Changed By | CCO_ITM_CHANGED_BY_UUID | Uninterpreted sequence of bytes | CCAIDNTYB_SOL | IDNTYUUID | Visible for Report Modelling |
| Sales Order Item ID | CCO_ITM_ID | Alphanumeric Character String | Visible for Report Modelling | ||
| Item Processing Type | CCO_ITM_PROC_TYPE_CD | Character String | Visible for Report Modelling | ||
| Approval Status | CCO_ITM_S_APPROVAL | Character String | Visible for Report Modelling | ||
| ATP | CCO_ITM_S_AVAILABILITY | Character String | Visible for Report Modelling | ||
| Cancellation Status (Item) | CCO_ITM_S_CANCELLATION | Character String | Visible for Report Modelling | ||
| Consistency Status (Item) | CCO_ITM_S_CONSISTENCY | Character String | Visible for Report Modelling | ||
| Item Delivery Status | CCO_ITM_S_FULFILMENT | Character String | Visible for Report Modelling | ||
| Completeness Status | CCO_ITM_S_GEN_DATA | Character String | Visible for Report Modelling | ||
| Item Billing Status | CCO_ITM_S_INVOICING | Character String | Visible for Report Modelling | ||
| Item Status | CCO_ITM_S_QUOTE | Character String | Visible for Report Modelling | ||
| Item Document Type | CCO_ITM_TYPE_CD | Character String | Visible for Report Modelling | ||
| Sales Order Item | CCO_ITM_UUID | Uninterpreted sequence of bytes | Visible for Report Modelling | ||
| Confirmed Quantity Unit | ISL_ITM_CONFIRMED_QTY_CURR_CD | Character String | Visible for Report Modelling |
| Key Figure Name | Key Figure ID | Key Figure Type | Data Type | Aggregation Type | Unit/Currency Field | Visibility |
|---|---|---|---|---|---|---|
| Item Net Amount | ACO_ITV_NET_AMT | Amount | Counter or amount field with comma and sign | Summation | Currency of Net Amount | Visible for Report Modelling |
| Item Net Price | ACO_ITV_NET_PRICE_AMOUNT | Amount | Counter or amount field with comma and sign | Summation | Price Currency | Visible for Report Modelling |
| Requested Item Quantity | ACO_ITV_REQU_QTY | Quantity | Counter or amount field with comma and sign | Summation | Requested Quantity Unit | Visible for Report Modelling |
| Item Tax Amount | ACO_ITV_TAX_AMOUNT | Amount | Counter or amount field with comma and sign | Summation | Currency of Tax Amount | Visible for Report Modelling |
| Sales Order Confirmed Quantity | ISL_ITM_CONFIRMED_QUANTITY | Quantity | Counter or amount field with comma and sign | Summation | Confirmed Quantity Unit | Visible for Report Modelling |
| Counter | 0COUNT | Value | 4-byte integer, integer number with sign | Summation | Visible for End User Personalization |
Where Used List
No usages found
Answers (1)
Data Source: Sales Order Header
Object Information
| Data Source Name | Sales Order Header |
| Data Source ID | CODCOHB |
| Description | Contains data on the quantities and values of sales orders in total. It allows you to analyze the distribution of sales orders across organizational units. |
| Type | Basic Data Source |
| Origin | SAP |
| Obsolete |
Documentation
No documentation available.
| Access Context Name | Access Context ID |
|---|---|
| Employee or Territory or Sales Data | 1015 |
Overview of Fields
| Characteristic Name | Characteristic ID | Data Type | Master Data - Data Source | Master Data - Characteristic | Visibility |
|---|---|---|---|---|---|
| Created On | ACO_DOC_CREATED_DATE | Date field (YYYYMMDD) stored as char(8) | Visible for Report Modelling | ||
| Posting Date | ACO_DOC_POSTING_DATE | Date field (YYYYMMDD) stored as char(8) | Visible for End User Personalization | ||
| Month | ACO_DOC_POSTING_MONTH | Character String | Visible for End User Personalization | ||
| Quarter | ACO_DOC_POSTING_QUARTER | Character String | Visible for End User Personalization | ||
| Weekday | ACO_DOC_POSTING_WEEK_DAY_CODE | Character String | Visible for End User Personalization | ||
| Year | ACO_DOC_POSTING_YEAR | Character String | Visible for End User Personalization | ||
| Year Month | ACO_DOC_POSTING_YEAR_MONTH | Character String | Visible for End User Personalization | ||
| Year Quarter | ACO_DOC_POSTING_YEAR_QUARTER | Character String | Visible for End User Personalization | ||
| Year Week | ACO_DOC_POSTING_YEAR_WEEK | Character String | Visible for End User Personalization | ||
| External ID | CCO_BTD_REF_ID_CONTENT | Alphanumeric Character String | Visible for End User Personalization | ||
| Distribution Channel | CCO_DBA_DISTR_CHAN_CODE | Character String | Visible for End User Personalization | ||
| Division | CCO_DBA_DIVISION_CODE | Character String | Visible for End User Personalization | ||
| Sales Organization | CCO_DBA_SALES_ORG_UUID | Uninterpreted sequence of bytes | /MOM/FUNCUNIT | Functional Unit | Visible for End User Personalization |
| Sales Territory | CCO_DBA_TERRITORY_ID | Character String | Visible for End User Personalization | ||
| Payment Terms | CCO_DCDT_PAYMENT_TERMS | Character String | Visible for Report Modelling | ||
| Delivery Priority | CCO_DDT_DELIVERY_PRIORITY_CD | Character String | Visible for End User Personalization | ||
| Incoterms | CCO_DDT_INCOTERMS_CLASSIF_CD | Character String | Visible for End User Personalization | ||
| Incoterms Location | CCO_DDT_INCOTERMS_LOCATION | Character String | Visible for End User Personalization | ||
| External Reference | CCO_DOC_BUYER_ID | Alphanumeric Character String | Visible for End User Personalization | ||
| Created By | CCO_DOC_CREATED_BY_UUID | Uninterpreted sequence of bytes | CCAIDNTYB_SOL | IDNTYUUID | Visible for End User Personalization |
| Fulfilment Block Reason | CCO_DOC_FULF_BLOCK_REASON_CD | Character String | Visible for End User Personalization | ||
| Sales Order ID | CCO_DOC_ID | Alphanumeric Character String | Visible for End User Personalization | ||
| Billing Block Reason | CCO_DOC_INV_BLOCK_REASON_CD | Character String | Visible for End User Personalization | ||
| Order Reason | CCO_DOC_ORDER_REASON | Character String | Visible for End User Personalization | ||
| Document Type | CCO_DOC_PROC_TYPE_CD | Character String | Visible for End User Personalization | ||
| Cancellation Status | CCO_DOC_S_AG_CANCELLATION | Character String | Visible for End User Personalization | ||
| Consistency Status | CCO_DOC_S_AG_CONSISTENCY | Character String | Visible for Report Modelling | ||
| Delivery Status | CCO_DOC_S_AG_FULFILMENT | Character String | Visible for End User Personalization | ||
| Creditworthiness Status | CCO_DOC_S_CREDIT_WORTH | Character String | Visible for End User Personalization | ||
| External Overall Status | CCO_DOC_S_EXTERNAL_LC | Character String | Visible for End User Personalization | ||
| BlockingStatusCode | CCO_DOC_S_OVERALL_BLOCKING | Character String | Visible for End User Personalization | ||
| Transfer Status | CCO_DOC_S_REPLICATION | Character String | Visible for Report Modelling | ||
| Sales Order | CCO_DOC_UUID | Uninterpreted sequence of bytes | Visible for Report Modelling | ||
| Pricing Date | CCO_DPT_PRICE_DATE_TIME | Counter or amount field with comma and sign | Visible for End User Personalization | ||
| Reason for Rejection | CCO_DST_CANCEL_REASON_CD | Character String | Visible for End User Personalization | ||
| Currency of Gross Amount | CCO_DTV_GROSS_AMOUNT_CURR_CD | Character String | Visible for End User Personalization | ||
| Currency of Net Amount | CCO_DTV_NET_AMOUNT_CURRENCY_CD | Character String | Visible for End User Personalization | ||
| Currency of Tax Amount | CCO_DTV_TAX_AMOUNT_CURRENCY_CD | Character String | Visible for End User Personalization | ||
| Account | CCO_DOC_BUYER_PARTY | Uninterpreted sequence of bytes | CODCUSTOMER | Account | Visible for End User Personalization |
| Buyer Party Role category | CCO_DOC_BUYER_ROLE_CAT_CD | Character String | Visible for MDAV Modelling | ||
| Sales Unit | CCO_DOC_SALES_UNIT | Uninterpreted sequence of bytes | /MOM/ORGCENTRE | Org Unit | Visible for End User Personalization |
| Sales Unit Party Role Category | CCO_DOC_SALES_UNIT_ROLE_CAT | Character String | Visible for MDAV Modelling |
| Key Figure Name | Key Figure ID | Key Figure Type | Data Type | Aggregation Type | Unit/Currency Field | Visibility |
|---|---|---|---|---|---|---|
| Gross Amount | CCO_DTV_GROSS_AMOUNT | Amount | Counter or amount field with comma and sign | Summation | Currency of Gross Amount | Visible for End User Personalization |
| Net Amount | CCO_DTV_NET_AMOUNT_CONTENT | Amount | Counter or amount field with comma and sign | Summation | Currency of Net Amount | Visible for End User Personalization |
| Tax Amount | CCO_DTV_TAX_AMOUNT_CONTENT | Amount | Counter or amount field with comma and sign | Summation | Currency of Tax Amount | Visible for End User Personalization |
| Counter | 0COUNT | Value | 4-byte integer, integer number with sign | Summation | Visible for End User Personalization |
Where Used List
| Object Type | Object Name | Object ID | Association |
|---|---|---|---|
| Data Source | Sales Order Item | CODCOIB | USED_AS_MDR |
| User | Count |
|---|---|
| 5 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.