| 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 | AUART | Sales Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVAK | AUART | Allow NULL? |
| 3 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 4 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVKOV | VTWEG | Allow NULL? |
| 5 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTA | SPART | Allow NULL? |
| 6 | SEAP_FLG | Season Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_SEAP_FLG | Allow NULL? |
| 7 | SEAM_FLG | Season Processing Message Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_SEAM_FLG | Allow NULL? |
| 8 | DDATE_FLAG | Delivery Date Proposal Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_PROPOSAL_FLAG | Allow NULL? |
| 9 | SEADC_RCAT | Season Determination Requirement Segment | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_SEADC | Allow NULL? |
| 10 | SEA_DET | Season Determination Level | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_SEA_DET | Allow NULL? |
| 11 | SLOG_FLG | Season Determination Log Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_SEADET_LOG | Allow NULL? |
| 12 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 13 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 14 | KDGRP | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T151 | KDGRP | Allow NULL? |
| 15 | CANDATE_FLAG | Cancellation Date Breached Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_CANCELDATE | Allow NULL? |
| 16 | ATP_FLAG | ATP Overview Active Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_ATP_FLAG | Allow NULL? |
| 17 | AGG_LEVEL | Aggregation Level | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_AGG_LEVEL | Allow NULL? |
| 18 | FSH_VRSN_STATUS | Enable Snapshot | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_STATUS_S | Allow NULL? |
| 19 | FSH_HEADER_REQ | Create Snapshot of Header Details | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_STATUS_H | Allow NULL? |
| 20 | FSH_ITEM_REQ | Create Snapshot of Item Details | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_STATUS_I | Allow NULL? |
| 21 | FSH_SL_REQ | Create Snapshot of Schedule Line Details | char | 1 | 0 | CHAR | (N' ') | Yes | | FSH_STATUS_SL | Allow NULL? |