SAP ABAP Table S272BIW2 (Do not use!)
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
⤷ 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 | S272BIW2 | Table Relationship Diagram |
Short Description | Do not use! |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SPTAG | SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
3 | BWBELN | MCW_BWBELN | VBELN | CHAR | 10 | 0 | Document number for Retail transfer structures | VBUK | |
4 | BELPOS | MCW_BELPOS | POSNR | NUMC | 6 | 0 | Item number for Retail transfer structures | VBUP | |
5 | BWEINT | MCW_BWEINT | ETENR | NUMC | 4 | 0 | Schedule line number for Retail transfer | VBEP | |
6 | BWVORG | MCW_BWVORG | NUM3 | NUMC | 3 | 0 | SAP BW transaction key | ||
7 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
8 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
9 | VRSIO | VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
10 | SPMON | SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
11 | SPWOC | SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
12 | SPBUP | SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
13 | SSOUR | SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
14 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
15 | VWDAT | VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
16 | BASME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
17 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
18 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
19 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
20 | BIWMNG | MCW_BIWMNG | MENGV15_3 | QUAN | 15 | 3 | RIS/Reporting Server - Transfer base quantity | ||
21 | BIWMVE | MCW_BIWMVE | MENGV15_3 | QUAN | 15 | 3 | RIS/Reporting Server - Transfer quantity sold | ||
22 | BIWGEO | MCW_BIWGEO | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer cost price | ||
23 | BIWGVO | MCW_BIWGVO | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer retail price | ||
24 | BIWGVP | MCW_BIWGVP | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer retail price with tax | ||
25 | BIWPNL | MCW_BIWPNL | WERTV10 | CURR | 19 | 2 | RIS/Reporting Server - Transfer price reduction | ||
26 | BIWANZ | MCW_BIWANZ | MCZAEHLINT | INT4 | 10 | 0 | RIS/Reporting Server - Transfer number of activities | ||
27 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
28 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
29 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
30 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
31 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
32 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
33 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
34 | NETWR | NETWR_FP | WERTV8 | CURR | 15 | 2 | Net value of the billing item in document currency | ||
35 | BRTWR | BRTWR_FP | WERTV8 | CURR | 15 | 2 | Gross value of the billing item in document currency | ||
36 | MWSBP | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
37 | OAUME | MC_OAUME | MENGV15_3 | QUAN | 15 | 3 | Open orders quantity in base unit of measure | ||
38 | OAUWE | MC_OAUWE | WERTV10 | CURR | 19 | 2 | Open net value of orders | ||
39 | PKUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
40 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
41 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
42 | AKTNR | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
43 | WMINR | WMINR | WMINR | CHAR | 10 | 0 | Product catalog number | WWMI | |
44 | MATWA | MATWA | MATNR | CHAR | 18 | 0 | Material entered | MARA | |
45 | GRUND | MCW_BIWGRU | CHAR4 | CHAR | 4 | 0 | Reason for activity | ||
46 | ABGRU | ABGRU_VA | ABGRU_VA | CHAR | 2 | 0 | Reason for rejection of quotations and sales orders | TVAG | |
47 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
48 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
49 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
50 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVKBZ | |
51 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
52 | PKUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | KNA1 | |
53 | BWBELT | MCW_BWBELT | BSTYP | CHAR | 1 | 0 | Type of transfer document | ||
54 | BWBELA | MCW_BWBELA | AUART | CHAR | 4 | 0 | Transfer document type | TVAK | |
55 | BWPOST | MCW_BWPOST | PSTYV | CHAR | 4 | 0 | Item category transfer document | TVPT | |
56 | KNUMA_PI | KNUMA_PI | KNUMA | CHAR | 10 | 0 | Promotion | * | |
57 | KNUMA_AG | KNUMA_AG | KNUMA | CHAR | 10 | 0 | Sales deal | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | S272BIW2 | ABGRU | TVAG | ABGRU | |||
2 | S272BIW2 | AKTNR | WAKH | AKTNR | |||
3 | S272BIW2 | BASME | T006 | MSEHI | |||
4 | S272BIW2 | BELPOS | VBUP | POSNR | KEY | ||
5 | S272BIW2 | BWBELA | TVAK | AUART | |||
6 | S272BIW2 | BWBELN | VBUK | VBELN | KEY | ||
7 | S272BIW2 | BWEINT | VBEP | ETENR | KEY | ||
8 | S272BIW2 | BWPOST | TVPT | PSTYV | |||
9 | S272BIW2 | HWAER | TCURC | WAERS | |||
10 | S272BIW2 | MANDT | T000 | MANDT | KEY | ||
11 | S272BIW2 | MATNR | MARA | MATNR | |||
12 | S272BIW2 | MATWA | MARA | MATNR | |||
13 | S272BIW2 | PKUNAG | KNA1 | KUNNR | |||
14 | S272BIW2 | PKUNWE | KNA1 | KUNNR | |||
15 | S272BIW2 | SPART | TSPA | SPART | |||
16 | S272BIW2 | VKBUR | TVKBZ | VKBUR | |||
17 | S272BIW2 | VKGRP | TVBVK | VKGRP | |||
18 | S272BIW2 | VKORG | TVKO | VKORG | |||
19 | S272BIW2 | VRKME | T006 | MSEHI | |||
20 | S272BIW2 | VTWEG | TVTW | VTWEG | |||
21 | S272BIW2 | WAERK | TCURC | WAERS | |||
22 | S272BIW2 | WERKS | T001W | WERKS | |||
23 | S272BIW2 | WMINR | WWMI | WMINR | 1 | CN |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in |