SAP ABAP View BIW_V_ORIP_IQ (IM -> BW Extractor: OR IP Assignment via IQ)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ IM-FA (Application Component) Capital Investments
⤷ AIBW (Package) BW: IM Extractors
⤷ IM-FA (Application Component) Capital Investments
⤷ AIBW (Package) BW: IM Extractors
Basic Data
View Type | D | Database View |
Database View | BIW_V_ORIP_IQ | |
Short Description | IM -> BW Extractor: OR IP Assignment via IQ | |
Root table | AUFK | Order master data |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | AUFK | AUFK | ||
2 | IMZO | |||
3 | IMPR | |||
4 | IMAK | |||
5 | IMAKZ |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | IMZO | MANDT | JL | EQ | 0 | 0 | ||||
2 | IMPR | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | IMZO | POSNR | JL | EQ | 0 | 0 | ||||
4 | IMPR | POSNR | JR | EQ | AND | 0 | 0 | |||
5 | IMZO | MANDT | JL | EQ | 0 | 0 | ||||
6 | IMAK | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | IMZO | OBJNR | JL | EQ | 0 | 0 | ||||
8 | IMAK | OBJNR | JR | EQ | AND | 0 | 0 | |||
9 | IMAK | MANDT | JL | EQ | 0 | 0 | ||||
10 | IMAKZ | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | IMAK | POSNR | JL | EQ | 0 | 0 | ||||
12 | IMAKZ | POSNR | JR | EQ | AND | 0 | 0 | |||
13 | AUFK | MANDT | JL | EQ | 0 | 0 | ||||
14 | IMAKZ | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | AUFK | OBJNR | JL | EQ | 0 | 0 | ||||
16 | IMAKZ | OBJNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | AUFK | MANDT | MANDT | Client | |||
2 | AUFNR | AUFK | AUFNR | AUFNR | Order Number | |||
3 | IP_POSID | IMPR | POSID | IM_POSID | Identification for an investment program position | |||
4 | IP_PRNAM | IMPR | PRNAM | IM_PRNAM | Investment program name | |||
5 | IP_GNJHR | IMPR | GJAHR | IM_GNJHR | Approval year of the investment program | |||
6 | IPPOS | IMZO | IPPOS | IM_IPPOS | Budget Category in Investment Program | |||
7 | PROZU | IMZO | PROZU | IM_PROZU | Percentage assignment of a measure to a program position | |||
8 | XGENJ | IMZO | XGENJ | IM_BUDSTAT | Budget status for measures | |||
9 | LOGDL | IMZO | LOGDL | IM_LOGDEL | IM Logical deletion indicator | |||
10 | POSID | IMAK | POSID | IMA_POSID | Appropriation Request Number (Formatted for Coding Mask) | |||
11 | POSNR | IMAK | POSNR | IMA_POSNR | Internal number for appropriation request | |||
12 | BAPRZ | IMZO | BAPRZ | IM_BAPRZ | Percentage Assignment of a Measure to a Budget Category | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |