T003O
Auftragsarten
T003O is an SAP database table in S/4HANA. Auftragsarten. It contains 27 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InternalOrderType | view | from | BASIC | Internal Order Type |
| I_OrderType | view | from | BASIC | Order Type |
| MDCV_E_T003O | view | from | Order types for T399D |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | auart | aufart | Order Type | |||
| autyp | auftyp | Order category | ||||
| numkr | numkr_auf | Number range Orders | ||||
| obligo | co_obligo | Commt Update | ||||
| erloese | erloese | Revenues | ||||
| stsma | j_stsma | Status Profile | ||||
| aprof | aprof | Settlmt Profile | ||||
| pprof | bp_pprofil | Plng Profile | ||||
| copar | copar | CO Partner | ||||
| resz1 | resz1 | Residence Time1 | ||||
| resz2 | resz2 | Residence Time2 | ||||
| aufkl | kzaufkla | Classification | ||||
| relkz | aufrelkz | Release Immed. | ||||
| chgkz | aufchgkz | ChangeDocuments | ||||
| bprof | bp_bprofil | Budget Profile | ||||
| plint | plint | Integ. Planning | ||||
| nabpf | nabpf | Do Not Settle | ||||
| vorpl | ps_vorpl | Planning | ||||
| layout | auflay | Order Layout | ||||
| tdform | tdform | Form | ||||
| scope | scope_cv | Object Class | ||||
| colordproc | co_colordprc | CO processing | ||||
| vrg_stsma | pm_stsma_vorg | Status Profile | ||||
| func_area | fkber | Functional Area | ||||
| exec_profile | ck_exprofile | Exec. Profile | ||||
| configurationdeprecationcode | config_deprecation_code | Validity |
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.
-- Auftragsarten
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T003O (
CLIENT, -- Client [mandt]
AUART, -- Order Type [aufart]
AUTYP, -- Order category [auftyp]
NUMKR, -- Number range Orders [numkr_auf]
OBLIGO, -- Commt Update [co_obligo]
ERLOESE, -- Revenues [erloese]
STSMA, -- Status Profile [j_stsma]
APROF, -- Settlmt Profile [aprof]
PPROF, -- Plng Profile [bp_pprofil]
COPAR, -- CO Partner [copar]
RESZ1, -- Residence Time1 [resz1]
RESZ2, -- Residence Time2 [resz2]
AUFKL, -- Classification [kzaufkla]
RELKZ, -- Release Immed. [aufrelkz]
CHGKZ, -- ChangeDocuments [aufchgkz]
BPROF, -- Budget Profile [bp_bprofil]
PLINT, -- Integ. Planning [plint]
NABPF, -- Do Not Settle [nabpf]
VORPL, -- Planning [ps_vorpl]
LAYOUT, -- Order Layout [auflay]
TDFORM, -- Form [tdform]
SCOPE, -- Object Class [scope_cv]
COLORDPROC, -- CO processing [co_colordprc]
VRG_STSMA, -- Status Profile [pm_stsma_vorg]
FUNC_AREA, -- Functional Area [fkber]
EXEC_PROFILE, -- Exec. Profile [ck_exprofile]
CONFIGURATIONDEPRECATIONCODE, -- Validity [config_deprecation_code]
PRIMARY KEY (CLIENT, AUART)
);
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