| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | CSTOBJ | Retail IACs: Customizing object | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWICOBJ | W_CSTOBJ | Allow NULL? |
| 3 | CSTSCM | Profile for quotation and order control | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWICSCM | W_OS_ORSCM | Allow NULL? |
| 4 | SOTYP | Order type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | W_OS_SOTYP | Allow NULL? |
| 5 | QUOTA | Create quotation | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_QUOTA | Allow NULL? |
| 6 | PYINV | Payment method: By invoice | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PYINV | Allow NULL? |
| 7 | PYCCD | Payment Method: Credit Card | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PYCCD | Allow NULL? |
| 8 | PYCOD | Payment method: Cash on delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PYCOD | Allow NULL? |
| 9 | CODPR | Payment method payer cash on delivery | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | W_OS_CODPR | Allow NULL? |
| 10 | PYSET | Payment Method: Credit Card with SET | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_PYCCD_SET | Allow NULL? |
| 11 | CCSET | Payment cards: Card type "SET" | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVCIN | W_OS_CCINS | Allow NULL? |
| 12 | NORSET | Internal number range for SET process | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | W_OS_NORIN | Allow NULL? |
| 13 | RQDAT | Enter required delivery date | char | 1 | 0 | CHAR | (N' ') | Yes | | W_OS_RQDAT | Allow NULL? |
| 14 | RQMAX | Maximum allowed requested delivery time in days | decimal | 4 | 0 | DEC | ((0)) | Yes | | W_OS_RQMAX | |