SAP ABAP View V_FIOTPOHI (Join FIOTPOH and FIOTPOI)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   FI-LA (Application Component) Lease Accounting
     FI_OTP (Package) FI One-Time Postings
Basic Data
View Type D Database View 
Database View V_FIOTPOHI  
Short Description Join FIOTPOH and FIOTPOI    
Root table FIOTPOH   One-Time Postings: Header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 FIOTPOH FIOTPOH
2 FIOTPOI  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 FIOTPOI MANDT JL EQ 0 0
2 FIOTPOH MANDT JR EQ AND 0 0
3 FIOTPOI COMP JL EQ 0 0
4 FIOTPOH COMP JR EQ AND 0 0
5 FIOTPOI BUKRS JL EQ 0 0
6 FIOTPOH BUKRS JR EQ AND 0 0
7 FIOTPOI OBJID JL EQ 0 0
8 FIOTPOH OBJID JR EQ AND 0 0
9 FIOTPOI SUBID JL EQ 0 0
10 FIOTPOH SUBID JR EQ AND 0 0
11 FIOTPOI TMSTAMP JL EQ 0 0
12 FIOTPOH TMSTAMP JR EQ AND 0 0
13 FIOTPOI DOCNO JL EQ 0 0
14 FIOTPOH DOCNO JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT FIOTPOI MANDT   MANDT Client
2 COMP FIOTPOI COMP   ACE_COMP Accrual Engine Application Component
3 BUKRS FIOTPOI BUKRS   BUKRS Company Code
4 OBJID FIOTPOI OBJID   FIOTP_GUID Object Number
5 SUBID FIOTPOI SUBID   FIOTP_SUBID Subobject Number
6 TMSTAMP FIOTPOI TMSTAMP   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7 DOCNO FIOTPOI DOCNO   FIOTP_DOCNO Document Number
8 ACCRULE FIOTPOI ACCRULE   ACCOUNTING_PRINCIPLE Accounting Principle
9 DOCGROUP FIOTPOI DOCGROUP   FIOTP_DOCGROUP Document Group Characteristic
10 ACCASSGMT FIOTPOI ACCASSGMT   FIOTP_ACCASGMNTRULE Account Determination Rule
11 AMOUNT FIOTPOI AMOUNT   FIOTP_AMOUNT Amount
12 ITEM_TXT FIOTPOI ITEM_TXT   SGTXT Item Text
13 ALLOC_NMBR FIOTPOI ALLOC_NMBR   DZUONR Assignment number
14 OBJ_TYPE FIOTPOI OBJ_TYPE   AWTYP Reference procedure
15 OBJ_KEY FIOTPOI OBJ_KEY   AWKEY Object key
16 OBJ_SYS FIOTPOI OBJ_SYS   AWSYS Logical system of source document
17 EFFDATE FIOTPOH EFFDATE   FIOTP_EFFDATE Effective Date
18 CURRENCY FIOTPOH CURRENCY   CURRENCY Currency Key
19 HEADER_TXT FIOTPOH HEADER_TXT   BKTXT Document Header Text
20 REF_DOC_NO FIOTPOH REF_DOC_NO   XBLNR1 Reference Document Number
21 DOCNO_REVERS FIOTPOH DOCNO_REVERS   FIOTP_DOCNO_REV Reversal Document Number
                 
Maintenance Status
Access
  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 110