0% found this document useful (0 votes)
93 views5 pages

Vendor Master

The document provides a comprehensive overview of various tables related to vendor master data, material and purchasing information, purchase requisitions, purchase orders, services processing, invoice verification, and material documents within the S/4HANA system. Each table is listed with its name, purpose, and relevant logical databases. Additionally, it includes details about enterprise structure and customizing tables used for configuration in the system.

Uploaded by

Ganesh Chaudhary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
93 views5 pages

Vendor Master

The document provides a comprehensive overview of various tables related to vendor master data, material and purchasing information, purchase requisitions, purchase orders, services processing, invoice verification, and material documents within the S/4HANA system. Each table is listed with its name, purpose, and relevant logical databases. Additionally, it includes details about enterprise structure and customizing tables used for configuration in the system.

Uploaded by

Ganesh Chaudhary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Vendor master

S/4HANA -Table and general


Table Table - name
Notes

General financial services information


BP001 FS-Specific Attributes; Organization for the organisation-BP, eg for the
trading partner.

Field TYPE for the Business Partner


category: 1 = Person, 2 = Organization,
BUT000 Business Partner: General data I
3 = Group. In Logical Database REBP
UKM_BUPA.

BUT020 Business Partner: Addresses In Logical Database REBP.

BUT100 Business Partner: Roles In Logical Database REBP.

Assignment Between Vendor and Linked to table BUT000 via the field
CVI_VEND_LINK
Business Partner Partner_GUID.

IBPSUPPLIER View for the supplier - business partner Only available in S/4.

Also transaction S_ALR_87012086. In


LFA1 Vendor Master (General Section)
Logical Database BRF KDF WTY.

LFAT Vendor master record (tax groupings)

LFB1 Vendor Master (Company Code) In Logical Database BRF KDF.

LFB5 Vendor master (dunning data)

LFBK Vendor Master (Bank Details) In Logical Database BRF KDF.

Total postings/sales per


LFC1 Vendor master (transaction figures)
CompanyCode/supplier/year.

Vendor master record purchasing


LFM1
organization data

LFM2 Vendor Master Record: Purchasing Data

LFMH Vendor hierarchy

LFZA Permitted Alternative Payee

WYT3 Partner Functions

Material- and Purchasing info record


Table Table - name S/4HANA -Table and general Notes

For items get the value in Condition record


A017 Material Info Record (Plant-Specific) number (KNUMH) and go to table KONP. In
Logical Database ILM.

EINA Purchasing Info Record: General Data In Logical Database IFM ILM.

Purchasing Info Record: Purchasing


EINE In Logical Database IFM ILM.
Organization Data
EIPA Order Price History: Info Record In Logical Database IFM ILM.

Purchase requisitions
Table Table - name S/4HANA -Table and general Notes

In Logical Database BAM BBM BKM EBM


EBAN Purchase Requisition
PSJ.

In Logical Database BAM BBM BKM EBM


EBKN Purchase Requisition Account Assignment
PSJ.

Purchase order
Table Table - name S/4HANA -Table and general Notes

For which contracts which purchase orders


EKAB Release Documentation
were released (with quantity and value).

obsolete as central address management is


EKAN
used

In Logical Database BRM EBM ECM EKM


EKBE History per Purchasing Document ELM EMM ENM ERM EWM MEPOLDB
PSJ.

History per Purchasing Document: Delivery


EKBZ In Logical Database ERM MEPOLDB.
Costs

EKES Supplier Confirmations In Logical Database ERM MEPOLDB.

In Logical Database EBM ECM EKM ELM


EKET Scheduling Agreement Schedule Lines EMM ENM ERM ESM EWM MEPOLDB
PSJ.

In Logical Database EBM ECM EKM ELM


EKKN Account Assignment in Purchasing Document
EMM ENM ERM EWM MEPOLDB PSJ.

In Logical Database BRM EBM ECM EKM


EKKO Purchasing Document Header ELM EMM ENM ERM ESM EWM
MEPOLDB PSJ.

EKPA Partner Roles in Purchasing

"Material Provided" Item in Purchasing


EKPB
Document

In Logical Database BRM EBM ECM EKM


EKPO Purchasing Document Item ELM EMM ENM ERM ESM EWM
MEPOLDB PSJ.

EKUB Index for Stock Transport Orders for Material In Logical Database ERM.

EORD Purchasing Source List

EQUK Quota File: Header

EQUP Quota File: Item

KONH Conditions (Header) In Logical Database ERM ILM V12L.


KONP Conditions (Item) In Logical Database ERM ILM V12L.

Services processing
Table Table - name S/4HANA -Table and general Notes

Account Assignment Specification: Service


ESKL
Line

ESKN Account Assignment in Service Package In Logical Database ERM.

ESLH Service Package Header Data

ESLL Lines of Service Package

ESSR Service Entry Sheet Header Data In Logical Database ERM.

Ext. Services Management: Unplanned Limits


ESUC
on Contract Item

Ext. Services Management: Unpl. Service


ESUH
Limits: Header Data

Ext. Services Management: Unpl. Limits on


ESUP
Service Package

Services Management: Unplanned Limits on


ESUS
Service Types

Invoice Verification
S/4HANA -Table and general
Table Table - name
Notes

Program RKANBU01 to create


COOI Commitments Management: Line Items commitments for purchase requisitions
and purchase orders.

Document Item, Incoming Invoice,


RBCO
Account Assignment

RBDIFFKO Invoice Verification - Conditions

Batch Invoice Verification - Quantity


RBDIFFME
Differences

RBDRSEG Batch IV: Invoice Document Items

RBEX Persistent Key Figures Header and Item

RBKP Document Header: Invoice Receipt

Logistics Invoice Verification: Blocked


RBKP_BLOCKED
Invoices

Invoice Document Header (Batch


RBKPB
Invoice Verification)

RBTX Taxes: Incoming Invoice


RBVD Invoice Document - Aggregation Data

Invoice Verification - Aggregation Data,


RBVDMAT
Material

Withholding Tax Data, Incoming


RBWS
Invoice

Withholding Tax Data, Incoming


RBWT
Invoice

RSEG Document Item: Incoming Invoice

Material documents

Table Table - name S/4HANA -Table and general Notes

In Logical Database BMM LMM LNM MRM


MKPF Header: Material Document
PGQ.

In Logical Database BMM L1M LMM LNM


MSEG Document Segment: Material
MRM PGQ.

New Material documents - tables in S/4


Table Table - name S/4HANA -Table and general Notes

MLDOC Material Ledger Document

Material Ledger Document Cost


MLDOCCCS
Component Split

Enterprise Structure Part of the Customizing. To go to the IMG customizing entry, enter
the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o
Specifying Project'.
Table Table - name S/4HANA -Table and general Notes

T001K Valuation area

T001L Storage Locations

T001W Plants/Branches

T024 Purchasing Groups

T024E Purchasing Organizations

T024W Valid Purchasing Organizations for Plant

T024Z Purchasing Organizations

T499S Location

TSPA Organizational Unit: Sales Divisions


Customizing - Tables To go to the IMG customizing entry, enter the table name in
transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
Table Table - name S/4HANA -Table and general Notes

In table T003 is the number of the number


T003 Document Types for Finance
range. Edit with transaction OBA7.

T023 Material Groups

T052 Terms of Payment

T161 Purchasing Document Types

Linkage of Requisition Doc. Type to


T161A
Purchasing Document Type

Check of Document Type, Document


T161P
Category, Item Category

T161T Texts for Purchasing Document Types

You might also like