FSH_OS_SD
Order Type specific data for sales organisation/distribution
FSH_OS_SD is an SAP database table in S/4HANA. Order Type specific data for sales organisation/distribution. It contains 23 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RFM_SlsDocTypePerSlsArea | view_entity | from | BASIC | RFM Sales Doc Type per Sales Area |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | auart | auart | Sales Doc. Type | |||
| KEY | vkorg | vkorg | Sales Org. | |||
| KEY | vtweg | vtweg | Distr. Channel | |||
| KEY | spart | spart | Division | |||
| seap_flg | fsh_seap_flg | Season Process | ||||
| seam_flg | fsh_seam_flg | Message Type | ||||
| ddate_flag | fsh_proposal_flag | Proposal Flag | ||||
| seadc_rcat | fsh_seadc | Req. Segment | ||||
| sea_det | fsh_sea_det | Season Det. | ||||
| slog_flg | fsh_seadet_log | Season Det. Log | ||||
| land1 | land1 | Country/Reg. | ||||
| regio | regio | Region | ||||
| kdgrp | kdgrp | Customer Group | ||||
| candate_flag | fsh_canceldate | Cancel Date Breached | ||||
| atp_flag | fsh_atp_flag | ATP Overview Active | ||||
| agg_level | fsh_agg_level | Aggregation Level | ||||
| fsh_vrsn_status | fsh_status_s | Enable Snapshot | ||||
| fsh_header_req | fsh_status_h | Header | ||||
| fsh_item_req | fsh_status_i | Item | ||||
| fsh_sl_req | fsh_status_sl | Schedule Line | ||||
| fsh_ss | fsh_sch_sty | Sched. Strat. | ||||
| fsh_os_run | fsh_os_run | Run OS Manually |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Order Type specific data for sales organisation/distribution
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FSH_OS_SD (
MANDT, -- Client [mandt]
AUART, -- Sales Doc. Type [auart]
VKORG, -- Sales Org. [vkorg]
VTWEG, -- Distr. Channel [vtweg]
SPART, -- Division [spart]
SEAP_FLG, -- Season Process [fsh_seap_flg]
SEAM_FLG, -- Message Type [fsh_seam_flg]
DDATE_FLAG, -- Proposal Flag [fsh_proposal_flag]
SEADC_RCAT, -- Req. Segment [fsh_seadc]
SEA_DET, -- Season Det. [fsh_sea_det]
SLOG_FLG, -- Season Det. Log [fsh_seadet_log]
LAND1, -- Country/Reg. [land1]
REGIO, -- Region [regio]
KDGRP, -- Customer Group [kdgrp]
CANDATE_FLAG, -- Cancel Date Breached [fsh_canceldate]
ATP_FLAG, -- ATP Overview Active [fsh_atp_flag]
AGG_LEVEL, -- Aggregation Level [fsh_agg_level]
FSH_VRSN_STATUS, -- Enable Snapshot [fsh_status_s]
FSH_HEADER_REQ, -- Header [fsh_status_h]
FSH_ITEM_REQ, -- Item [fsh_status_i]
FSH_SL_REQ, -- Schedule Line [fsh_status_sl]
FSH_SS, -- Sched. Strat. [fsh_sch_sty]
FSH_OS_RUN, -- Run OS Manually [fsh_os_run]
PRIMARY KEY (MANDT, AUART, VKORG, VTWEG, SPART)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA