SAP ABAP View /POSDW/V_RETTY (Sales Items Type)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
⤷
/POSDW/CUSTOMIZING (Package) PIPE Customizing
BI_CONT (Software Component) Business Intelligence Content⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine⤷
/POSDW/CUSTOMIZING (Package) PIPE Customizing
Basic Data
| View Type | C | Maintenance View |
| Maintenance View | /POSDW/V_RETTY | |
| Short Description | Sales Items Type | |
| Root table | /POSDW/RETTY | Category for Sales Items |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /POSDW/RETTY |
/POSDW/RETTY | ||
| 2 | /POSDW/RETTYT |
/POSDW/RETTY | PROFILETYPE | I |
| 3 | /POSDW/RETTG |
/POSDW/RETTY | RETAILTYPEGROUP | E |
| 4 | /POSDW/TASKG |
/POSDW/RETTY | TASKGROUP | E |
| 5 | /POSDW/RETTGT |
/POSDW/RETTG | PROFILETYPE | I |
| 6 | /POSDW/TASKGT |
/POSDW/TASKG | PROFILETYPE | I |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/POSDW/RETTY |
MANDT | MANDT | Client | |||
| 2 | PROFILETYPE |
/POSDW/RETTY |
PROFILETYPE | /POSDW/PROFILETYPE | Customizing Profile Type | |||
| 3 | RETAILTYPECODE |
/POSDW/RETTY |
RETAILTYPECODE | /POSDW/RETAILTYPECODE | Sales Item Type | |||
| 4 | DESCRIPTION |
/POSDW/RETTYT |
DESCRIPTION | /POSDW/DESCRIPTION | Description | |||
| 5 | RETAILTYPEGROUP |
/POSDW/RETTY |
RETAILTYPEGROUP | /POSDW/RETAILTYPEGROUP | Sales Item Type Group | |||
| 6 | DEBITFLAG |
/POSDW/RETTY |
DEBITFLAG | /POSDW/DEBITFLAG | Debit/Credit Indicator | |||
| 7 | INCLEXCLTASK |
/POSDW/RETTY |
INCLEXCLTASK | /POSDW/INCLEXCLTASK | Flag if Procedure Is Relevant for Task Group | |||
| 8 | TASKGROUP |
/POSDW/RETTY |
TASKGROUP | /POSDW/INCLEXCLTASKGROUP | Include/Exclude Task Group | |||
| 9 | EXCLHEADERDISC |
/POSDW/RETTY |
EXCLHEADERDISC | /POSDW/EXCLUDEHEADERDISCOUNT | Remove Item from the Distribution of Header Discounts | |||
| 10 | EXCLHEADERTAX |
/POSDW/RETTY |
EXCLHEADERTAX | /POSDW/EXCLUDEHEADERTAX | Remove Item from Distribution of Header Taxes | |||
| 11 | EXCLTENDER |
/POSDW/RETTY |
EXCLTENDER | /POSDW/EXCLUDEHEADERTENDER | Remove Item from Distribution of Tender | |||
| 12 | ITEM_CAT |
/POSDW/RETTY |
ITEM_CAT | /POSDW/RETAIL_ITEM_CATEGORY | Classification of Sales Item: Category | |||
| 13 | ITEM_SCAT |
/POSDW/RETTY |
ITEM_SCAT | /POSDW/RETAIL_ITEM_SUBCATEGORY | Classification of Sales Item: Subcategory | |||
| 14 | AGGR_K1 |
/POSDW/RETTY |
AGGR_K1 | /POSDW/AGGR_GROUPING_KEY1 | Grouping Key 1 for Summarization | |||
| 15 | AGGR_K2 |
/POSDW/RETTY |
AGGR_K2 | /POSDW/AGGR_GROUPING_KEY2 | Grouping Key 2 for Summarization | |||
| 16 | AGGR_K3 |
/POSDW/RETTY |
AGGR_K3 | /POSDW/AGGR_GROUPING_KEY3 | Grouping Key 3 for Summarization | |||
| 17 | INCLEXCLTASK_TOT |
/POSDW/RETTY |
INCLEXCLTASK_TOT | /POSDW/INCLEXCLTASK_TOT | Controls if Process for Task Group Relev. for Totals Record | |||
| 18 | TASKGROUP_TOT |
/POSDW/RETTY |
TASKGROUP_TOT | /POSDW/INCLEXCLTASKGROUP_TOT | Task Group Incl./Excl. for Totals Records | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | E | Control table, SAP and customer have separate key areas |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
| Last changed by/on | SAP | 20100326 |
| SAP Release Created in | 320 |
