SAP ABAP Table ORFCALC (Data Record ORF Calculation, ATTENTION: MOVE-CORR!)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷ IS-AD (Application Component) Aerospace & Defence Industry Solution
⤷ AD_ROT_CALC (Package) Stock Calculation: Rotables & Expendables
⤷ IS-AD (Application Component) Aerospace & Defence Industry Solution
⤷ AD_ROT_CALC (Package) Stock Calculation: Rotables & Expendables
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ORFCALC | Table Relationship Diagram |
Short Description | Data Record ORF Calculation, ATTENTION: MOVE-CORR! |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SQNBR | ADSPC_SQNBR | ADSPC_SRNBR | NUMC | 5 | 0 | Sequence Number | ||
3 | PNR | ADSPC_PNR | CHAR15 | CHAR | 15 | 0 | Part Number | ||
4 | MFR | ADSPC_MFR | CHAR5 | CHAR | 5 | 0 | Manufacturer Code | ||
5 | EIP | ADSPC_EIP | ADSPC_EIP | CHAR | 15 | 0 | End Item Part Number | ||
6 | EIM | ADSPC_EIM | ADSPC_EIM | CHAR | 5 | 0 | End Item Manufacturer Code | ||
7 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
8 | CALCNR | CALCNR | INT4 | INT4 | 10 | 0 | Number of the Stock Calculation | ||
9 | MOA | ADSPC_MOA | ADSPC_MOA | CHAR | 4 | 0 | Model of Applicability Code | ||
10 | CUS | ADSPC_CUS | CHAR5 | CHAR | 5 | 0 | Customer Code | ||
11 | FLAG_ACTUAL | FLAG_ACTUAL | FLAG_ACTUAL | CHAR | 1 | 0 | Status of the Calculation: Current, Previous, Simulation | ||
12 | CREATED_ON_TIME | ADSPC_CREATED_ON_TIME | ADSPC_TIME | TIMS | 6 | 0 | SPEC2000: Created on Time | ||
13 | CREATED_ON_DATE | ADSPC_CREATED_ON_DATE | ADSPC_DATE | DATS | 8 | 0 | SPEC2000: Created on Date | ||
14 | CREATED_BY | SYUNAME | SYCHAR12 | CHAR | 12 | 0 | User Name | ||
15 | .INCLUDE | 0 | 0 | Various Data IP/ORF for Dynpro Presentation (200) w/o key | |||||
16 | PROFL_ID | PROFL1_NAME | CHAR6 | CHAR | 6 | 0 | Customizing Profile for Single Item Stock Calculation | ORF2CUST | |
17 | TEXT | TEXT_PRF_ORF | CHAR15 | CHAR | 15 | 0 | Customizing Profile for Single Item Stock Calculation | ||
18 | NEQ_SYST | N_EQ | ORFCALC1 | DEC | 16 | 6 | Number of Parts per Aircraft | ||
19 | NEQ_MANUF | N_EQ | ORFCALC1 | DEC | 16 | 6 | Number of Parts per Aircraft | ||
20 | MTBE_SYST | MTBR | ORFCALC1 | DEC | 16 | 6 | Mean Time Between Events (MTBE) | ||
21 | MTBE_MANUF | MTBR | ORFCALC1 | DEC | 16 | 6 | Mean Time Between Events (MTBE) | ||
22 | TAT_REP_SYSTEM | TAT_REP_SYSTEM | ORFCALC1 | DEC | 16 | 6 | Repair Time (System) / Provision Period | ||
23 | TAT_TRP_SYSTEM | TAT_TRP_SYSTEM | ORFCALC1 | DEC | 16 | 6 | Transport Time (System) | ||
24 | TAT_REP_MANUF | TAT_REP_MANUF | ORFCALC1 | DEC | 16 | 6 | Repair Time ( Manufacturer) | ||
25 | EC_SYSTEM | EC | EC | NUMC | 1 | 0 | Essentiality Code | ||
26 | EC_MANUF | EC | EC | NUMC | 1 | 0 | Essentiality Code | ||
27 | HOMESHOP_SYSTEM | LABOR | LABOR | CHAR | 3 | 0 | Laboratory/design office | T024L | |
28 | PRICE_SYSTEM | VERPR_STPRS | WERT11V | CURR | 11 | 2 | Choosed Price (MM): Mov. av. Price or Standard Price | ||
29 | PRICE_MANUF | UNIT_PRICE | WERT11V | CURR | 11 | 2 | Price | ||
30 | CURR_SYSTEM | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
31 | CURR_MANUF | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
32 | MOA_USER | ADSPC_MOA | ADSPC_MOA | CHAR | 4 | 0 | Model of Applicability Code | ||
33 | CUS_USER | ADSPC_CUS | CHAR5 | CHAR | 5 | 0 | Customer Code | ||
34 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
35 | SPC_MANUF | ADSPC_SPC | ADSPC_SPC | NUMC | 1 | 0 | Spare Part Class Code | ||
36 | REC_MANUF | ADSPC_REC | ADSPC_REC | NUMC | 4 | 0 | Recommended Quantity | ||
37 | SPEC2_DUM1 | SPEC2_DUM1 | CHAR15 | CHAR | 15 | 0 | SPEC2_DUM1 | ||
38 | SPEC2_DUM2 | SPEC2_DUM2 | CHAR15 | CHAR | 15 | 0 | SPEC2_DUM2 | ||
39 | SPEC2_DUM3 | SPEC2_DUM3 | CHAR15 | CHAR | 15 | 0 | SPEC2_DUM3 | ||
40 | SPEC2_DUM4 | SPEC2_DUM4 | CHAR15 | CHAR | 15 | 0 | SPEC2_DUM4 | ||
41 | .INCLUDE | 0 | 0 | Inputvariables of Algorithm for Optimal Rotable Float | |||||
42 | N_TP | N_TP | ORFCALC1 | DEC | 16 | 6 | Number of Aircraft | ||
43 | N_EQ | N_EQ | ORFCALC1 | DEC | 16 | 6 | Number of Parts per Aircraft | ||
44 | TAU | TAU | ORFCALC1 | DEC | 16 | 6 | Operation Time | ||
45 | MTBR | MTBR | ORFCALC1 | DEC | 16 | 6 | Mean Time Between Events (MTBE) | ||
46 | TAT_TOT | TAT_TOT | ORFCALC1 | DEC | 16 | 6 | Turnaround Time / Provision Period | ||
47 | CL | CL | ORFCALC1 | DEC | 16 | 6 | Service Level | ||
48 | MAD | MIN_ANN_DEM | ORFCALC1 | DEC | 16 | 6 | Minimum Annual Demand | ||
49 | ALGIN_DUM1 | ALGIN_DUM1 | ORFCALC1 | DEC | 16 | 6 | ALGIN_DUM1 | ||
50 | .INCLUDE | 0 | 0 | Inputvar. of Alg. for Opt. Rotable Float (External Model) | |||||
51 | EC_EX | EC | EC | NUMC | 1 | 0 | Essentiality Code | ||
52 | HOMESHOP_EX | LABOR | LABOR | CHAR | 3 | 0 | Laboratory/design office | * | |
53 | DD_EX | DD | ORFCALC1 | DEC | 16 | 6 | Annual Demand | ||
54 | N_TP_EX | N_TP | ORFCALC1 | DEC | 16 | 6 | Number of Aircraft | ||
55 | N_EQ_EX | N_EQ | ORFCALC1 | DEC | 16 | 6 | Number of Parts per Aircraft | ||
56 | TAU_EX | TAU | ORFCALC1 | DEC | 16 | 6 | Operation Time | ||
57 | MTBR_EX | MTBR | ORFCALC1 | DEC | 16 | 6 | Mean Time Between Events (MTBE) | ||
58 | TAT_REWORK_EX | TAT_REWORK_EX | ORFCALC1 | DEC | 16 | 6 | Repair Time / Provision Period (External Model) | ||
59 | TAT_TRANSP_EX | TAT_TRANSP_EX | ORFCALC1 | DEC | 16 | 6 | Transport Time (External Model) | ||
60 | CL_EX | CL | ORFCALC1 | DEC | 16 | 6 | Service Level | ||
61 | PRICE_EX | UNIT_PRICE | WERT11V | CURR | 11 | 2 | Price | ||
62 | MAD_EX | MIN_ANN_DEM | ORFCALC1 | DEC | 16 | 6 | Minimum Annual Demand | ||
63 | ALGEX_DUM1 | ALGEX_DUM1 | ORFCALC1 | DEC | 16 | 6 | ALGEX_DUM1 | ||
64 | ALGEX_DUM2 | ALGEX_DUM2 | ORFCALC1 | DEC | 16 | 6 | ALGEX_DUM2 | ||
65 | ALGEX_DUM3 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
66 | .INCLUDE | 0 | 0 | Output Variables of Algorithm for Optimal Rotable Float | |||||
67 | DD | DD | ORFCALC1 | DEC | 16 | 6 | Annual Demand | ||
68 | ASL | ASL | ORFCALC1 | DEC | 16 | 6 | Average Shop Load / Provision Period Demand | ||
69 | RF | RF | ORFCALC1 | DEC | 16 | 6 | Rotable Float / Expendable Requirement Quantity | ||
70 | ALGOUT_DUM1 | ALGOUT_DUM1 | ORFCALC1 | DEC | 16 | 6 | ALGOUT_DUM1 | ||
71 | .INCLUDE | 0 | 0 | ORF: Data Saving for Batch (SRC=SOURCE, TRC=TRACE) | |||||
72 | FLAG_BATCH | FLAG_BATCH | CHAR1 | CHAR | 1 | 0 | Flag: Multiple Item Calculation | ||
73 | FLAG_NO_CALC | FLAG_NO_CALC | CHAR1 | CHAR | 1 | 0 | Flag: no Calculation possible | ||
74 | FLAG_MAD_TYPE | MAD_TYPE | MAD_TYPE | CHAR | 1 | 0 | Minimum Annual Demand: regard or not by calculation | ||
75 | TCC_BATCH2 | ADSPC_URRTCC | ADSPC_URRTCC | CHAR | 1 | 0 | Time Cycle Code for URR | ||
76 | TCC_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
77 | TCC_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
78 | MTBE_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
79 | MTBE_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
80 | NTP_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
81 | NTP_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
82 | TAU_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
83 | TAU_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
84 | NEQ_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
85 | NEQ_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
86 | TAT_REP_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
87 | TAT_REP_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
88 | TAT_TRP_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
89 | TAT_TRP_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
90 | EC_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
91 | EC_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
92 | HS_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
93 | HS_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
94 | PRICE_SRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
95 | PRICE_TRC | SRC_TRC_CHAR2 | CHAR2 | CHAR | 2 | 0 | Flag: Source / Trace Batch | ||
96 | BATCH2_DUM1 | BATCH2_DUM1 | CHAR2 | CHAR | 2 | 0 | BATCH2_DUM1 | ||
97 | BATCH2_DUM2 | BATCH2_DUM2 | CHAR2 | CHAR | 2 | 0 | BATCH2_DUM2 | ||
98 | BATCH2_DUM3 | BATCH2_DUM3 | CHAR2 | CHAR | 2 | 0 | BATCH2_DUM3 | ||
99 | .INCLUDE | 0 | 0 | Several Flags which describe the State of ORF Calculation | |||||
100 | EXTERN_CALC | EXTERN_CALC | CHAR1 | CHAR | 1 | 0 | Flag: External Calculation | ||
101 | INVERSION_CALC | INVERSION_CALC | CHAR1 | CHAR | 1 | 0 | Flag: Inversion Mode | ||
102 | EXPEND_PART | EXPEND_PART | CHAR1 | CHAR | 1 | 0 | Flag: Calculation of Expendable Part | ||
103 | BANF_CREATED | BANF_CREATED | CHAR1 | CHAR | 1 | 0 | Flag: Purchase Requisition created | ||
104 | NO_MM_DATA | NO_MM_DATA | CHAR1 | CHAR | 1 | 0 | Flag: No MM Data available | ||
105 | NO_IP_DATA | NO_IP_DATA | CHAR1 | CHAR | 1 | 0 | Flag: No IP Data available | ||
106 | NO_EX_DATA | NO_EX_DATA | CHAR1 | CHAR | 1 | 0 | Flag: No Extractor Data available | ||
107 | MTBE_SEARCH | SEARCH_MTBE | SEARCH_MTBE | CHAR | 1 | 0 | Extractor MTBE selection: recent or longest period | ||
108 | MTBE_LENGHT | LENPRD | LENPRD | NUMC | 2 | 0 | Length of the period | ||
109 | MTBE_DATETO | MTBE_DATETO | DATUM | DATS | 8 | 0 | End date of time segment | ||
110 | FLAG_NUMERIC | FLAG_NUMERIC | FLAG_NUMERIC | CHAR | 1 | 0 | Numerical scheme | ||
111 | FLAG_NUM_BATCH | FLAG_NUM_BATCH | FLAG_NUMERIC | CHAR | 1 | 0 | Flag for numerical scheme (Multiple Item Calc.) | ||
112 | FLAG_NUM_N | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
113 | SUPPL1 | ADSPC_SPL | CHAR5 | CHAR | 5 | 0 | Supplier Code | ||
114 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
115 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
116 | FLAG_VPRSV | VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
117 | IP_MATNR_ASSIGN | IP_MATNR_ASSIGN | IP_MATNR_ASSIGN | CHAR | 1 | 0 | Assignment IP - Material | ||
118 | WRONG_ASSIGN | WRONG_ASSIGN | CHAR01 | CHAR | 1 | 0 | Wrong Assignment IP - Material | ||
119 | .INCLUDE | 0 | 0 | Identifies source of system values: Default, System, etc. | |||||
120 | MTBE_SY_SRC | MTBE_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source for MTBE | ||
121 | TAT_REP_SY_SRC | TAT_REP_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source for Repair Time / Prov. Period | ||
122 | TAT_TRP_SY_SRC | TAT_TRP_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source for Transport Time | ||
123 | EC_SY_SRC | EC_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source Essentiality Code | ||
124 | HS_SY_SRC | HS_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source for Workshop | ||
125 | PRICE_SY_SRC | PRICE_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source for Price | ||
126 | CURR_SY_SRC | CURR_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source Currency | ||
127 | MATNR_SY_SRC | MATNR_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source for Material | ||
128 | CUS_SY_SRC | CUS_SY_SRC | CHAR1 | CHAR | 1 | 0 | System Source Customer | ||
129 | SY_SRC_DUM1 | SY_SRC_DUM1 | CHAR1 | CHAR | 1 | 0 | SY_SRC_DUM1 | ||
130 | CHANGE_MAT | CHANGE_MAT | CHAR1 | CHAR | 1 | 0 | Flag: Change Material | ||
131 | FLAG_DUM1 | FLAG_DUM1 | CHAR1 | CHAR | 1 | 0 | FLAG_DUM1 | ||
132 | FLAG_DUM2 | FLAG_DUM2 | CHAR1 | CHAR | 1 | 0 | FLAG_DUM2 | ||
133 | FLAG_DUM3 | FLAG_DUM3 | CHAR1 | CHAR | 1 | 0 | FLAG_DUM3 | ||
134 | FLAG_DUM4 | FLAG_DUM4 | CHAR1 | CHAR | 1 | 0 | FLAG_DUM4 | ||
135 | FLAG_DUM5 | FLAG_DUM5 | CHAR1 | CHAR | 1 | 0 | FLAG_DUM5 | ||
136 | FLAG_DUM6 | FLAG_DUM6 | CHAR1 | CHAR | 1 | 0 | FLAG_DUM6 | ||
137 | FLAG_DUM7 | FLAG_DUM7 | CHAR15 | CHAR | 15 | 0 | FLAG_DUM7 | ||
138 | FLAG_DUM8 | FLAG_DUM8 | CHAR15 | CHAR | 15 | 0 | FLAG_DUM8 | ||
139 | FLAG_DUM9 | FLAG_DUM9 | CHAR15 | CHAR | 15 | 0 | FLAG_DUM9 | ||
140 | RADIO200 | RADIO200 | RADIO200 | CHAR | 30 | 0 | Position of Radio Button (200) in a String |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ORFCALC | HOMESHOP_SYSTEM | T024L | LABOR | |||
2 | ORFCALC | MANDT | T000 | MANDT | KEY | ||
3 | ORFCALC | PROFL_ID | ORF2CUST | PROFL_ID |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C2 |