0VEN_PURORG_ATTR

Vendor Number | #ATTR | Extraction method: F1 | Delta: E | Component: Logistics Master Data

Tables used: LFM1, KNVV, MARC, MVKE, KNB1 ... +11 more

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical (18)
Other (13)
🔗 Relations (17)

Column Name	Description
LIFNR FK	Vendor's account number
EKORG FK	Purchasing organization

Column Name	Description
💲 Purchase order currency (WAERS):
MINBW	Minimum order value

Column Name	Description

Column Name	Description
ERDAT	Date on which the record was created

Column Name	Description
SPERM	Purchasing block at purchasing organization level	Show values
LOEVM	Deletion Indicator for Supplier at Purchasing Level	Show values
WEBRE	Indicator: GR-Based Invoice Verification	Show values
KZABS	Order Acknowledgment Requirement	Show values
KZAUT	Automatic Generation of Purchase Order Allowed	Show values
MEPRF	Price Determination (Pricing) Date Control	Show values
BOLRE	Indicator: supplier subject to subseq. settlement accounting	Show values
UMSAE	Comparison/agreement of business volumes necessary	Show values
XERSY	Evaluated Receipt Settlement (ERS)	Show values
PRFRE	Indicator: "relev. to price determination (vend. hierarchy)	Show values
BOIND	Indicator: index compilation for subseq. settlement active	Show values
BLIND	Indicator: Doc. index compilation active for purchase orders	Show values
KZRET	Indicates whether supplier is returns supplier	Show values
SKRIT	Supplier sort criterion for materials	Show values
XERSR	Automatic evaluated receipt settlement for return items	Show values
AGREL	Indicator: Relevant for Settlement Management	Show values
XNBWY	Revaluation allowed	Show values
LEBRE	Indicator for Service-Based Invoice Verification	Show values

Column Name	Description	Domain name
ERNAM	Name of Person Responsible for Creating the Object	USNAM
LFABC	ABC indicator	LFABC
VERKF	Responsible Salesperson at Supplier's Office	TEXT30
TELF1	Supplier's Telephone Number	TEXT16
ZTERM	Terms of payment key	ZTERM
INCO2	Incoterms (Part 2)	INCO2
PLIFZ	Planned Delivery Time in Days	DEC3
LIBES	Order entry by supplier	CHAR1
LISER	Rack-jobbing: supplier	CHAR1
NRGEW	Indicator whether discount in kind granted	NRGEW
VENSL	Supplier Service Level	DEC3_1
EIKTO	Our account number with the supplier	CHAR12
ABUEB	Release Creation Profile	ABUEB

Master Data Relations \| to Other Relations ↓	Join Conditions
Confirmation Control Key Client Confirmation Control Key	`0VEN_PURORG_ATTR.MANDT == T163L.MANDT` `0VEN_PURORG_ATTR.BSTAE == T163L.BSTAE`
Purchasing Group Client Purchasing Group	`0VEN_PURORG_ATTR.MANDT == T024.MANDT` `0VEN_PURORG_ATTR.EKGRP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`0VEN_PURORG_ATTR.MANDT == T024E.MANDT` `0VEN_PURORG_ATTR.EKORG == T024E.EKORG`
Mode of Transport at the Border (Intrastat) ? Client Mode of Transport at the Border (Intrastat)	`0VEN_PURORG_ATTR.[column in domain "/ECRS/RPCTY"] == T618.LAND1` `0VEN_PURORG_ATTR.MANDT == T618.MANDT` `0VEN_PURORG_ATTR.EXPVZ == T618.EXPVZ`
Incoterms (Part 1) Client Incoterms (Part 1)	`0VEN_PURORG_ATTR.MANDT == TINC.MANDT` `0VEN_PURORG_ATTR.INCO1 == TINC.INCO1`
Group for Calculation Schema (Supplier) Client Group for Calculation Schema (Supplier)	`0VEN_PURORG_ATTR.MANDT == TMKK.MANDT` `0VEN_PURORG_ATTR.KALSK == TMKK.KALSK`
Planning Cycle Client ? Planning Cycle	`0VEN_PURORG_ATTR.MANDT == T439G.MANDT` `0VEN_PURORG_ATTR.[column in domain "WERKS_D"] == T439G.WERKS` `0VEN_PURORG_ATTR.LFRHY == T439G.MRPPP`
Vendor's account number Client Vendor's account number	`0VEN_PURORG_ATTR.MANDT == LFA1.MANDT` `0VEN_PURORG_ATTR.LIFNR == LFA1.LIFNR`
Price marking, supplier Client Price marking, supplier	`0VEN_PURORG_ATTR.MANDT == TWYAZ.MANDT` `0VEN_PURORG_ATTR.LIPRE == TWYAZ.LIPRE`
Planning Calendar Client ? Planning Calendar	`0VEN_PURORG_ATTR.MANDT == T439G.MANDT` `0VEN_PURORG_ATTR.[column in domain "WERKS_D"] == T439G.WERKS` `0VEN_PURORG_ATTR.MRPPP == T439G.MRPPP`
Foreign key profile for transfer Client Profile for transferring material data via IDoc PROACT	`0VEN_PURORG_ATTR.MANDT == TWVMO.MANDT` `0VEN_PURORG_ATTR.PAPRF == TWVMO.PAPRF`
Rounding profile Client ? ? Rounding Profile	`0VEN_PURORG_ATTR.MANDT == RDPR.MANDT` `0VEN_PURORG_ATTR.[column in domain "RDZAE"] == RDPR.RDZAE` `0VEN_PURORG_ATTR.[column in domain "WERKS_D"] == RDPR.WERKS` `0VEN_PURORG_ATTR.RDPRF == RDPR.RDPRF`
Shipping conditions Client Shipping Conditions	`0VEN_PURORG_ATTR.MANDT == TVSB.MANDT` `0VEN_PURORG_ATTR.VSBED == TVSB.VSBED`
Purchase order currency Client Purchase order currency	`0VEN_PURORG_ATTR.MANDT == TCURC.MANDT` `0VEN_PURORG_ATTR.WAERS == TCURC.WAERS`
Customs Office: Office of Exit/Entry for Foreign Trade ? Client Customs Office: Office of Exit/Entry for Foreign Trade	`0VEN_PURORG_ATTR.[column in domain "LAND1"] == T615.LAND1` `0VEN_PURORG_ATTR.MANDT == T615.MANDT` `0VEN_PURORG_ATTR.ZOLLA == T615.ZOLLA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Restriction table ? ? Client Restriction Profile for PO-Based Load Building	`0VEN_PURORG_ATTR.[column in domain "BORESTRI"] == TWBO1.BORESTRI` `0VEN_PURORG_ATTR.[column in domain "BOTYPI"] == TWBO1.BOTYPI` `0VEN_PURORG_ATTR.MANDT == TWBO1.MANDT` `0VEN_PURORG_ATTR.BOPNR == TWBO1.BOPNR`
Units of measure group Client ? Unit of Measure Group	`0VEN_PURORG_ATTR.MANDT == TWMEG.MANDT` `0VEN_PURORG_ATTR.[column in domain "LRMEI"] == TWMEG.MEINS` `0VEN_PURORG_ATTR.MEGRU == TWMEG.MEGRU`