SAP Table WPLFM1
Extended LFM1 structure (planned changes)
WPLFM1 (Extended LFM1 structure (planned changes)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WPLFM1 to other SAP tables.
WPLFM1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DATUM | POS interface: date | WJDPOSDAT | DATS | 8 | 0 | |||||||||||||||
| UTIME | Time of Last Change | UTIME | TIMS | 6 | 0 | |||||||||||||||
| AENNR | Change Number | AENNR | CHAR | 12 | 0 | |||||||||||||||
| CHGFLAG | POS interface: flag for certain field changes | WJDPOSFLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||||||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||
| SPERM | Purchasing block at purchasing organization level | SPERM_M | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LOEVM | Delete flag for vendor at purchasing level | LOEVM_M | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LFABC | ABC indicator | LFABC | CHAR | 1 | 0 | |||||||||||||||
| WAERS | Purchase order currency | BSTWA | TCURC | CUKY | 5 | 0 | ||||||||||||||
| VERKF | Responsible Salesperson at Vendor's Office | EVERK | CHAR | 30 | 0 | |||||||||||||||
| TELF1 | Vendor's telephone number | TELFE | CHAR | 16 | 0 | |||||||||||||||
| MINBW | Minimum order value | MINBW | CURR | 13 | 2 | |||||||||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||||||||
| INCO1 | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 | 0 | ||||||||||||||
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | 0 | |||||||||||||||
| WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KALSK | Group for Calculation Schema (Vendor) | KALSK | TMKK | CHAR | 2 | 0 | ||||||||||||||
| KZAUT | Automatic Generation of Purchase Order Allowed | KZAUT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EXPVZ | Mode of Transport for Foreign Trade | EXPVZ | T618 | CHAR | 1 | 0 | ||||||||||||||
| ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | T615 | CHAR | 6 | 0 | ||||||||||||||
| MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||||||||||
| XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | 0 | |||||||||||||||
| MRPPP | Planning calendar | MRPPP_W | T439G | CHAR | 3 | 0 | ||||||||||||||
| LFRHY | Planning cycle | LFRHY | T439G | CHAR | 3 | 0 | ||||||||||||||
| LIBES | Order entry by vendor | LIBES | CHAR | 1 | 0 | |||||||||||||||
| LIPRE | Price marking, vendor | LIPRE | TWYAZ | CHAR | 2 | 0 | ||||||||||||||
| LISER | Rack-jobbing: vendor | LISER | CHAR | 1 | 0 | |||||||||||||||
| PRFRE | Indicator: "relev. to price determination (vend. hierarchy) | PRFRE_LH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| NRGEW | Indicator whether discount in kind granted | NRGEW | CHAR | 1 | 0 | |||||||||||||||
| BOIND | Indicator: index compilation for subseq. settlement active | BOIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BLIND | Indicator: Doc. index compilation active for purchase orders | BLIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KZRET | Indicates whether vendor is returns vendor | KZRET | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| SKRIT | Vendor sort criterion for materials | SKRIT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BSTAE | Confirmation Control Key | BSTAE | T163L | CHAR | 4 | 0 | ||||||||||||||
| RDPRF | Rounding Profile | RDPRF | RDPR | CHAR | 4 | 0 | ||||||||||||||
| MEGRU | Unit of Measure Group | MEGRU | TWMEG | CHAR | 4 | 0 | ||||||||||||||
| VENSL | Vendor service level | VENSL | DEC | 4 | 1 | |||||||||||||||
| BOPNR | Restriction Profile for PO-Based Load Building | BOPNR | TWBO1 | CHAR | 4 | 0 | ||||||||||||||
| XERSR | Automatic evaluated receipt settlement for return items | XERSR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EIKTO | Our account number with the vendor | EIKTO_M | CHAR | 12 | 0 | |||||||||||||||
| ABUEB | Release Creation Profile | ABUEB | CHAR | 4 | 0 | |||||||||||||||
| PAPRF | Profile for transferring material data via IDoc PROACT | WVMI_PAPRF | TWVMO | CHAR | 4 | 0 | ||||||||||||||
| AGREL | Indicator: Relevant for agency business | AGREL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| XNBWY | Revaluation allowed | XNBWY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 | 0 | ||||||||||||||
| LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BOLRE | Indicator: vendor subject to subseq. settlement accounting | BOLRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| UMSAE | Comparison/agreement of business volumes necessary | UMSAE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| VENDOR_RMA_REQ | Vendor RMA Number Required | MSR_VRMA_REQ_LFM1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | OIH5 | CHAR | 2 | 0 | ||||||||||||||
| OIA_SPLTIV | Indicator for split invoice verification | OIA_SPLTIV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| OIHVGROUP | Vendor group (refinery/mill/other) | OIH_J1B_VTXGR | OIH2V_J1B | CHAR | 4 | 0 | ||||||||||||||
| OIMATCYC | Invoice cycle | OIA_INVCYC | NUMC | 1 | 0 | |||||||||||||||
| ACTIVITY_PROFIL | Activity Profile for PO Controlling | WRF_PCTR_ACT_PROF | WRFT_ACT_PROF | CHAR | 4 | 0 | ||||||||||||||
| TRANSPORT_CHAIN | Transportation Chain | WRF_PSCD_TC_ID | WRF_PSCD_TCHAINH | CHAR | 10 | 0 | ||||||||||||||
| STAGING_TIME | Staging Time in Days | WRF_PSCD_MST | DEC | 3 | 0 | |||||||||||||||
WPLFM1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WPLFM1 | ACTIVITY_PROFIL | SYST | MANDT | WRFT_ACT_PROF | Activity Profile | MANDT |
| WPLFM1 | ACTIVITY_PROFIL | WPLFM1 | ACTIVITY_PROFIL | WRFT_ACT_PROF | Activity Profile | ACT_PROF |
| WPLFM1 | BOPNR | * | TWBO1 | Customizing table for opt. PO-based load building profiles | BORESTRI | |
| WPLFM1 | BOPNR | * | TWBO1 | Customizing table for opt. PO-based load building profiles | BOTYPI | |
| WPLFM1 | BOPNR | WPLFM1 | MANDT | TWBO1 | Customizing table for opt. PO-based load building profiles | MANDT |
| WPLFM1 | BOPNR | WPLFM1 | BOPNR | TWBO1 | Customizing table for opt. PO-based load building profiles | BOPNR |
| WPLFM1 | BSTAE | WPLFM1 | MANDT | T163L | Confirmation Control Keys | MANDT |
| WPLFM1 | BSTAE | WPLFM1 | BSTAE | T163L | Confirmation Control Keys | BSTAE |
| WPLFM1 | EKGRP | WPLFM1 | EKGRP | T024 | Purchasing Groups | EKGRP |
| WPLFM1 | EKGRP | SYST | MANDT | T024 | Purchasing Groups | MANDT |
| WPLFM1 | EKORG | WPLFM1 | MANDT | T024E | Purchasing Organizations | MANDT |
| WPLFM1 | EKORG | WPLFM1 | EKORG | T024E | Purchasing Organizations | EKORG |
| WPLFM1 | EXPVZ | WPLFM1 | EXPVZ | T618 | Foreign Trade: Modes of Transport | EXPVZ |
| WPLFM1 | EXPVZ | SYST | MANDT | T618 | Foreign Trade: Modes of Transport | MANDT |
| WPLFM1 | EXPVZ | *T001 | LAND1 | T618 | Foreign Trade: Modes of Transport | LAND1 |
| WPLFM1 | INCO1 | SYST | MANDT | TINC | Customers: Incoterms | MANDT |
| WPLFM1 | INCO1 | WPLFM1 | INCO1 | TINC | Customers: Incoterms | INCO1 |
| WPLFM1 | KALSK | WPLFM1 | KALSK | TMKK | Group for Calculation Schema (Vendor) | KALSK |
| WPLFM1 | KALSK | SYST | MANDT | TMKK | Group for Calculation Schema (Vendor) | MANDT |
| WPLFM1 | LFRHY | LFM2 | WERKS | T439G | PPplanning periods: header table | WERKS |
| WPLFM1 | LFRHY | WPLFM1 | LFRHY | T439G | PPplanning periods: header table | MRPPP |
| WPLFM1 | LFRHY | SYST | MANDT | T439G | PPplanning periods: header table | MANDT |
| WPLFM1 | LIFNR | WPLFM1 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| WPLFM1 | LIFNR | WPLFM1 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| WPLFM1 | LIPRE | SYST | MANDT | TWYAZ | Price Marking Agreement | MANDT |
| WPLFM1 | LIPRE | WPLFM1 | LIPRE | TWYAZ | Price Marking Agreement | LIPRE |
| WPLFM1 | MANDT | WPLFM1 | MANDT | T000 | Clients | MANDT |
| WPLFM1 | MEGRU | WPLFM1 | MANDT | TWMEG | Unit of measure group | MANDT |
| WPLFM1 | MEGRU | WPLFM1 | MEGRU | TWMEG | Unit of measure group | MEGRU |
| WPLFM1 | MEGRU | * | TWMEG | Unit of measure group | MEINS | |
| WPLFM1 | MRPPP | SYST | MANDT | T439G | PPplanning periods: header table | MANDT |
| WPLFM1 | MRPPP | LFM2 | WERKS | T439G | PPplanning periods: header table | WERKS |
| WPLFM1 | MRPPP | WPLFM1 | MRPPP | T439G | PPplanning periods: header table | MRPPP |
| WPLFM1 | OIHANTYP | WPLFM1 | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
| WPLFM1 | OIHANTYP | WPLFM1 | OIHANTYP | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
| WPLFM1 | OIHVGROUP | SYST | MANDT | OIH2V_J1B | Check table for vendor tax group | MANDT |
| WPLFM1 | OIHVGROUP | WPLFM1 | OIHVGROUP | OIH2V_J1B | Check table for vendor tax group | OIHVTXGR |
| WPLFM1 | PAPRF | WPLFM1 | MANDT | TWVMO | Control profiles for transferring material data to vendor | MANDT |
| WPLFM1 | PAPRF | WPLFM1 | PAPRF | TWVMO | Control profiles for transferring material data to vendor | PAPRF |
| WPLFM1 | RDPRF | * | RDPR | Rounding profile | WERKS | |
| WPLFM1 | RDPRF | WPLFM1 | RDPRF | RDPR | Rounding profile | RDPRF |
| WPLFM1 | RDPRF | * | RDPR | Rounding profile | RDZAE | |
| WPLFM1 | RDPRF | WPLFM1 | MANDT | RDPR | Rounding profile | MANDT |
| WPLFM1 | TRANSPORT_CHAIN | SYST | MANDT | WRF_PSCD_TCHAINH | Transportation Chain, Header | MANDT |
| WPLFM1 | TRANSPORT_CHAIN | WPLFM1 | TRANSPORT_CHAIN | WRF_PSCD_TCHAINH | Transportation Chain, Header | TC_ID |
| WPLFM1 | TRANSPORT_CHAIN | * | WRF_PSCD_TCHAINH | Transportation Chain, Header | TC_MODE | |
| WPLFM1 | VSBED | WPLFM1 | MANDT | TVSB | Shipping Conditions | MANDT |
| WPLFM1 | VSBED | WPLFM1 | VSBED | TVSB | Shipping Conditions | VSBED |
| WPLFM1 | WAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
| WPLFM1 | WAERS | WPLFM1 | WAERS | TCURC | Currency Codes | WAERS |
| WPLFM1 | ZOLLA | SYST | MANDT | T615 | Foreign Trade: Customs Offices | MANDT |
| WPLFM1 | ZOLLA | *T001 | LAND1 | T615 | Foreign Trade: Customs Offices | LAND1 |
| WPLFM1 | ZOLLA | WPLFM1 | ZOLLA | T615 | Foreign Trade: Customs Offices | ZOLLA |
