SAP ABAP Table S014 (CAS Document Information)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
MCS (Package) R/3 application development: Logistics Information Warehouse
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | S014 |
|
| Short Description | CAS Document Information |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 2 | |
SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
| 3 | |
VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
| 4 | |
SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
| 5 | |
SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
| 6 | |
SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
| 7 | |
SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
| 8 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 9 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
| 10 | |
SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
| 11 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
| 12 | |
VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
| 13 | |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
| 14 | |
VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
| 15 | |
STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
| 16 | |
MIN_VALUE | WERTV9 | CURR | 17 | 2 | Lowest document value | ||
| 17 | |
MAX_VALUE | WERTV9 | CURR | 17 | 2 | Highest doc.value | ||
| 18 | |
DELTA_VAL | WERTV9 | CURR | 17 | 2 | Mean value of documents | ||
| 19 | |
SUM_VALUE | WERTV9 | CURR | 17 | 2 | Total document value | ||
| 20 | |
OFF_VALUE | WERTV9 | CURR | 17 | 2 | Open value | ||
| 21 | |
OFF_COUNT | MCZAEHLER | DEC | 9 | 0 | Number of open documents | ||
| 22 | |
OFF_POSI | MCZAEHLER | DEC | 9 | 0 | Number of open document items | ||
| 23 | |
BEL_COUNT | MCZAEHLER | DEC | 9 | 0 | Number of documents | ||
| 24 | |
POSI_COUNT | MCZAEHLER | DEC | 9 | 0 | Number of line items |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | S014 | KUNNR | |
|
KEY | 1 | CN |
| 2 | S014 | SPART | |
|
KEY | 1 | CN |
| 3 | S014 | VKORG | |
|
KEY | 1 | CN |
| 4 | S014 | VTWEG | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 470 |