Show TOC

SD: Sales Document Header Data - /IMO/SD_D10 Locate this document in the navigation structure

DataStore object DataStore object: /IMO/SD_D10

 

This DSO contains sales document header data for orders and quotations (but not for requests).

InfoSource

This DSO is filled by the InfoSource Sales Document Header Data (2LIS_11_VAHDR) (technical name: /IMO/SD_IS10).

Transformation

Name of Target InfoObject

Technical Name of Target InfoObject

Transformation Rule

Document Classification*

0DOC_CLASS

Restrict to “O” (Order).

Credit/Debit posting*

0DEB_CRED

Fill with “D” (Debit, for sales order documents) or “C” (Credit, for returns)

No. of Sales Order Documents

0SO_H_CNT

Reverse sign for returns and set to 0 for deleted documents.

Update Date

0UPD_DATE

Fill with the system date during the data load

Generic Customer

0GN_CUSTOM

Concatenate the System ID, Object Type, and Customer Number.

BW Delta Process: Update Mode

0RECORDMODE

Change of Reverse Images toAfter Images.

Header Deleted

0HEADER_DEL

Indicate deleted header documents.

No. of deleted Documents

0DLT_H_CNT

Count deleted header documents.

For more information about document classification in SD, see the overview page Sales and Distribution (SAP HANA-Optimized).

Structure

Delta Update

The following delta update is supported for this DataStore object:

  • Delta update: ABR: Complete Delta with deletion flag Via Delta Queue (Cube-Comp)

  • DataSource: 2LIS_11_VAHDR

Data Modeling

Key Fields

Object Type

Name

Technical Name

Characteristic

Sales document

0DOC_NUMBER

Data Fields

Object Type

Name

Technical Name

Time characteristic

Calendar Day

0CALDAY

Time characteristic

Calendar Year/Month

0CALMONTH

Time characteristic

Calendar Year/Quarter

0CALQUARTER

Time characteristic

Calendar Year

0CALYEAR

Characteristic

Company code

0COMP_CODE

Characteristic

Credit/debit posting (C/D)

0DEB_CRED

Characteristic

Distribution Channel

0DISTR_CHAN

Key figure

No. of deleted Documents

0DLT_H_CNT

Characteristic

Sales Document Category

0DOC_CATEG

Characteristic

Document category /Quotation/Order/Delivery/Invoice

0DOC_CLASS

Time characteristic

Fiscal year / period

0FISCPER

Time characteristic

Fiscal year variant

0FISCVARNT

Time characteristic

Fiscal year

0FISCYEAR

Characteristic

Customer

0GN_CUSTOM

Characteristic

Source System for R/3 Entity

0GN_R3_SSY

Characteristic

Header Deleted

0HEADER_DEL

Unit of measurement

Local currency

0LOC_CURRCY

Characteristic

Quotation validity date (quotation is valid from ...)

0QUOT_FROM

Characteristic

Date until which bid/quotation is binding (valid-to date)

0QUOT_TO

Data packet characteristic

BW Delta Process: Update Mode

0RECORDMODE

Characteristic

Sales Representative

0SALESEMPLY

Characteristic

Sales Organization

0SALESORG

Characteristic

Sales group

0SALES_GRP

Characteristic

Sales Office

0SALES_OFF

Characteristic

Sold-to party

0SOLD_TO

Key figure

No. of Sales Order Documents

0SO_H_CNT

Unit of measurement

Statistics Currency

0STAT_CURR

Characteristic

Update Date

0UPD_DATE