| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | Application Object GUID | varbinary | 16 | 0 | RAW | | No | | DPR_TV_GUID | |
| 3 | OBJECT_TYPE | Type of Linked Object | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | DPR_TV_OBL_TYPE | Allow NULL? |
| 4 | PROJECT_GUID | Application Object GUID (Entity with Conversion Exit) | varbinary | 16 | 0 | RAW | | Yes | | DPR_TV_ENTITY_GUID | |
| 5 | TASK_GUID | Application Object GUID (Entity with Conversion Exit) | varbinary | 16 | 0 | RAW | | Yes | | DPR_TV_ENTITY_GUID | |
| 6 | INT_ID | Internal Identification of an SRM Shopping Cart | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SC_GUID | Allow NULL? |
| 7 | EXT_ID | External Identification of an SRM Shopping Cart | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SC_ID | Allow NULL? |
| 8 | CREATED_BY | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | DPR_TV_CREATED_BY | Allow NULL? |
| 9 | CREATED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | DEC | ((0)) | Yes | | DPR_TV_TIMESTAMP | |
| 10 | CHANGED_BY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | DPR_TV_CHANGED_BY | Allow NULL? |
| 11 | CHANGED_ON | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | DEC | ((0)) | Yes | | DPR_TV_TIMESTAMP | |
| 12 | NOTE | Description of Request | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SC_DESCR | Allow NULL? |
| 13 | INT_NOTE | Internal Information Exists for Shopping Cart | char | 1 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SC_INT_NOTE | Allow NULL? |
| 14 | LOGSYS | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 15 | BUPA_LINK_GUID | Application Object GUID | varbinary | 16 | 0 | RAW | | Yes | | DPR_TV_GUID | |
| 16 | REQUESTED_QTY | Requested Total Quantity for a Shopping Cart | decimal | 19 | 6 | DEC | ((0)) | Yes | | DPR_TV_SC_QUANTITY | |
| 17 | REQUESTED_UNIT | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | DPR_TV_UNIT | Allow NULL? |
| 18 | TYPE_CODE | Category of Shopping Cart/Item (1 = Material, 2 = Service) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SC_TYPE | Allow NULL? |
| 19 | PROD_CATEGORY | Identification of an SRM Product Category | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SRM_PROD_CAT | Allow NULL? |
| 20 | REQUESTED_BEGIN | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | DEC | ((0)) | Yes | | DPR_TV_TIMESTAMP | |
| 21 | REQUESTED_FINISH | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | decimal | 15 | 0 | DEC | ((0)) | Yes | | DPR_TV_TIMESTAMP | |
| 22 | CANCEL_INDICATOR | Indicator for Cancelled Shopping Cart | char | 1 | 0 | CHAR | (N' ') | Yes | | DPR_TV_SC_CANCELLED | Allow NULL? |
| 23 | VERSION_TYPE | Version Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGPL_TV_VERSION_TYPE | Allow NULL? |
