MMPUR_MASSAPLJOB
Mass Changes to Purchasing Doc:Application Job Details
MMPUR_MASSAPLJOB is an SAP database table in S/4HANA. Mass Changes to Purchasing Doc:Application Job Details. It contains 26 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PurchasingDocSimulationJob | view | from | BASIC | Purchase Document Simulation Job |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | id | guid_16 | GUID 16 | |||
| KEY | procurementhubsourcesystem | mmpur_d_source_sys | Connected System ID | |||
| jobname | btcjob | Job Name | ||||
| jobcount | btcjobcnt | Job No. | ||||
| loghandle | balloghndl | Handle | ||||
| plndstrtdt | btcsdate | Start Date | ||||
| plndstrttm | btcstime | Start Time | ||||
| status | btcstatus | Job status | ||||
| jobdesc | balnrext | External ID | ||||
| createdby | btcjchnm | Last job change by | ||||
| timestamp | sc_string | Find | ||||
| lognumber | balognr | Log Number | ||||
| doccategory | bstyp | Doc. Category | ||||
| docsubtype | bsakz | Control | ||||
| issimulationjob | mm_pur_job_simulated | Is Simulated Job | ||||
| actualrunjobname | btcjob | Job Name | ||||
| job_template_name | mm_pur_job_template_name | Job Template Name | ||||
| job_template_version | mm_pur_job_template_ver | Job Template Name | ||||
| numberofuniqueerrors | mm_pur_error_count | Unique Error Count | ||||
| numberofuniquewarnings | mm_pur_warning_count | Unique Warning Count | ||||
| numberofuniqueinfosuccessmsgs | mm_pur_success_count | Unique Success Info | ||||
| numberoferrormsgdocuments | mm_pur_doc_error_count | Document Error Count | ||||
| numberofwarningmsgdocuments | mm_pur_doc_warning_count | Doc Warning Count | ||||
| numberofinfosuccessmsgdocs | mm_pur_doc_success_count | Doc Success Info | ||||
| isexcelupload | excel_upload | Is Excel Upload |
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.
-- Mass Changes to Purchasing Doc:Application Job Details
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_MASSAPLJOB (
MANDT, -- Client [mandt]
ID, -- GUID 16 [guid_16]
PROCUREMENTHUBSOURCESYSTEM, -- Connected System ID [mmpur_d_source_sys]
JOBNAME, -- Job Name [btcjob]
JOBCOUNT, -- Job No. [btcjobcnt]
LOGHANDLE, -- Handle [balloghndl]
PLNDSTRTDT, -- Start Date [btcsdate]
PLNDSTRTTM, -- Start Time [btcstime]
STATUS, -- Job status [btcstatus]
JOBDESC, -- External ID [balnrext]
CREATEDBY, -- Last job change by [btcjchnm]
TIMESTAMP, -- Find [sc_string]
LOGNUMBER, -- Log Number [balognr]
DOCCATEGORY, -- Doc. Category [bstyp]
DOCSUBTYPE, -- Control [bsakz]
ISSIMULATIONJOB, -- Is Simulated Job [mm_pur_job_simulated]
ACTUALRUNJOBNAME, -- Job Name [btcjob]
JOB_TEMPLATE_NAME, -- Job Template Name [mm_pur_job_template_name]
JOB_TEMPLATE_VERSION, -- Job Template Name [mm_pur_job_template_ver]
NUMBEROFUNIQUEERRORS, -- Unique Error Count [mm_pur_error_count]
NUMBEROFUNIQUEWARNINGS, -- Unique Warning Count [mm_pur_warning_count]
NUMBEROFUNIQUEINFOSUCCESSMSGS, -- Unique Success Info [mm_pur_success_count]
NUMBEROFERRORMSGDOCUMENTS, -- Document Error Count [mm_pur_doc_error_count]
NUMBEROFWARNINGMSGDOCUMENTS, -- Doc Warning Count [mm_pur_doc_warning_count]
NUMBEROFINFOSUCCESSMSGDOCS, -- Doc Success Info [mm_pur_doc_success_count]
ISEXCELUPLOAD, -- Is Excel Upload [excel_upload]
PRIMARY KEY (MANDT, ID, PROCUREMENTHUBSOURCESYSTEM)
);
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