Sales Overview 
Technical Name: 0SD_C03
Use
This InfoCube contains all transaction data from sales orders, deliveries and billing documents/invoices.
As of SAP BI Content 3.3 Add-On you can evaluate sales scheduling agreements that are planned in SAP APO in the SAP Business Information Warehouse (SAP BW).
This InfoCube can be filled with data on APO sales scheduling agreements from the ODS object Assignment of Deliveries to Requirements (0CDS_DS07) using the update rule.
The ODS object Assignment of Deliveries to Requirements (0CDS_DS07) can only be updated in this InfoCube with a full update.
For more
information, see 
Process Chain Sales
Scheduling Agreement Processing.
InfoSources
2LIS_01_S260: SD -
Sales order
2LIS_01_S261: SD
– Delivery
2LIS_01_S262: SD -
Billing document
2LIS_01_S263: SD -
Sales order / delivery
Characteristics
|
InfoObject |
Description |
|
|
0BILLTOPRTY |
Bill-to party |
|
|
0COMP_CODE |
Company code |
|
|
0DISTR_CHAN |
Distribution channel |
|
|
0DOC_CATEG |
Sales document category |
|
|
0PLANT |
Plant |
|
|
0SALESORG |
Sales organization |
|
|
0SALES_GRP |
Sales group |
|
|
0SALES_OFF |
Sales office |
|
|
0SHIP_TO |
Ship-to party |
|
|
0SOLD_TO |
Sold-to party |
|
|
0VERSION |
Version |
|
|
0VTYPE |
Value type for reporting |
|
|
0DIVISION |
Division |
|
|
0MATERIAL |
Material number |
|
|
0SHIP_POINT |
Shipping point |
|
|
0PAYER |
Payer |
|
|
0DOC_CLASS |
Document class Order/Delivery/Invoice |
|
|
0DEB_CRED |
Credit/debit postings (C/D) |
|
|
0DIVISION |
The division is updated from the document item. |
|
|
0DEB_CRED |
Credit/Debit Postings (C/D) Differentiates between target and actual documents. The following sales document categories (0DOC_CATEG = VBTYP) generate target postings in the InfoCube: · Sales order processing: ¡ Credit memo request (VBTYP = K) ¡ Returns (VBTYP = H) · Delivery processing: ¡ Return delivery (VBTYP = T) · Invoice processing: ¡ Credit memo (VBTYP = O) ¡ Cancelled invoice (VBTYP = N) ¡ Internal consumption (credit) (VBTYP = 6) All other categories of sales documents generate actual postings in the InfoCube. |
|
|
0DOC_CLASS |
· Document classification: Order/Delivery/Invoice · Classifies documents as order, delivery and invoicing (billing) documents: ¡ O = Order ¡ D = Delivery ¡ I = Invoice |
|
A combination of 0DOC_CLASS and 0DEB_CRED enables you to classify all sales documents simply.
For example:
|
Key figure |
0DOC_CLASS |
0DEB_CRED |
Significance
|
|
Incoming orders |
O |
D |
Positive sales documents (orders, scheduling agreements, etc.) |
|
Returns |
O |
C |
Negative sales documents (returns, credit memo requests, etc.) |
Time Characteristics
In the standard system, the month is updated from the info structure.
|
InfoObject |
Description |
|
0CALDAY |
Calendar day |
|
0CALMONTH |
Calendar year / month |
|
0CALWEEK |
Calendar year / week |
|
0FISCPER |
Fiscal year / period |
|
0FISCVARNT |
Fiscal year variant |
Key Figures
|
InfoObject |
Description |
||
|
0SUBTOT_1S |
Pricing subtotal 1 from pricing determination procedure in statistics currency |
||
|
0SUBTOT_2S |
Pricing subtotal 2 from pricing determination procedure in statistics currency |
||
|
0SUBTOT_3S |
Pricing subtotal 3 from pricing determination procedure in statistics currency |
||
|
0SUBTOT_4S |
Pricing subtotal 4 from pricing determination procedure in statistics currency |
||
|
0SUBTOT_5S |
Pricing subtotal 5 from pricing determination procedure in statistics currency |
||
|
0SUBTOT_6S |
Pricing subtotal 6 from pricing determination procedure in statistics currency |
||
|
0OPORDQTYBM |
Open order quantity in base unit of measure |
||
|
0OPORDVALSC |
Net open order value in statistics currency. |
||
|
0DLV_QTY_BM |
Actual delivered quantity in base unit of measure |
||
|
0QUANT_B |
Quantity in base unit of measure |
||
|
0DOCUMENTS |
Number of documents |
||
|
0DOC_ITEMS |
Number of document items |
||
|
0NET_VAL_S |
Net value in statistics currency |
||
|
0COST_VAL_S |
Cost in statistics currency |
||
|
0GR_WT_KG |
Gross weight in kilograms |
||
|
0NT_WT_KG |
Net weight in kilograms |
||
|
0VOLUME_CDM |
Volumes in cubic decimeters |
||
|
|
0DOCUMENTS |
Number of documents (document counter) We recommend that you only use the document counter along with characteristics from the document header (header characteristics). For example, 0SALES_ORG, 0DISTR_CHAN, 0BILLTOPRTY, 0SHIP_TO, 0SOLD_TO, 0PAYER, 0DOC_CATEG.
|
|
Units
|
InfoObject |
Description |
|
0STAT_CURR |
Statistics currency |
|
0BASE_UOM |
Base unit of measure |