Data Warehouse

ACCOUNT_ASGMT_CHANGEABLE_IND

XXX

VARCHAR2

1

ACCOUNT_ASSIGNMENT_CATEGORY

XXX

VARCHAR2

1

ACCOUNT_DISTRIBUTION_IND

XXX

VARCHAR2

1

ADVANCED_PROCUREMENT_IND

XXX

VARCHAR2

1

AFFECTS_COMMITMENTS_IND

XXX

VARCHAR2

1

AGREEMENT_ITEM_NUMBER

XXX

NUMBER

5

AGREEMENT_NUMBER

XXX

VARCHAR2

10

ASSIGNED_SOURCE_IND

XXX

VARCHAR2

1

BATCH_NUMBER

XXX

VARCHAR2

10

BOM_EXPLOSION_NUMBER

XXX

VARCHAR2

8

COMMITMENT_ITEM

In SAP's FM module, expenses are classified by "commitment item", not G/L account. Each G/L account in SAP's CO module maps to a "commitment item" in the FM module. There are many fewer commitment items that G/L accounts. FM's commitment items represent a more summarized view of expense types.

VARCHAR2

14

COMMITTED_DATE

XXX

DATE

COMMITTED_QUANTITY

XXX

NUMBER

13,3

CONFIGURATION

XXX

VARCHAR2

18

CONFIG_ORIGIN

XXX

VARCHAR2

1

CONSUMPTION_POSTING_IND

XXX

VARCHAR2

1

CREATED_BY

User account or user name of the person who created the record.

VARCHAR2

12

CREATION_INDICATOR

XXX

VARCHAR2

1

CURRENCY

XXX

VARCHAR2

5

DATE_CHANGED

XXX

DATE

DELETION_INDICATOR

XXX

VARCHAR2

1

DELIVERY_DATE_CATEGORY

XXX

VARCHAR2

1

DESIRED_VENDOR

XXX

VARCHAR2

10

DOCUMENT_CATEGORY

XXX

VARCHAR2

1

DOCUMENT_TYPE

XXX

VARCHAR2

4

DOC_TYPE_CONTROL_IND

XXX

VARCHAR2

1

FIXED_VENDOR

XXX

VARCHAR2

10

FUND

XXX

VARCHAR2

10

FUNDS_CENTER

Source of revenue.

VARCHAR2

16

GENERAL_CONFIG_MATERIAL

XXX

VARCHAR2

18

GR_IND

XXX

VARCHAR2

1

GR_NONVALUED_IND

XXX

VARCHAR2

1

GR_PROCESSING_TIME

XXX

NUMBER

3

IR_IND

XXX

VARCHAR2

1

ITEM_CATEGORY

XXX

VARCHAR2

1

ITEM_DELIVERY_DATE

XXX

DATE

KANBAN_IND

XXX

VARCHAR2

1

LAST_RESUBMISSION_DATE

XXX

DATE

MATERIAL_CATEGORY

XXX

VARCHAR2

1

MATERIAL_GROUP

A code, usually four digit, defining a Material Group for Purchase Orders to enable reporting by Material Group categories. See also Material Group Description: this latter field gives the text name of the material group defined by the code.

VARCHAR2

9

MATERIAL_NUMBER_1

XXX

VARCHAR2

18

MATERIAL_NUMBER_2

XXX

VARCHAR2

18

MRP_CONTROLLER

XXX

VARCHAR2

3

NUMBER_OF_RESUBMISSIONS

XXX

VARCHAR2

8

ORDER_QUANTITY

XXX

NUMBER

13,3

ORDER_UNIT

XXX

VARCHAR2

3

PACKAGE_NUMBER

XXX

VARCHAR2

10

PARTIAL_INVOICE_IND

XXX

VARCHAR2

1

PLANT

The plant code associated with the PO line item.

VARCHAR2

4

PO_PRICE_IND

XXX

VARCHAR2

1

PRICE_UNIT

XXX

NUMBER

5

PROCESSING_STATUS

XXX

VARCHAR2

1

PROD_VERSION

XXX

VARCHAR2

4

PURCHASE_ORDER_DATE

XXX

DATE

PURCHASE_ORDER_ITEM_NUMBER

XXX

NUMBER

5

PURCHASE_ORDER_NUMBER

Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document.

VARCHAR2

10

PURCHASING_DOC_CATEGORY_2

XXX

VARCHAR2

1

PURCHASING_GROUP

Code identifying a Purchasing Group.

VARCHAR2

3

PURCHASING_INFO_RECORD_NUMBER

XXX

VARCHAR2

10

PURCHASING_ORG

Code identifying a Purchasing Organization.

VARCHAR2

4

QUOTA_ITEM_NUMBER

XXX

NUMBER

3

QUOTA_NUMBER

XXX

VARCHAR2

10

RELEASE_COMPLETE_IND

XXX

VARCHAR2

1

RELEASE_DATE

XXXX

DATE

RELEASE_GROUP

XXX

VARCHAR2

2

RELEASE_INDICATOR

XXX

VARCHAR2

1

RELEASE_STATUS

XXX

VARCHAR2

8

RELEASE_STRATEGY

XXX

VARCHAR2

2

REQUIREMENT_TRACKING_NUMBER

Entered on a Purchasing Requisition and copied to subsequent Purchase Orders. Enables grouping of Purchasing Documents by Material Requirement

VARCHAR2

10

REQUISITIONER

Person who originated a Purchase Requisition

VARCHAR2

20

REQUISITION_ITEM_NUMBER

XXX

NUMBER

5

REQUISITION_NUMBER

Purchase Requisition Document Number

VARCHAR2

10

REQ_CLOSED_IND

XXX

VARCHAR2

1

REQ_DATE

XXX

DATE

REQ_FIXED_IND

XXX

VARCHAR2

1

REQ_QUANTITY

XXX

NUMBER

13,3

REQ_UOM

XXX

VARCHAR2

10

RESERVATION_NUMBER

XXX

NUMBER

10

RESUBMISSION_INTERVAL

XXX

NUMBER

3

RETAIL_PROMOTION

XXX

VARCHAR2

10

REV_LEVEL

XXX

VARCHAR2

2

SETTLEMENT_RES_ITEM_NUMBER

XXX

NUMBER

4

SETTLEMENT_RES_NUMBER

XXX

VARCHAR2

10

SHORTAGE_QUANTITY

XXX

NUMBER

13,3

SHORT_TEXT

XXX

VARCHAR2

200

SPECIAL_STOCK_IND

XXX

VARCHAR2

1

SPECIAL_STOCK_TRANSFER_IND

XXX

VARCHAR2

1

STORAGE_LOCATION

XXX

VARCHAR2

4

SUPPLYING_PLANT

XXX

VARCHAR2

4

UNIT_PRICE

Cost associated with each piece counted in NUMBER_OF_UNITS, converted to USD. For Serial orders, this is always $.01. (Z68-UNIT-PRICE converted to USD)

NUMBER

11,2

VALUATION_TYPE

XXX

VARCHAR2

10

VENDOR_KEY

Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting.

VARCHAR2

11

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE