ORFCALC SAP (Data Record ORF Calculation, ATTENTION: MOVE-CORR!) Table details
Dictionary Type: Table
Description: Data Record ORF Calculation, ATTENTION: MOVE-CORR!
Description: Data Record ORF Calculation, ATTENTION: MOVE-CORR!
Table field list including key, data, relationships and ABAP select examples
ORFCALC is a standard SAP Table which is used to store Data Record ORF Calculation, ATTENTION: MOVE-CORR! data and is available within R/3 SAP systems depending on the version and release level.
The ORFCALC table consists of various fields, each holding specific information or linking keys about Data Record ORF Calculation, ATTENTION: MOVE-CORR! data available in SAP. These include SQNBR (Sequence Number), PNR (Part Number), MFR (Manufacturer Code), EIP (End Item Part Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ORFCALC table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SQNBR | Sequence Number | ADSPC_SQNBR | NUMC | 5 | ADSPC_SRNBR | ||||
PNR | Part Number | ADSPC_PNR | CHAR | 15 | CHAR15 | ||||
MFR | Manufacturer Code | ADSPC_MFR | CHAR | 5 | CHAR5 | ||||
EIP | End Item Part Number | ADSPC_EIP | CHAR | 15 | ADSPC_EIP | ||||
EIM | End Item Manufacturer Code | ADSPC_EIM | CHAR | 5 | ADSPC_EIM | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
CALCNR | Number of the Stock Calculation | CALCNR | INT4 | 10 | INT4 | ||||
MOA | Model of Applicability Code | ADSPC_MOA | CHAR | 4 | ADSPC_MOA | ||||
CUS | Customer Code | ADSPC_CUS | CHAR | 5 | CHAR5 | ||||
FLAG_ACTUAL | Status of the Calculation: Current, Previous, Simulation | FLAG_ACTUAL | CHAR | 1 | FLAG_ACTUAL | ||||
CREATED_ON_TIME | SPEC2000: Created on Time | ADSPC_CREATED_ON_TIME | TIMS | 6 | ADSPC_TIME | ||||
CREATED_ON_DATE | SPEC2000: Created on Date | ADSPC_CREATED_ON_DATE | DATS | 8 | ADSPC_DATE | ||||
CREATED_BY | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
PROFL_ID | Customizing Profile for Single Item Stock Calculation | PROFL1_NAME | CHAR | 6 | ORF2CUST | CHAR6 | |||
TEXT | Customizing Profile for Single Item Stock Calculation | TEXT_PRF_ORF | CHAR | 15 | CHAR15 | ||||
NEQ_SYST | Number of Parts per Aircraft | N_EQ | DEC | 16(6) | ORFCALC1 | ||||
NEQ_MANUF | Number of Parts per Aircraft | N_EQ | DEC | 16(6) | ORFCALC1 | ||||
MTBE_SYST | Mean Time Between Events (MTBE) | MTBR | DEC | 16(6) | ORFCALC1 | ||||
MTBE_MANUF | Mean Time Between Events (MTBE) | MTBR | DEC | 16(6) | ORFCALC1 | ||||
TAT_REP_SYSTEM | Repair Time (System) / Provision Period | TAT_REP_SYSTEM | DEC | 16(6) | ORFCALC1 | ||||
TAT_TRP_SYSTEM | Transport Time (System) | TAT_TRP_SYSTEM | DEC | 16(6) | ORFCALC1 | ||||
TAT_REP_MANUF | Repair Time ( Manufacturer) | TAT_REP_MANUF | DEC | 16(6) | ORFCALC1 | ||||
EC_SYSTEM | Essentiality Code | EC | NUMC | 1 | EC | ||||
EC_MANUF | Essentiality Code | EC | NUMC | 1 | EC | ||||
HOMESHOP_SYSTEM | Laboratory/design office | LABOR | CHAR | 3 | T024L | LABOR | |||
PRICE_SYSTEM | Choosed Price (MM): Mov. av. Price or Standard Price | VERPR_STPRS | CURR | 11(2) | WERT11V | ||||
PRICE_MANUF | Price | UNIT_PRICE | CURR | 11(2) | WERT11V | ||||
CURR_SYSTEM | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CURR_MANUF | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MOA_USER | Model of Applicability Code | ADSPC_MOA | CHAR | 4 | ADSPC_MOA | ||||
CUS_USER | Customer Code | ADSPC_CUS | CHAR | 5 | CHAR5 | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
SPC_MANUF | Spare Part Class Code | ADSPC_SPC | NUMC | 1 | ADSPC_SPC | ||||
REC_MANUF | Recommended Quantity | ADSPC_REC | NUMC | 4 | ADSPC_REC | ||||
SPEC2_DUM1 | SPEC2_DUM1 | SPEC2_DUM1 | CHAR | 15 | CHAR15 | ||||
SPEC2_DUM2 | SPEC2_DUM2 | SPEC2_DUM2 | CHAR | 15 | CHAR15 | ||||
SPEC2_DUM3 | SPEC2_DUM3 | SPEC2_DUM3 | CHAR | 15 | CHAR15 | ||||
SPEC2_DUM4 | SPEC2_DUM4 | SPEC2_DUM4 | CHAR | 15 | CHAR15 | ||||
N_TP | Number of Aircraft | N_TP | DEC | 16(6) | ORFCALC1 | ||||
N_EQ | Number of Parts per Aircraft | N_EQ | DEC | 16(6) | ORFCALC1 | ||||
TAU | Operation Time | TAU | DEC | 16(6) | ORFCALC1 | ||||
MTBR | Mean Time Between Events (MTBE) | MTBR | DEC | 16(6) | ORFCALC1 | ||||
TAT_TOT | Turnaround Time / Provision Period | TAT_TOT | DEC | 16(6) | ORFCALC1 | ||||
CL | Service Level | CL | DEC | 16(6) | ORFCALC1 | ||||
MAD | Minimum Annual Demand | MIN_ANN_DEM | DEC | 16(6) | ORFCALC1 | ||||
ALGIN_DUM1 | ALGIN_DUM1 | ALGIN_DUM1 | DEC | 16(6) | ORFCALC1 | ||||
EC_EX | Essentiality Code | EC | NUMC | 1 | EC | ||||
HOMESHOP_EX | Laboratory/design office | LABOR | CHAR | 3 | Assigned to domain | LABOR | |||
DD_EX | Annual Demand | DD | DEC | 16(6) | ORFCALC1 | ||||
N_TP_EX | Number of Aircraft | N_TP | DEC | 16(6) | ORFCALC1 | ||||
N_EQ_EX | Number of Parts per Aircraft | N_EQ | DEC | 16(6) | ORFCALC1 | ||||
TAU_EX | Operation Time | TAU | DEC | 16(6) | ORFCALC1 | ||||
MTBR_EX | Mean Time Between Events (MTBE) | MTBR | DEC | 16(6) | ORFCALC1 | ||||
TAT_REWORK_EX | Repair Time / Provision Period (External Model) | TAT_REWORK_EX | DEC | 16(6) | ORFCALC1 | ||||
TAT_TRANSP_EX | Transport Time (External Model) | TAT_TRANSP_EX | DEC | 16(6) | ORFCALC1 | ||||
CL_EX | Service Level | CL | DEC | 16(6) | ORFCALC1 | ||||
PRICE_EX | Price | UNIT_PRICE | CURR | 11(2) | WERT11V | ||||
MAD_EX | Minimum Annual Demand | MIN_ANN_DEM | DEC | 16(6) | ORFCALC1 | ||||
ALGEX_DUM1 | ALGEX_DUM1 | ALGEX_DUM1 | DEC | 16(6) | ORFCALC1 | ||||
ALGEX_DUM2 | ALGEX_DUM2 | ALGEX_DUM2 | DEC | 16(6) | ORFCALC1 | ||||
ALGEX_DUM3 | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
DD | Annual Demand | DD | DEC | 16(6) | ORFCALC1 | ||||
ASL | Average Shop Load / Provision Period Demand | ASL | DEC | 16(6) | ORFCALC1 | ||||
RF | Rotable Float / Expendable Requirement Quantity | RF | DEC | 16(6) | ORFCALC1 | ||||
ALGOUT_DUM1 | ALGOUT_DUM1 | ALGOUT_DUM1 | DEC | 16(6) | ORFCALC1 | ||||
FLAG_BATCH | Flag: Multiple Item Calculation | FLAG_BATCH | CHAR | 1 | CHAR1 | ||||
FLAG_NO_CALC | Flag: no Calculation possible | FLAG_NO_CALC | CHAR | 1 | CHAR1 | ||||
FLAG_MAD_TYPE | Minimum Annual Demand: regard or not by calculation | MAD_TYPE | CHAR | 1 | MAD_TYPE | ||||
TCC_BATCH2 | Time Cycle Code for URR | ADSPC_URRTCC | CHAR | 1 | ADSPC_URRTCC | ||||
TCC_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TCC_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
MTBE_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
MTBE_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
NTP_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
NTP_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TAU_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TAU_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
NEQ_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
NEQ_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TAT_REP_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TAT_REP_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TAT_TRP_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
TAT_TRP_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
EC_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
EC_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
HS_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
HS_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
PRICE_SRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
PRICE_TRC | Flag: Source / Trace Batch | SRC_TRC_CHAR2 | CHAR | 2 | CHAR2 | ||||
BATCH2_DUM1 | BATCH2_DUM1 | BATCH2_DUM1 | CHAR | 2 | CHAR2 | ||||
BATCH2_DUM2 | BATCH2_DUM2 | BATCH2_DUM2 | CHAR | 2 | CHAR2 | ||||
BATCH2_DUM3 | BATCH2_DUM3 | BATCH2_DUM3 | CHAR | 2 | CHAR2 | ||||
EXTERN_CALC | Flag: External Calculation | EXTERN_CALC | CHAR | 1 | CHAR1 | ||||
INVERSION_CALC | Flag: Inversion Mode | INVERSION_CALC | CHAR | 1 | CHAR1 | ||||
EXPEND_PART | Flag: Calculation of Expendable Part | EXPEND_PART | CHAR | 1 | CHAR1 | ||||
BANF_CREATED | Flag: Purchase Requisition created | BANF_CREATED | CHAR | 1 | CHAR1 | ||||
NO_MM_DATA | Flag: No MM Data available | NO_MM_DATA | CHAR | 1 | CHAR1 | ||||
NO_IP_DATA | Flag: No IP Data available | NO_IP_DATA | CHAR | 1 | CHAR1 | ||||
NO_EX_DATA | Flag: No Extractor Data available | NO_EX_DATA | CHAR | 1 | CHAR1 | ||||
MTBE_SEARCH | Extractor MTBE selection: recent or longest period | SEARCH_MTBE | CHAR | 1 | SEARCH_MTBE | ||||
MTBE_LENGHT | Length of the period | LENPRD | NUMC | 2 | LENPRD | ||||
MTBE_DATETO | End date of time segment | MTBE_DATETO | DATS | 8 | DATUM | ||||
FLAG_NUMERIC | Numerical scheme | FLAG_NUMERIC | CHAR | 1 | FLAG_NUMERIC | ||||
FLAG_NUM_BATCH | Flag for numerical scheme (Multiple Item Calc.) | FLAG_NUM_BATCH | CHAR | 1 | FLAG_NUMERIC | ||||
FLAG_NUM_N | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SUPPL1 | Supplier Code | ADSPC_SPL | CHAR | 5 | CHAR5 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
FLAG_VPRSV | Price control indicator | VPRSV | CHAR | 1 | VPRSV | ||||
IP_MATNR_ASSIGN | Assignment IP - Material | IP_MATNR_ASSIGN | CHAR | 1 | IP_MATNR_ASSIGN | ||||
WRONG_ASSIGN | Wrong Assignment IP - Material | WRONG_ASSIGN | CHAR | 1 | CHAR01 | ||||
MTBE_SY_SRC | System Source for MTBE | MTBE_SY_SRC | CHAR | 1 | CHAR1 | ||||
TAT_REP_SY_SRC | System Source for Repair Time / Prov. Period | TAT_REP_SY_SRC | CHAR | 1 | CHAR1 | ||||
TAT_TRP_SY_SRC | System Source for Transport Time | TAT_TRP_SY_SRC | CHAR | 1 | CHAR1 | ||||
EC_SY_SRC | System Source Essentiality Code | EC_SY_SRC | CHAR | 1 | CHAR1 | ||||
HS_SY_SRC | System Source for Workshop | HS_SY_SRC | CHAR | 1 | CHAR1 | ||||
PRICE_SY_SRC | System Source for Price | PRICE_SY_SRC | CHAR | 1 | CHAR1 | ||||
CURR_SY_SRC | System Source Currency | CURR_SY_SRC | CHAR | 1 | CHAR1 | ||||
MATNR_SY_SRC | System Source for Material | MATNR_SY_SRC | CHAR | 1 | CHAR1 | ||||
CUS_SY_SRC | System Source Customer | CUS_SY_SRC | CHAR | 1 | CHAR1 | ||||
SY_SRC_DUM1 | SY_SRC_DUM1 | SY_SRC_DUM1 | CHAR | 1 | CHAR1 | ||||
CHANGE_MAT | Flag: Change Material | CHANGE_MAT | CHAR | 1 | CHAR1 | ||||
FLAG_DUM1 | FLAG_DUM1 | FLAG_DUM1 | CHAR | 1 | CHAR1 | ||||
FLAG_DUM2 | FLAG_DUM2 | FLAG_DUM2 | CHAR | 1 | CHAR1 | ||||
FLAG_DUM3 | FLAG_DUM3 | FLAG_DUM3 | CHAR | 1 | CHAR1 | ||||
FLAG_DUM4 | FLAG_DUM4 | FLAG_DUM4 | CHAR | 1 | CHAR1 | ||||
FLAG_DUM5 | FLAG_DUM5 | FLAG_DUM5 | CHAR | 1 | CHAR1 | ||||
FLAG_DUM6 | FLAG_DUM6 | FLAG_DUM6 | CHAR | 1 | CHAR1 | ||||
FLAG_DUM7 | FLAG_DUM7 | FLAG_DUM7 | CHAR | 15 | CHAR15 | ||||
FLAG_DUM8 | FLAG_DUM8 | FLAG_DUM8 | CHAR | 15 | CHAR15 | ||||
FLAG_DUM9 | FLAG_DUM9 | FLAG_DUM9 | CHAR | 15 | CHAR15 | ||||
RADIO200 | Position of Radio Button (200) in a String | RADIO200 | CHAR | 30 | RADIO200 |
Key field | Non-key field |
How do I retrieve data from SAP table ORFCALC using ABAP code
The following ABAP code Example will allow you to do a basic selection on ORFCALC to SELECT all data from the tableDATA: WA_ORFCALC TYPE ORFCALC.
SELECT SINGLE *
FROM ORFCALC
INTO CORRESPONDING FIELDS OF WA_ORFCALC
WHERE...
How to access SAP table ORFCALC
Within an ECC or HANA version of SAP you can also view further information about ORFCALC and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects