SAP ABAP Table U_26201 (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | U_26201 |
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| 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 | T000 | |
| 2 | |
W_MFCNR | MFCNR | CHAR | 10 | 0 | Document no. of markdown plan | WMFH | |
| 3 | |
W_POSNR | NUMC6 | NUMC | 6 | 0 | Item number | ||
| 4 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 5 | |
VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
| 6 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 7 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
| 8 | |
W_VTLCU | WAERS | CUKY | 5 | 0 | Currency of distribution chain | TCURC | |
| 9 | |
ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
| 10 | |
W_MPRNR | MPRNR | CHAR | 10 | 0 | Markdown rule | WMPK | |
| 11 | |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
| 12 | |
SAISO | SAISO | CHAR | 4 | 0 | Season Category | T6WSP | |
| 13 | |
SAISJ | CJAHR | CHAR | 4 | 0 | Season Year | ||
| 14 | |
F_DATFR | DATUM | DATS | 8 | 0 | Start date for first price in a markdown plan | ||
| 15 | |
W_PSALM | MENGE | QUAN | 13 | 3 | Planned sales quantity in sales unit | ||
| 16 | |
W_PANFM2 | MENGV13 | QUAN | 13 | 3 | Planned initial stock | ||
| 17 | |
W_WAEEK | WAERS | CUKY | 5 | 0 | Purchase price currency | TCURC | |
| 18 | |
EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
| 19 | |
BBPRM | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | T006 | |
| 20 | |
W_CURVP | WAERS | CUKY | 5 | 0 | Sales price currency | TCURC | |
| 21 | |
EKPGR | WERTV6 | CURR | 11 | 2 | Purchase Price Calculation: (Basic Purchase Price) | ||
| 22 | |
EKPNN | WERTV6 | CURR | 11 | 2 | Sales Pricing: Purchase Price (Net/Net) | ||
| 23 | |
VKPBR | WERTV6 | CURR | 11 | 2 | Sales price (gross) | ||
| 24 | |
ENDPR | WERTV6 | CURR | 11 | 2 | Final price | ||
| 25 | |
W_PRESM2 | MENGV13 | QUAN | 13 | 3 | Planned Remaining Quantity | ||
| 26 | |
W_PSALC | WERT | CURR | 13 | 2 | Planned sales at purchase price | ||
| 27 | |
W_PSALP | WERT | CURR | 13 | 2 | Planned sales at delivered price/net/net purchase price | ||
| 28 | |
W_PSALW | WERT | CURR | 13 | 2 | Planned sales at retail price | ||
| 29 | |
W_PRESW | WERT | CURR | 13 | 2 | Planned Remaining Stock (Value) | ||
| 30 | |
W_CMUIV | WERTV6 | CURR | 11 | 2 | Weighted stock margin for all price phases | ||
| 31 | |
W_MAHIT | WERT | CURR | 13 | 2 | Margin Loss | ||
| 32 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 33 | |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 34 | |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
| 35 | |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 36 | |
W_LIFNR | LIFNR | CHAR | 10 | 0 | Vendor number | LFA1 | |
| 37 | |
PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | MARA |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | U_26201 | AKTNR | |
|
1 | CN | |
| 2 | U_26201 | ARTNR | |
|
1 | N | |
| 3 | U_26201 | BBPRM | |
|
C | N | |
| 4 | U_26201 | CUREP | |
|
C | N | |
| 5 | U_26201 | CURVP | |
|
C | N | |
| 6 | U_26201 | LIFNR | |
|
1 | CN | |
| 7 | U_26201 | MANDT | |
|
1 | N | |
| 8 | U_26201 | MFCNR | |
|
1 | N | |
| 9 | U_26201 | MPRNR | |
|
1 | CN | |
| 10 | U_26201 | PMATN | |
|
REF | 1 | CN |
| 11 | U_26201 | SAISO | |
|
1 | CN | |
| 12 | U_26201 | VKORG | |
|
1 | N | |
| 13 | U_26201 | VRKME | |
|
C | N | |
| 14 | U_26201 | VTLCU | |
|
1 | CN | |
| 15 | U_26201 | VTWEG | |
|
1 | N |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |