SAP Table T003O

Order Types

T003O (Order Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T003O to other SAP tables.

T003O table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
AUART Order Type AUFART CHAR 4 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
NUMKR Number range NUMKR CHAR 2 0
OBLIGO Commitments Management Active CO_OBLIGO CHAR 1 0
NULL Component not active
1 Components active
ERLOESE Identifier "Revenue posting allowed" ERLOESE CHAR 1 0
NULL not allowed
X allowed
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
APROF Settlement profile APROF TKB1A CHAR 6 0
PPROF Planning profile BP_PPROFIL CHAR 6 0
COPAR CO Partner Update COPAR CHAR 1 0
N Not active
NULL Semi-active
X Active
RESZ1 Residence Time 1 (Calendar Months) RESZ1 NUMC 3 0
RESZ2 Residence Time 2 (Calendar Months) RESZ2 NUMC 3 0
AUFKL 'Order will be classified' indicator KZAUFKLA CHAR 1 0
X Yes
NULL No
RELKZ Set "Release immediately" indicator AUFRELKZ CHAR 1 0
X Yes
NULL No
CHGKZ Indicator 'Status change documents' AUFCHGKZ CHAR 1 0
X Yes
NULL No
BPROF Budget Profile BP_BPROFIL TBP1C CHAR 6 0
PLINT Indicator for Integrated Planning PLINT CHAR 1 0
X Yes
NULL No
NABPF Indicator "Does not require settlement" NABPF CHAR 1 0
X Yes
NULL No
VORPL Indicator: Planning PS_VORPL CHAR 1 0
X Yes
NULL No
LAYOUT Layout for Master Data Maintenance Orders AUFLAY AUFLAY0 CHAR 4 0
TDFORM Form Name TDFORM CHAR 16 0
SCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
COLORDPROC Collective order with/without automatic goods movement CO_COLORDPRC CHAR 1 0
NULL Collective order without automatic goods movement
X Collective order with automatic goods movement
VRG_STSMA Status Profile Assigned to an Operation PM_STSMA_VORG TJ20 CHAR 8 0
FUNC_AREA Functional Area FKBER TFKB CHAR 16 0
EXEC_PROFILE Execution Services Profile CK_EXPROFILE CHAR 4 0

T003O foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T003O APROF T003O CLIENT TKB1A Settlement Profile MANDT
T003O APROF T003O APROF TKB1A Settlement Profile APROF
T003O BPROF T003O BPROF TBP1C Budget/Plan Profile PROFIL
T003O BPROF 'O' TBP1C Budget/Plan Profile APPLIK
T003O BPROF '41' TBP1C Budget/Plan Profile WRTTP
T003O BPROF T003O CLIENT TBP1C Budget/Plan Profile MANDT
T003O CLIENT T003O CLIENT T000 Clients MANDT
T003O FUNC_AREA T003O CLIENT TFKB Functional areas MANDT
T003O FUNC_AREA T003O FUNC_AREA TFKB Functional areas FKBER
T003O LAYOUT T003O CLIENT AUFLAY0 Entity Table: Order Layouts MANDT
T003O LAYOUT T003O LAYOUT AUFLAY0 Entity Table: Order Layouts LAYOUT
T003O STSMA T003O STSMA TJ20 Status profiles STSMA
T003O STSMA T003O CLIENT TJ20 Status profiles MANDT
T003O VRG_STSMA T003O CLIENT TJ20 Status profiles MANDT
T003O VRG_STSMA T003O VRG_STSMA TJ20 Status profiles STSMA