Detailed instructions for use are in the User's Guide.
[. . . ] 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. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
Trademarks
All rights reserved. [. . . ] Customer by Company Intersection of Company and Customer records. Used by both Customer Items and Customer Totals
DOCUMENT ATTRIBUTES
Master data associated with the various "documents" found in SAP solutions. These include Document Categories, Document Types, and separate class groupings for Accounting Documents, Sales Documents and Purchasing Documents. Document Attributes subclasses include: Document Category Document Category combines all document categories in one table, including: Financial, Internal Order, Notification, Purchasing, and Sales. The following document category aliases are also included as classes under DOCUMENT ATTRIBUTES:
· ·
Accounting Document Category - Domain DOCCT in SAP solutions. Internal Order Document Category - A technical classification criterion for orders. The order category determines the SAP application to which an order belongs, and controls the functions by which an order can be processed. Notification Document Category - A key that identifies notification types in an application component. Notification categories include: - Quality notification in the Quality Management (QM) application component - Maintenance notification in the Plant Maintenance (PM) application component - Service notification in the Customer Service (CS) application component
·
SAP BusinessObjects Production Planning Rapid Mart XI 3. 2 for SAP solutions User Guide
289
5
Universe SAP Master Data Universe
· ·
Purchase Document Category - Broadly categorizes purchase documents as "requisitions", "purchase orders", "contracts" etc. Sales Document Category - One of a set of classes used to control how the system processes a sales document in the sales and distribution component module. Sales document categories include: - Inquiries and quotations - Sales orders - Outline agreements
Document Type Document Type combines all document categories in one table, including: Internal Order, Sales, Purchasing, Billing, Delivery, Financial, Special Ledger, and Notification document types. The following document type aliases are also included in the SAP Master Data universe:
· · · ·
Billing Document Type - indicates type of billing document Delivery Document Type - indicates type of delivery document Financial Document Type - Records what the posting was for. Examples: Goods Issue, Goods Receipt, Asset posting, Vendor Payment, Customer Payment Internal Order Document Type - A tool that categorizes orders according to purpose. The order type contains information which is necessary for managing orders. 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. An example is consignment stock from vendors. Standard Text Key Standard text Key descriptions for activities from T435T. Standard Value Key Capacity Standard Value Key descriptive attributes from TC21T. [. . . ] 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. [. . . ]