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
⤷ 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 |