User manual BUSINESS OBJECTS PRODUCTION PLANNING RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.2.0

[. . . ] SAP BusinessObjects Production Planning Rapid Mart XI 3. 2, version for SAP solutions - User Guide Version 12. 2. 2. 0 October 2009 Copyright © Copyright 2009 SAP AG. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Trademarks All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. [. . . ] The same order type can be used in all controlling areas in one client. Examples: production orders, maintenance orders (Plant Maintenance Service Orders), capital investment orders, and marketing orders. Notification Document Type - A key that determines the origin, content, and other features of service, maintenance, and quality notifications. The following notification types exist in the standard SAP Applications system: - Maintenance notifications, including malfunction and activity reports and maintenance requests - Service notifications, including problem notifications, service requests, and activity reports - Quality notifications, including complaints against the vendor, customer complaints, and internal problems · · Purchase Document Type - A further subdivision of Purchase Document Categories. 290 SAP BusinessObjects Production Planning Rapid Mart XI 3. 2 for SAP solutions User Guide Universe SAP Master Data Universe 5 · · Sales Document Type - A categorization of a Sales Document as an invoice, credit memo, debit memo, pro forma invoice, or cancellation document. Special Ledger Document Type - Document Type (tables T889 and T889TE) Reference Date Key Key determining the reference date for various entities - Milestone, PRT Domain MLST_SDDAT; TCA55 Special Stock Indicator Stock of materials that must be managed separately for reasons of ownership or location. Standard Text Key Standard text Key descriptions for activities from T435T. Standard Value Key Capacity Standard Value Key descriptive attributes from TC21T. In a depreciation area, in addition to the acquisition and production costs and ordinary depreciation, the following special valuation types can be calculated: Revaluation, Investment support measures, Special depreciation, Unplanned depreciation, Transfer of reserves, and Interest. ACCOUNTING DOCUMENT ATTRIBUTES · · · · · · Bank Account Information - Bank account details defined by account. Controlling (Business) Transaction Type - Cost Accounting (or business) transaction types. Values: H = Credit, S = Debit Financial Document Status - Status (from Domain BSTAT), indicates if a financial document is a normal, clearing or parked document. Financial Record Category - Categorization for a financial document. SAP BusinessObjects Production Planning Rapid Mart XI 3. 2 for SAP solutions User Guide 291 5 Universe SAP Master Data Universe · · · · Financial Record Type - Special Ledger Record Types (Domain RRCTY) from table DD07T and Cost/Plant Maintenance value types from CO_WRTTP domain of DD07T table Financial Version - Special Ledger Version (T894T table in SAP solutions) Ledger Group - A combination of ledgers for the purpose of applying the functions and processes of general ledger accounting to the group as a whole. Payment Block - An indicator that allows you (by entering a payment block) to block an account or individual items for payment. The payment blocking indicator is placed in the customer or vendor's master record, or in the line item. from table T008T - indicates any Holds preventing payment to a vendor. Payment Reason - From table T053S - Classification of Payment Differences (Texts) Payment Term - Relevant only for Financial Documents, describes when payments to a vendor or from a customer are due. Posting Key Type -The posting key defines if it is a debit or credit posting, and which account type (customer or vendor) is posted. The posting keys for special G/L transactions must be indicated as such. Segment - A division of a company that can create its own financial statements for external reporting. The segment is then derived from the assigned profit center during posting. Special GL Indicators - Special G/L transactions are special transactions in accounts receivable and accounts payable that are displayed separately in the general ledger and the subledger. This is achieved by posting to alternative reconciliation accounts, instead of posting to the reconciliation accounts for receivables and payables. [. . . ] This is a combined dimension combining different varieties of "object type" from different sources. This field identifies the source of "object type" STPO. SANKO - Indicator: item relevant to engineering INTEGER 4 0 0 yes 28 DIM_SRC_ID_OBJTYP PK NVARCSTR 10 0 0 no 29 ENGRNG_RELEVNT _FLAG INTEGER 4 0 0 yes 30 FIXED_QTY_FLAG STPO. FMENG - Fixed qty indicator INTEGER 4 0 0 yes 31 LOAD_DATE Date and time loaded into Rapid Mart DATETIME 24 0 9 yes 32 LOAD_TIME Time loaded into Rapid Mart NVARCSTR 8 0 0 yes 33 MATERIAL_ID PK MAST. MATNR - Material ID NVARCSTR 18 0 0 no 34 MATERIAL_ID_INTRA STPO. INTRM - Intra material (MARA) NVARCSTR 18 0 0 yes Rapid Mart Data Schema 115 Appendix Table Column Details MAST. MATNR+MAST. WERKS Concatenation of Material and Plant IDs A 35 MATERIAL_KEY PK NVARCSTR 22 0 0 yes 36 MTRL_GRP_ID PK MARA. MATKL -Material group NVARCSTR 9 0 0 no 37 MTRL_TYPE_ID PK MARA. MTART -Material type NVARCSTR 4 0 0 no 38 OBJ_TYPE_ID PK STPO. OBJTY - Object type (BOM item) NVARCSTR 10 0 0 no 39 OTHER_ALTERNATIV E_FLAG STPO. VALKZ -Indicator: item in more than one INTEGER alternative 4 0 0 yes 40 PLANT_ID PK MAST. WERKS - Plant NVARCSTR 4 0 0 no 41 PLANT_ID_CMPNT PK STPO-PSWRK - Issuing plant NVARCSTR 4 0 0 yes 42 PM_ASSEMBLY_FLAG STPO. STKKZ - PM assembly indicator INTEGER 4 0 0 yes 43 PM_RELEVNT_FLAG STPO. SANIN - Indicator: item relevant to plant INTEGER maintenance 4 0 0 yes 44 PRCNT_SCRAP STPO. AUSCH - Component scrap in percent DECIMAL 48 5 2 yes 45 PRICE_UNIT STPO-PEINH - Price unit INTEGER 4 0 0 yes 46 PROD_HIER_ID PK MARA. PRDHA -Product hierarchy NVARCSTR 18 0 0 no 47 PROD_RELEVNT_FLA G STPO. SANFE - Indicator: item relevant to production INTEGER 4 0 0 yes 48 PURCH_GRP_ID PK STPO. EKGRP Purchasing group NVARCSTR 3 0 0 yes 49 PURCH_ORG_ID PK STPO. EKORG - Purchasing organization NVARCSTR 4 0 0 no 50 QTY STPO-MENGE - Component quantity DECIMAL 48 13 3 yes 51 QTY_BOM STKO-BMENG - Base quantity for BOM Material DECIMAL 48 13 3 yes 52 SPARE_PART_ID PK STPO. ERSKZ - Spare part indicator NVARCSTR 1 0 0 no Rapid Mart Data Schema 116 Appendix Table Column Details STORAGE_LOCATN_I PK D STPO. LGORT - Issue Plant location for production order A 53 NVARCSTR 4 0 0 no 54 SUPPLY_AREA_ID PK STPO. PRVBE - Supply area NVARCSTR 10 0 0 no 55 SURROGATE_DOC_ID PK Alternate key generated in the Rapid Mart for reporting purposes DECIMAL 48 18 0 no 56 UOM_ID PK STPO-MEINS - Component unit of measure NVARCSTR 3 0 0 no 57 UOM_ID_BOM PK STKO-BMEIN - Base unit of measure for BOM NVARCSTR 3 0 0 no 58 VALID_FROM_DATE STAS. DATUV - Valid-from date component-related STKO-DATUV - Valid-from date for BOM Header DATETIME 24 0 9 no 59 VALID_FROM_DATE_ BOM DATETIME 24 0 9 yes 60 VALID_TO_DATE Calculated Component Valid-To date DATETIME 24 0 9 yes 61 VALUATN_AREA_ID PK T001W. BWKEY -Valuation area NVARCSTR 4 0 0 no 62 VENDOR_ID PK STPO-LIFNR - Account number of the vendor NVARCSTR or creditor 10 0 0 no Rapid Mart Data Schema 117 Appendix Table Column Details A PRODUCTION_BOM_STAGE Mirror staging table for PRODUCTION_BOM_EXPLOSION to perfrom replacement of aggregated level lines into multiple lines if dupicate BOM components are detected # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ALT_BOM_ID PK STKO-STLAL - Alternative BOM - Level 0 NVARCSTR 2 0 0 no 2 BOM_ID PK STKO-STLNR - Bill of material NVARCSTR 8 0 0 no 3 LEAF_LEVEL Hierarchy Leaf Level INTEGER 4 0 0 yes 4 LOAD_DATE Date and time loaded into Rapid Mart DATETIME 24 0 9 yes 5 LOAD_TIME Time when the record was loaded NVARCSTR 8 0 0 yes 6 LVL_01_CMPNT_FULL _NAME MARA. MATNR + MAKT. MAKTX - Material ID and Material Description - Level 1 Concatenated surrogate key for Level 1 Component ID, Alt BOM Id, Node Item ID STKO-STLAL - Alternative BOM - Level 1 as parent of Level 2 NVARCSTR 64 0 0 yes 7 LVL_01_ID PK NVARCSTR 30 0 0 no 8 LVL_01_ID_ALT_BOM NVARCSTR 2 0 0 yes 9 LVL_01_ID_CMPNT STPO-IDNRK - BOM component - Level 1 NVARCSTR 18 0 0 yes 10 LVL_01_ID_ITEM STPO-POSNR - BOM item number - Level 1 NVARCSTR 4 0 0 yes 11 LVL_01_ID_UOM STPO-MEINS - Component unit of measure Level 1 NVARCSTR 3 0 0 yes 12 LVL_01_NUM_TIMES_ USED Count number of times component is referenced in BOM to see if special handling is INTEGER required - Level 1 STPO-MENGE - Component quantity - Level 1 MARA. MATNR + MAKT. MAKTX - Material ID and Material Description - Level 2 Concatenated surrogate key for Level 2 Component ID, Alt BOM Id, Node Item ID STKO-STLAL - Alternative BOM - Level 2 as parent of Level 3 DECIMAL 4 0 0 yes 13 LVL_01_QTY 48 13 3 yes 14 LVL_02_CMPNT_FULL _NAME NVARCSTR 64 0 0 yes 15 LVL_02_ID PK NVARCSTR 30 0 0 no 16 LVL_02_ID_ALT_BOM NVARCSTR 2 0 0 yes Rapid Mart Data Schema 118 Appendix Table Column Details A 17 LVL_02_ID_CMPNT STPO-IDNRK - BOM component - Level 2 NVARCSTR 18 0 0 yes 18 LVL_02_ID_ITEM STPO-POSNR - BOM item number - Level 2 NVARCSTR 4 0 0 yes 19 LVL_02_ID_UOM STPO-MEINS - Component unit of measure Level 2 NVARCSTR 3 0 0 yes 20 LVL_02_NUM_TIMES_ USED Count number of times component is referenced in BOM to see if special handling is INTEGER required - Level 2 STPO-MENGE - Component quantity - Level 2 DECIMAL 4 0 0 yes 21 LVL_02_QTY 48 13 3 yes 22 LVL_03_CMPNT_FULL _NAME MARA. MATNR + MAKT. MAKTX - Material ID and Material Description - Level 3 Concatenated surrogate key for Level 3 Component ID, Alt BOM Id, Node Item ID STKO-STLAL - Alternative BOM - Level 3 as parent of Level 4 NVARCSTR 64 0 0 yes 23 LVL_03_ID PK NVARCSTR 30 0 0 no 24 LVL_03_ID_ALT_BOM NVARCSTR 2 0 0 yes 25 LVL_03_ID_CMPNT STPO-IDNRK - BOM component - Level 3 NVARCSTR 18 0 0 yes 26 LVL_03_ID_ITEM STPO-POSNR - BOM item number - Level 3 NVARCSTR 4 0 0 yes 27 LVL_03_ID_UOM STPO-MEINS - Component unit of measure Level 3 NVARCSTR 3 0 0 yes 28 LVL_03_NUM_TIMES_ USED Count number of times component is referenced in BOM to see if special handling is INTEGER required - Level 3 STPO-MENGE - Component quantity - Level 3 DECIMAL 4 0 0 yes 29 LVL_03_QTY 48 13 3 yes 30 LVL_04_CMPNT_FULL _NAME MARA. MATNR + MAKT. MAKTX - Material ID and Material Description - Level 4 Concatenated surrogate key for Level 4 Component ID, Alt BOM Id, Node Item ID STKO-STLAL - Alternative BOM - Level 4 as parent of Level 5 NVARCSTR 64 0 0 yes 31 LVL_04_ID PK NVARCSTR 30 0 0 no 32 LVL_04_ID_ALT_BOM NVARCSTR 2 0 0 yes 33 LVL_04_ID_CMPNT STPO-IDNRK - BOM component - Level 4 NVARCSTR 18 0 0 yes 34 LVL_04_ID_ITEM STPO-POSNR - BOM item number - Level 4 NVARCSTR 4 0 0 yes Rapid Mart Data Schema 119 Appendix Table Column Details STPO-MEINS - Component unit of measure Level 4 A 35 LVL_04_ID_UOM NVARCSTR 3 0 0 yes 36 LVL_04_NUM_TIMES_ USED Count number of times component is referenced in BOM to see if special handling is INTEGER required - Level 4 STPO-MENGE - Component quantity - Level 4 DECIMAL 4 0 0 yes 37 LVL_04_QTY 48 13 3 yes 38 LVL_05_CMPNT_FULL _NAME MARA. MATNR + MAKT. MAKTX - Material ID and Material Description - Level 5 Concatenated surrogate key for Level 5 Component ID, Alt BOM Id, Node Item ID STKO-STLAL - Alternative BOM - Level 5 as parent of Level 6 NVARCSTR 64 0 0 yes 39 LVL_05_ID PK NVARCSTR 30 0 0 no 40 LVL_05_ID_ALT_BOM NVARCSTR 2 0 0 yes 41 LVL_05_ID_CMPNT STPO-IDNRK - BOM component - Level 5 NVARCSTR 18 0 0 yes 42 LVL_05_ID_ITEM STPO-POSNR - BOM item number - Level 5 NVARCSTR 4 0 0 yes 43 LVL_05_ID_UOM STPO-MEINS - Component unit of measure Level 5 NVARCSTR 3 0 0 yes 44 LVL_05_NUM_TIMES_ USED Count number of times component is referenced in BOM to see if special handling is INTEGER required - Level 5 STPO-MENGE - Component quantity - Level 5 DECIMAL 4 0 0 yes 45 LVL_05_QTY 48 13 3 yes 46 LVL_06_CMPNT_FULL _NAME MARA. MATNR + MAKT. MAKTX - Material ID and Material Description - Level 6 Concatenated surrogate key for Level 6Component ID, Alt BOM Id, Node Item ID NVARCSTR 64 0 0 yes 47 LVL_06_ID PK NVARCSTR 30 0 0 no 48 LVL_06_ID_ALT_BOM STKO-STLAL - Alternative BOM - Level 6 NVARCSTR 2 0 0 yes 49 LVL_06_ID_CMPNT STPO-IDNRK - BOM component - Level 6 NVARCSTR 18 0 0 yes 50 LVL_06_ID_ITEM STPO-POSNR - BOM item number - Level 6 NVARCSTR 4 0 0 yes 51 LVL_06_ID_UOM STPO-MEINS - Component unit of measure Level 6 NVARCSTR 3 0 0 yes 52 LVL_06_NUM_TIMES_ USED Count number of times component is referenced in BOM to see if special handling is INTEGER required - Level 6 4 0 0 yes Rapid Mart Data Schema 120 Appendix Table Column Details A 53 LVL_06_QTY STPO-MENGE - Component quantity - Level 6 DECIMAL 48 13 3 yes 54 MATERIAL_ID PK MAST. MATNR - Material ID (Root, Level 0)) NVARCSTR 18 0 0 no 55 MTRL_FULL_NAME MARA. MATNR + MAKT. MAKTX - Material ID and Material Description NVARCSTR 64 0 0 yes 56 PLANT_ID PK MAST. WERKS - Plant ID NVARCSTR 4 0 0 no 57 QTY_BOM STKO-BMENG - Base quantity for BOM Material DECIMAL 48 13 3 yes 58 UOM_ID_BOM STKO-BMEIN - Base unit of measure for BOM NVARCSTR 3 0 0 yes Rapid Mart Data Schema 121 Appendix Table Column Details A PRODUCTION_OPERATION_FACT Production Order Operations from AFVC/AUFK/AFKO # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACTIVITY_ID PK AFVC. LARNT - Activity Type NVARCSTR 6 0 0 no 2 ACTL_END_DATE AFVV-IEDD - Actual finish: Execution (date) + AFVV-ISDZ - AFVV-IEDZ - Actual finish: DATETIME Execution (time) AFVV-ISDD - Actual start: Execution (date) + AFVV-ISDZ - Actual start: Execution/setup (time) AFVC. MAT_PRKST - Material planning in networks: primary costs AFVC. PRKST - Total Costs in the activity Planned DATETIME 24 0 9 yes 3 ACTL_START_DATE 24 0 9 yes 4 AMT_COST_MTRL DECIMAL 48 11 2 yes 5 AMT_COST_TTL DECIMAL 48 11 2 yes 6 AMT_PRICE AFVC. PREIS - Price DECIMAL 48 11 2 yes 7 BUS_AREA_ID PK AFVC. GSBER - Business Area NVARCSTR 4 0 0 no 8 CAPACITY_REQ_ID AFVC. BEDID - ID of the capacity requirements NVARCSTR record 12 0 0 yes 9 CHART_OF_ACCT_ID PK T001. KTOPL-Chart of accts ID - Lookup NVARCSTR 4 0 0 no 10 CMPNY_CODE_ID PK AFVC. BUKRS Company Code NVARCSTR 4 0 0 no 11 COMPLT_FLAG AFVC-LEKNW - Indicator showing no remaining work expected if set to 1 AFVC. RUECK Completion confirmation number for the operation INTEGER 4 0 0 yes 12 CONFIRMATN_ID NVARCSTR 10 0 0 yes 13 CONFIRMATN_SEQ_I D AFVC. RMZHL- Confirmation counter NVARCSTR 8 0 0 yes 14 COSTNG_FLAG AFVC. SELKZ - Selection indicator for costing line items INTEGER 4 0 0 yes 15 COST_CNTR_ID PK AUFK. KOSTV -Responsible cost center NVARCSTR 10 0 0 no 16 COST_ELEM_ID PK AFVC. SAKTO - Cost Element NVARCSTR 10 0 0 no Rapid Mart Data Schema 122 Appendix Table Column Details A 17 CREATE_DATE PK AUFK. ERDAT -Order Create date DATETIME 24 0 9 no 18 CTRL_AREA_ID PK AUFK-KOKRS - Controlling area NVARCSTR 4 0 0 no 19 CTRL_KEY_ID PK AFVC. STEUS - Control key NVARCSTR 4 0 0 no 20 CURR_ID PK AFVC. WAERS - Currency Key NVARCSTR 5 0 0 no 21 DAYS_EXECUTN_ACT L DAYS_EXECUTN_S CHED Calcualted Days of Operation exeuction/startup DECIMAL time (as Actl Start and Actl End datetime) Calcualted Days of Operation exeuction/startup DECIMAL time (as Sched Start and Sched End datetime) JEST-STAT (lookup) - DEL operation isdeleted status is active (1 is active, 0 is inactive) PK Dimension Source from table AW_DIMENSION_SOURCE - hard-coded to 'INT_ORDER' Dimension Source. This is a combined dimension combining different varieties of "object type" from different sources. This field identifies the source of "object type" -' AUFK. AUTYP - Document Category from multiple Sources in SAP 48 22 7 yes 22 48 22 7 yes 23 DELETE_FLAG INTEGER 4 0 0 yes 24 DIM_SRC_ID_DOCTY P NVARCSTR 10 0 0 no 25 DIM_SRC_ID_OBJTYP PK NVARCSTR 10 0 0 no 26 DOC_CATEG_ID PK NVARCSTR 10 0 0 no 27 DOC_TYPE_ID PK AUFK. AUART - Order Type NVARCSTR 10 0 0 no 28 EXECUTN_FACTOR AFVV-AUFKT - Execution factor INTEGER 4 0 0 yes 29 FINAL_CONFIRM_FLA G JEST-STAT (lookup) - CNF operation is finally confirmed status is active (1 is active, 0 is INTEGER inactive) PK AUFK. FUNC_AREA -Functional Area NVARCSTR 4 0 0 yes 30 FUNCTNL_AREA_ID 16 0 0 no 31 GROUP_ID PK AFVC. PLNNR Group key NVARCSTR 8 0 0 yes 32 GROUP_LINE_ID PK AFVC. PLNFL - Sequence of operations within a task list NVARCSTR 6 0 0 yes 33 GROUP_NODE_ID PK AFVC. PLNKN - Number of the task list node NVARCSTR 8 0 0 yes 34 GROUP_TYPE_ID PK AFVC. PLNTY -Task List Type NVARCSTR 1 0 0 yes Rapid Mart Data Schema 123 Appendix Table Column Details HOURS_EXECUTN_ ACTL HOURS_EXECUTN_ SCHED Calcualted Hours of Operation exeuction/startup time (as Actl Start and Actl End datetime) Calcualted Hours of Operation exeuction/startup time (as Sched Start and Sched End datetime) AUFK. AUFNR - Order Number A 35 DECIMAL 48 22 7 yes 36 DECIMAL 48 22 7 yes 37 INTERNAL_ORDER_ID PK NVARCSTR 12 0 0 no 38 LOAD_DATE Date loaded into RapidMart DATETIME 24 0 9 yes 39 LOAD_TIME Time loaded into RapidMart NVARCSTR 8 0 0 yes 40 LOCATN_ID PK AUFK. STORT -Location (work Center, Plant) NVARCSTR 10 0 0 no 41 MATERIAL_ID AFKO. PLNBEZ /STLBEZ - Material Number NVARCSTR 18 0 0 yes 42 MINS_EXECUTN_ACT L MINS_EXECUTN_SCH ED Calcualted Mins of Operation exeuction/startup DECIMAL time (as Actl Start and Actl End datetime) Calcualted Mins of Operation exeuction/startup DECIMAL time (as Sched Start and Sched End datetime) 48 22 7 yes 43 48 22 7 yes 44 MTRL_GRP_ID MARA. MATKL Material group ID NVARCSTR 9 0 0 yes 45 MTRL_TYPE_ID MARA. MTART Material type NVARCSTR 4 0 0 yes 46 OBJ_CLASS_ID PK AFVC. SCOPE - Object Class NVARCSTR 10 0 0 no 47 OBJ_ID PK AFVC. OBJNR - Object number NVARCSTR 22 0 0 yes 48 OBJ_NUM_TYPE_ID PK AFVC. OBJNR Object number first 2 characters NVARCSTR 2 0 0 yes 49 OBJ_TYPE_ID PK AFVC. OTYPE - Object type NVARCSTR 10 0 0 no 50 OPERATN_DESCR AFVC. LTXA1 - Operation short text NVARCSTR 40 0 0 yes 51 OPERATN_NUM AFVC. VORNR - Activity Number NVARCSTR 4 0 0 yes 52 OPERATN_NUM_PAR AFVC. SUMNR - Node number of the superior operation NVARCSTR 8 0 0 yes Rapid Mart Data Schema 124 Appendix Table Column Details OPERATN_ROUTING_ PK ID AFVC. AUFPL - Routing number of operations in the order A 53 NVARCSTR 10 0 0 no 54 OPERATN_SEQ_ID PK AFVC. APLZL - General counter for order JEST-STAT (lookup) -PCNF operation is partially confirmed status is active (1 is active, 0 is inactive) NVARCSTR 8 0 0 no 55 PARTL_CONFIRM_FL AG INTEGER 4 0 0 yes 56 PLANT_ID PK AFVC. WERKS - Plant NVARCSTR 4 0 0 no 57 PRICE_UNIT AFVC. PEINH - Price Unit INTEGER 4 0 0 yes 58 PROD_HIER_ID MARA. PRDHA Product hierarchy NVARCSTR 18 0 0 yes 59 PROFIT_CNTR_ID PK AFVC. PRCTR Profit Center AFVC. PSPNR - Standard WBS element / Lookup on PRPS. POSID - Project Element (WBS) External ID PRPS. PSPHI - Project ID / Lookup on PROJ. PSPID - Project External ID NVARCSTR 10 0 0 no 60 PROJ_ELEM_ID PK NVARCSTR 24 0 0 no 61 PROJ_ID PK NVARCSTR 24 0 0 no 62 PURCH_DOC_ID AFVC. EBELN - Purchasing document number NVARCSTR 10 0 0 yes 63 PURCH_GRP_ID PK AFVC. EKGRP Purchasing group NVARCSTR 3 0 0 no 64 PURCH_LINE_ITEM_I D AFVC. EBELP - Item number of purchasing document NVARCSTR 5 0 0 yes 65 PURCH_ORG_ID PK AFVC. EKORG - Purchasing organization NVARCSTR 4 0 0 no 66 QTY_DURTN AFVV. DAUNO - Normal duration of the activity DECIMAL 48 5 1 yes 67 QTY_WORK_ACTL AFVV-ISMNW - Actual work DECIMAL 48 13 3 yes 68 QTY_WORK_FCST AFVV-ORMNW - Forecasted work (actual + remaining) DECIMAL 48 7 1 yes 69 QTY_WORK_SCHED AFVV-ARBEI - Work involved in the activity JEST-STAT (lookup) - REL operation is released status is active (1 is active, 0 is inactive) DECIMAL 48 7 1 yes 70 RELEASE_FLAG INTEGER 4 0 0 yes Rapid Mart Data Schema 125 Appendix Table Column Details A 71 REQUISITN_DOC_ID AFVC. BANFN Purchase requisition number NVARCSTR 10 0 0 yes 72 REQUISITN_LINE_ITE M_ID AFVC. BNFPO - Item number of the purchase requisition in the order AFKO. RSNUM -Number of reservation/dependent requirements NVARCSTR 5 0 0 yes 73 RESERVATN_ID PK NVARCSTR 10 0 0 yes 74 RESOURCE_ID KBED. ARBID - Resource (Work center) ID NVARCSTR 8 0 0 yes 75 ROUTING_ID PK Concatenated PLKO. PLNNR, PLNTY, PLNAL NVARCSTR 11 0 0 no 76 ROUTING_SEQ_ID AFVC. ZAEHL Internal counter AFVV. FSEDD - Earliest scheduled finish: Execution (date) + AFVV. FSEDZ - Earliest scheduled finish: Execution (time) AFVV. FSAVD - Earliest scheduled start: Execution (date) + AFVV. FSAVZ - Earliest scheduled start: Execution (time) PK AFVC. QUALF Suitability NVARCSTR 8 0 0 yes 77 SCHED_END_DATE DATETIME 24 0 9 yes 78 SCHED_START_DATE DATETIME 24 0 9 yes 79 SUITABILITY_ID NVARCSTR 2 0 0 no 80 SURROGATE_DOC_ID PK Alternate key generated in the Rapid Mart for reporting purposes DECIMAL 48 18 0 no 81 SYSTEM_CONDITN_I D TECHN_COMPLT_FLA G PK AFVC-ANLZU - System condition JEST-STAT (lookup) - TECO operation is technically completed status is active (1 is active, 0 is inactive) NVARCSTR 1 0 0 no 82 INTEGER 4 0 0 yes 83 UOM_ID_DURTN PK AFVV. DAUNE - Normal duration/unit NVARCSTR 3 0 0 no 84 UOM_ID_WORK PK AFVV-ARBEH - Unit for work NVARCSTR 3 0 0 no 85 VALUATN_AREA_ID PK T001. BWKEY Valuation Area Key NVARCSTR 4 0 0 no 86 VENDOR_ID PK AFVC. LIFNR - Account Number of Vendor or Creditor Lookup on CRHD. VERWE - Work center cat. [. . . ]