T003O

Transparent Table Customizing Table
27 Fields 3 CDS Views

Order Types

T003O is an SAP database table in S/4HANA. Order Types. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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.

-- Order Types
-- 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