SAP ABAP Table OICQ8_WRK (F&A - Work Struct. for Formula Term)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       OIC (Package) MAP Marketing, Accounting and Pricing
Basic Data
Table Category INTTAB    Structure 
Structure OICQ8_WRK   Table Relationship Diagram
Short Description F&A - Work Struct. for Formula Term    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   Formula Condition Data - Terms (enhance CI-Include in OICF2)  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
4 KPOSN KPOSN NUM6 NUMC 6   0   Condition Item Number  
5 STUNR STUNR STUNR NUMC 3   0   Level Number *
6 ZAEHK DZAEHK ZAEHK NUMC 2   0   Condition counter  
7 FORTRMTYP OIC_TRMTYP OIC_TRMTYP CHAR 1   0   Formula term type  
8 PFIND OIC_PFIND OIC_PFIND CHAR 1   0   Formula provisional/final indicator  
9 .INCLUDE       0   0   Internal Formula Term Calculation Rules  
10 REFDATE OIC_REFDAT OIC_EXIT NUMC 3   0   User exit for reference date determination  
11 TIMUOM OIC_TIMUOM OIC_EXIT NUMC 3   0   Time unit of measure exit  
12 WERULE OIC_WERULE OIC_EXIT NUMC 3   0   Weekend rule exit  
13 NPDAYS OIC_NPDAYS OIC_EXIT NUMC 3   0   Non-posted days rule exit  
14 ERRHAN OIC_ERRHAN OIC_EXIT NUMC 3   0   Error handling exit, if no quotation found  
15 RDOFFSET OIC_RDOFF OIC_EXIT NUMC 3   0   Offset from reference date  
16 PERBEF OIC_PERBEF OIC_OFFSET NUMC 3   0   Period before base date  
17 PERAFT OIC_PERAFT OIC_OFFSET NUMC 3   0   Period after base date  
18 EXCEX OIC_EXCEV XFELD CHAR 1   0   Exclude Base Date  
19 DATFRM OIC_DATFRM DATUM DATS 8   0   'Date from' for average period  
20 DATTO OIC_DATTO DATUM DATS 8   0   'Date to' for fixation period  
21 CARULE OIC_CARULE OIC_EXIT NUMC 3   0   Average currency rule  
22 CDRULE OIC_CDRULE OIC_EXIT NUMC 3   0   Daily currency rule  
23 CREFDATE OIC_CREFDT OIC_EXIT NUMC 3   0   Determination exit for currency reference date  
24 CTIMUOM OIC_CTIMUM OIC_EXIT NUMC 3   0   Currency time unit of measure exit  
25 CWERULE OIC_CWERUL OIC_EXIT NUMC 3   0   Currency weekend rule exit  
26 CNPDAYS OIC_CNPDAY OIC_EXIT NUMC 3   0   Currency non-posted days rule exit  
27 CERRHAN OIC_CERRHN OIC_EXIT NUMC 3   0   Error-handling exit (if no exch.rate found)  
28 CRDOFFSET OIC_CRDOFF OIC_OFFSET NUMC 3   0   Offset from reference date for currency  
29 CPERBEF OIC_CPERBF OIC_OFFSET NUMC 3   0   Period before base date for currency  
30 CPERAFT OIC_CPERAF OIC_OFFSET NUMC 3   0   Period after base date for currency  
31 CEXCEV OIC_CEXCEV XFELD CHAR 1   0   Exclude Base Date for Currency  
32 CDATFRM OIC_CDATFR DATUM DATS 8   0   Date from for fixation period for currency  
33 CDATTO OIC_CDATTO DATUM DATS 8   0   Date to for fixation period for currency  
34 TERMVAL OIC_TERMVL WERTV8 CURR 15   2   Formula term value  
35 TERMCURR OIC_TERMCU WAERS CUKY 5   0   Currency for formula term TCURC
36 DDATFRM OIC_DDATFR DATUM DATS 8   0   'Date from' determined for fixation period  
37 DDATTO OIC_DDATTO DATUM DATS 8   0   'Date to' determined for fixation period  
38 CDDATFRM OIC_CDDATF DATUM DATS 8   0   Date from for fixation period for currency  
39 CDDDATTO OIC_CDDATT DATUM DATS 8   0   End date for currency period  
40 TSTAT OIC_TSTAT OIC_TSTAT CHAR 1   0   Term status  
41 CALID OIC_CFACTC WFCID CHAR 2   0   Factory calendar ID for currency TFACD
42 RNDTERM OIC_RNDTERM OIC_EXIT NUMC 3   0   Rule for rounding formula term value  
43 RNDCURT OIC_RNDCURT OIC_EXIT NUMC 3   0   Rule for rounding currency exchange rate  
44 .INCLUDE       0   0    
45 UPDKZ UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OICQ8_WRK CALID TFACD IDENT    
2 OICQ8_WRK MANDT T000 MANDT KEY 1 CN
3 OICQ8_WRK TERMCURR TCURC WAERS 1 N
History
Last changed by/on SAP  20050224 
SAP Release Created in 472