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 |
Possible values
|
||||||||||||||||||||||||||||
NUMKR | Number range | NUMKR | CHAR | 2 | 0 | |||||||||||||||||||||||||||||
OBLIGO | Commitments Management Active | CO_OBLIGO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
ERLOESE | Identifier "Revenue posting allowed" | ERLOESE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||||
RELKZ | Set "Release immediately" indicator | AUFRELKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
CHGKZ | Indicator 'Status change documents' | AUFCHGKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
BPROF | Budget Profile | BP_BPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||||||||||||||||||||||
PLINT | Indicator for Integrated Planning | PLINT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
NABPF | Indicator "Does not require settlement" | NABPF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
VORPL | Indicator: Planning | PS_VORPL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||||
COLORDPROC | Collective order with/without automatic goods movement | CO_COLORDPRC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
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 |