SAP ABAP View V_OIRECH_APPL (Clearing house object application table)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
⤷ OIR_E (Package) SSR Card processing (IS-Oil Sevice Station Retailing)
⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
⤷ OIR_E (Package) SSR Card processing (IS-Oil Sevice Station Retailing)
Basic Data
View Type | C | Maintenance View |
Maintenance View | V_OIRECH_APPL | |
Short Description | Clearing house object application table | |
Root table | OIRECH_APPL | SSR PC: Clearing House application data (IS-Oil SSR) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | OIRECH_APPL | OIRECH_APPL | ||
2 | TVTA | OIRECH_APPL | SPART | E |
3 | KNA1 | OIRECH_APPL | KUNNR | E |
4 | OIRECH | OIRECH_APPL | CHOBJ | E |
5 | TVKOS | TVTA | SPART | E |
6 | TVKOV | TVTA | VTWEG | E |
7 | TVKO | TVTA | VKORG | E |
8 | TSPA | TVKOS | SPART | E |
9 | TVTW | TVKOV | VTWEG | E |
10 | TVKOT | TVKO | VKORG | I |
11 | TSPAT | TSPA | SPART | I |
12 | TVTWT | TVTW | VTWEG | I |
13 | T001 | OIRECH | BUKRS | E |
14 | T004 | OIRECH | KTOPL | E |
15 | OIRECHT | OIRECH | CHOBJ | I |
16 | CSKS | OIRECH_APPL | KOKRS | E |
17 | TKA01 | CSKS | KOKRS | E |
18 | CSKT | CSKS | KOSTL | I |
19 | T004T | T004 | KTOPL | I |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | CSKS | DATBI | GE | SY-DATUM | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | OIRECH_APPL | MANDT | MANDT | Client | |||
2 | CHOBJ | OIRECH_APPL | CHOBJ | OIRE_CHOBJ | SSR PC: Clearing house | |||
3 | KUNNR | OIRECH_APPL | KUNNR | OIRE_KUNNR_SOLD_TO | SSR PC: Customer: Sold-to party | |||
4 | VKORG | OIRECH_APPL | VKORG | VKORG | Sales Organization | |||
5 | VTWEG | OIRECH_APPL | VTWEG | VTWEG | Distribution Channel | |||
6 | SPART | OIRECH_APPL | SPART | SPART | Division | |||
7 | KOKRS | OIRECH_APPL | KOKRS | KOKRS | Controlling Area | |||
8 | KOSTL | OIRECH_APPL | KOSTL | KOSTL | Cost Center | |||
9 | ERDAT | OIRECH_APPL | ERDAT | OIF_ERDAT | Date Record Created on (Date) | |||
10 | ERTIM | OIRECH_APPL | ERTIM | OIF_ERZEIT | Time Record Created at (Time) | |||
11 | ERNAM | OIRECH_APPL | ERNAM | OIF_ERNAM | User who Created Record | |||
12 | AEDAT | OIRECH_APPL | AEDAT | OIF_AEDAT | Date Record Changed on (Date) | |||
13 | AETIM | OIRECH_APPL | AETIM | OIF_AEZEIT | Time when Record Was Changed | |||
14 | AENAM | OIRECH_APPL | AENAM | OIF_AENAM | User who Changed Record | |||
15 | VKORG_VTEXT | TVKOT | VTEXT | VTXTK | Name | |||
16 | SPART_VTEXT | TSPAT | VTEXT | VTXTK | Name | |||
17 | VTWEG_VTEXT | TVTWT | VTEXT | VTXTK | Name | |||
18 | CUST_NAME1 | KNA1 | NAME1 | NAME1_GP | Name 1 | |||
19 | KTOPL | OIRECH | KTOPL | KTOPL | Chart of Accounts | |||
20 | BUKRS | OIRECH | BUKRS | BUKRS | Company Code | |||
21 | BUTXT | T001 | BUTXT | BUTXT | Name of Company Code or Company | |||
22 | KTPLT | T004T | KTPLT | KTPLT | Chart of accounts description | |||
23 | CHOBJT | OIRECHT | CHOBJT | OIRE_CHOBJT | SSR PC: Clearing house name | |||
24 | KOKRS_BEZEI | TKA01 | BEZEI | BEZEI | Name of the controlling area | |||
25 | LTEXT | CSKT | LTEXT | KLTXT | Description | |||
26 | FEEMATNR | OIRECH_APPL | FEEMATNR | OIRE_CHFEEMATNR | SSR PC: Default materials for clearing house fee | |||
27 | DISCMATNR | OIRECH_APPL | DISCMATNR | OIRE_CHMATNR | SSR PC: Default materials for clearing house discounts | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |