Sqvi settings for exporting some primary data in PP

Source: Internet
Author: User

PPExport some primary dataSqviSet

I,PPSome primary data generally includes:

Generally,PPThe primary data includes the following three items:

1. Material master dataPPSome views;

2. BOMData;

3. RoutingData.

In some cases, the production version may also be included.

II,Material master dataPPPartial export settings:

Table:

Marc-Material Factory data

Makt-Material description

Association:Marc-matnr = Makt-matnr

If the material description has multiple languages, you may needMaktSpecified in

Select fields:

Item No.

Factory

Mark the materials to be deleted at the factory level

Shipping Unit

Requirement Plan type

MRPController (material Scheduler)

Factory production time (self-made production time)

Planned delivery days

Batch (material plan)

Procurement type

Special procurement type

Minimum batch

Round value of a purchase order in batches

ID of independent and centralized requirements

ComprehensiveMRPIdentifier

Floating plan margin code

Reversed logo

Profit Center

Part waste percentage

Plan A Policy Group

Consumption mode

Consumption Period-Reverse

Consumption Period-Forward

Period identifier

Safety Stock

Default external warehouse location

Production and distribution inventory location (for reverse-rush materials, more is set inBOMMedium)

Inspection Team for availability check

Material description

III,BOMExport settings:

Tables:

MAST-BOMLink Material

STKO-BOMHeader

STAS-BOMItem Selection

STOP-BOMProject

Makt-Material description

Table Association:

MAST-STLNR = STKO-STLNR

MAST-STLAL = STKO-STLAL

STKO-STLTY = STAS-STLTY

STKO-STLNR = STAS-STLNR

STKO-STLAL = STAS-STLAL

STAS-STLTY = STPO-STLTY

STAS-STLNR = STPO-STLNR

STAS-STLKN = STPO-STLKN

STPO-IDNRK = MAKT-MATNR

MAST-MATNR = MAKT-MATNR

Select fields:

Mast:

Item No.

Factory

BOMPurpose

OptionalBOM

Stko:

Delete ID

Basic quantity

Stas:

Delete an ID (this is generally used to delete an ID)

StPO:

Delete ID

BOMComponents

Project category

BOMProject No.

Component measurement unit

Component quantity

Part waste percentage

Process waste

Indicator-Alternative Project

Usage possibilities% (Optional items)

Makt:

Material description

IV,RoutingData export settings:

Tables:

Mapl-Allocate task list to item

Plko-Task List Header

Plas-Task List process task selection

Plpo-Task list procedure/Job

Crhd-Work Center Header

Makt-Material description

Table Association:

MAPL-PLNTY = PLKO-PLNTY

MAPL-PLNNR = PLKO-PLNNR

MAPL-PLNAL = PLKO-PLNAL

PLKO-PLNTY = PLAS-PLNTY

PLKO-PLNNR = PLAS-PLNNR

PLKO-PLNAL = PLAS-PLNAL

PLAS-PLNTY = PLPO-PLNTY

PLAS-PLNNR = PLPO-PLNNR

PLAS-PLNKN = PLPO-PLNKN

PLPO-ARBID = CRHD-OBJID

MAPL-MATNR = MAKT-MATNR

Select fields:

Mapl:

Item No.

Factory

Task List type

Task List Group Code

Group counters

Delete ID

Makt::

Material description

Plko:

Task List usage

Status

From Batch

To batch

Task List description

Plpo:

Operation/Activity ID

Control Code

Standard text code

Process short text

Job/Measurement Unit of the process

Used to convert the process route and unit denominator

Counters used for conversion task list and process measurement unit

Basic quantity

Activity Type

Standard Value Unit

Standard Value

...

Requirements overlap

Optional overlapping

MARK: streamline production

Decomposition required

Maximum decomposition number

Crhd:

Work Center

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.