| 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 | * | MANDT | Allow NULL? |
| 2 | DB_KEY | NodeID | varbinary | 16 | 0 | RAW | | No | | /BOBF/CONF_KEY | |
| 3 | OBJECT_ID | Object ID - Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SRMERP/OBJECT_ID | Allow NULL? |
| 4 | DOCUMENT_TYPE | Purchasing Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /SRMERP/DOCUMENT_TYPE | Allow NULL? |
| 5 | CURR_MAX_ITM_NO | Maximum Current Internal Item Number for SC Item | int | 10 | 0 | INT4 | ((0)) | Yes | | /SRMERP/SC_CURR_MAX_ITM_NO | Allow NULL? |
| 6 | ITM_COUNT | Number of Items in a Shopping Cart | int | 10 | 0 | INT4 | ((0)) | Yes | | /SRMERP/SC_ITM_COUNT | Allow NULL? |
| 7 | CREA_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 8 | CREA_UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 9 | LCHG_DATE_TIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 10 | LCHG_UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 11 | TOTAL_VAL_NET | Total Net Value of Shopping Cart | decimal | 15 | 2 | CURR | ((0)) | Yes | | /SRMERP/SC_TOTAL_VAL_NET | |
| 12 | WAERS | Document currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERF | Allow NULL? |
| 13 | APPROVAL_STATUS | Approval Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/STAT_APPROVAL_W_PARTLY | Allow NULL? |
| 14 | DELIVERY_STATUS | Delivery Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/STAT_DELIVERY_W_PARTLY | Allow NULL? |
| 15 | CONSIST_STATUS | Consistency Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/STATUS_CONSISTENCY | Allow NULL? |
| 16 | FOLLOW_ON_STATUS | Follow-On Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/STAT_FOLLOW_ON_W_PRTLY | Allow NULL? |
| 17 | CANCELATN_STATUS | Cancelation Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/STATUS_CANCELATION | Allow NULL? |
| 18 | LIFECYCLE_STATUS | Shopping Cart Life Cycle | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/SC_STATUS_RT_LIFE_CYCL | Allow NULL? |
| 19 | ARCHIVING_STATUS | Archiving Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SRMERP/ARCHIVING_STATUS_CODE | Allow NULL? |
| 20 | /SRMERP/E_SCROOT | Dummy function in length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | DUMMY | Allow NULL? |