SAP ABAP View V_TXW_AD01D (Join VBRP/AD01DLIEF/AD01DLI)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ CA-GTF-DRT (Application Component) Data Retention Tool
⤷ FTW1 (Package) Data Retention Tool
⤷ CA-GTF-DRT (Application Component) Data Retention Tool
⤷ FTW1 (Package) Data Retention Tool
Basic Data
View Type | D | Database View |
Database View | V_TXW_AD01D | |
Short Description | Join VBRP/AD01DLIEF/AD01DLI | |
Root table | AD01DLIEF | DI flow: Individual flow |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | AD01DLIEF | AD01DLIEF | ||
2 | AD01DLI | |||
3 | VBRP |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | AD01DLI | MANDT | JL | EQ | 0 | 0 | ||||
2 | AD01DLIEF | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | AD01DLI | DLINR | JL | EQ | 0 | 0 | ||||
4 | AD01DLIEF | DLINR | JR | EQ | AND | 0 | 0 | |||
5 | VBRP | VGBEL | JL | EQ | 0 | 0 | ||||
6 | AD01DLIEF | VBELN | JR | EQ | AND | 0 | 0 | |||
7 | VBRP | VGPOS | JL | EQ | 0 | 0 | ||||
8 | AD01DLIEF | VBPOS | JR | EQ | AND | 0 | 0 | |||
9 | VBRP | MANDT | JL | EQ | 0 | 0 | ||||
10 | AD01DLIEF | MANDT | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | VBRP | MANDT | MANDT | Client | |||
2 | VBELN | VBRP | VBELN | VBELN_VF | Billing document | |||
3 | OBJNR | AD01DLI | OBJNR | J_OBJNR | Object number | |||
4 | POPER | AD01DLI | POPER | AD01PERIOD | Posting period | |||
5 | VGBEL | VBRP | VGBEL | VGBEL | Document number of the reference document | |||
6 | VGPOS | VBRP | VGPOS | VGPOS | Item number of the reference item | |||
7 | VGTYP | VBRP | VGTYP | VBTYP_V | Document category of preceding SD document | |||
8 | DLINR | AD01DLI | DLINR | AD01DLINR | Number of the Dynamic Item | |||
9 | TWAER | AD01DLI | TWAER | TWAER | Transaction Currency | |||
10 | MEINH | AD01DLI | MEINH | CO_MEINH | Unit of Measure | |||
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 | 20131127 |
SAP Release Created in | 470 |