FINOC_IMP_MAT
Orgl Change: Upload Preview for Products
FINOC_IMP_MAT is an SAP database table in S/4HANA. Orgl Change: Upload Preview for Products. It contains 18 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_OrglChgProdUploadPreview | view_entity | from | BASIC | Uploaded Products |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | orgl_change | FINOC_ORGL_CHANGE | Organizational Change | |||
| KEY | imported_by | FINOC_IMPORTED_BY | Uploaded By | |||
| KEY | file_row_number | FINOC_FILE_ROW_NUMBER | Row No. in File | |||
| KEY | draftuuid | SDRAFT_UUID | Draft Document ID | |||
| matnr | MATNR | Material | ||||
| werks | WERKS_D | Plant | ||||
| kokrs | KOKRS | CO Area | ||||
| prctr | FINOC_PRCTR_BEFORE_ORGL_CHANGE | Old Profit Center | ||||
| prctr_new | FINOC_PRCTR_NEW | New Profit Center | ||||
| msg_type | FINOC_MESSAGE_TYPE | Message Type | ||||
| msg_id | SYMSGID | Message Class | ||||
| msg_number | MSGNR | Message | ||||
| msg_v1 | MSGV1 | Message var. | ||||
| msg_v2 | MSGV2 | Message var. | ||||
| msg_v3 | MSGV3 | Message var. | ||||
| msg_v4 | MSGV4 | Message var. | ||||
| msg_text | BAPI_MSG | Message Text |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Orgl Change: Upload Preview for Products
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_IMP_MAT (
MANDT, -- Client [MANDT]
ORGL_CHANGE, -- Organizational Change [FINOC_ORGL_CHANGE]
IMPORTED_BY, -- Uploaded By [FINOC_IMPORTED_BY]
FILE_ROW_NUMBER, -- Row No. in File [FINOC_FILE_ROW_NUMBER]
DRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
KOKRS, -- CO Area [KOKRS]
PRCTR, -- Old Profit Center [FINOC_PRCTR_BEFORE_ORGL_CHANGE]
PRCTR_NEW, -- New Profit Center [FINOC_PRCTR_NEW]
MSG_TYPE, -- Message Type [FINOC_MESSAGE_TYPE]
MSG_ID, -- Message Class [SYMSGID]
MSG_NUMBER, -- Message [MSGNR]
MSG_V1, -- Message var. [MSGV1]
MSG_V2, -- Message var. [MSGV2]
MSG_V3, -- Message var. [MSGV3]
MSG_V4, -- Message var. [MSGV4]
MSG_TEXT, -- Message Text [BAPI_MSG]
PRIMARY KEY (MANDT, ORGL_CHANGE, IMPORTED_BY, FILE_ROW_NUMBER, DRAFTUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA