Posts

Customer, Material & Vendor Master Data Tables

Below are the list of important tables of Customer, Material and Vendor Master Data in SAP.

TableDescriptionTable Category
KNA1General Data in Customer MasterCUSTOMER MASTER
KNB1Customer Master (Company Code)CUSTOMER MASTER
KNC1Customer Master Transaction FiguresCUSTOMER MASTER
VCKUNAssign customer credit cardCUSTOMER MASTER
KNVVCustomer Master Sales DataCUSTOMER MASTER
KNVPCustomer Master Partner FunctionsCUSTOMER MASTER
KNVLCustomer Master LicensesCUSTOMER MASTER
KNVICustomer Master Tax IndicatorCUSTOMER MASTER
KNVACustomer Master Unloading PointsCUSTOMER MASTER
KNKKCustomer master credit management: Control area dataCUSTOMER MASTER
KNKACustomer master credit management: Central dataCUSTOMER MASTER
KNEXCustomer Master: Legal Control  Sanctioned Party ListCUSTOMER MASTER
KNASCustomer master (VAT registration numbers general section)CUSTOMER MASTER
KNVKCustomer Master Contact PartnerCUSTOMER MASTER
KNVDCustomer master record sales request formCUSTOMER MASTER
KNVSCustomer Master Shipping DataCUSTOMER MASTER
KNBKCustomer Master (Bank Details)CUSTOMER MASTER
KNMTCustomer-Material Info Record Data TableCUSTOMER MASTER
KNB5Customer Master Dunning DataCUSTOMER MASTER
LFA1Vendor Master (General Section)VENDOR MASTER
LFB1Vendor Master (Company Code)VENDOR MASTER
LFASVendor master (VAT registration numbers general section)VENDOR MASTER
LFB5Vendor master (dunning data)VENDOR MASTER
LFBKVendor Master (Bank Details)VENDOR MASTER
LFBWVendor master record (withholding tax types) XVENDOR MASTER
LFM1Vendor master record purchasing organization dataVENDOR MASTER
LFM2Vendor Master Record: Purchasing DataVENDOR MASTER
WYT1Vendor SubrangeVENDOR MASTER
WYT1TVendor Sub Range DescriptionVENDOR MASTER
WYT3Partner FunctionsVENDOR MASTER
LFC1Vendor master (transaction figures)VENDOR MASTER
LFMHVendor HieararchyVENDOR MASTER
T078KTransaction-dependent screen selection for vendor masterVENDOR MASTER
LFC3Vendor master (special G/L transaction figures)VENDOR MASTER
MARAGeneral Material Data  MATERIAL MASTER
MAKTMaterial DescriptionsMATERIAL MASTER
MARCPlant Data for MaterialMATERIAL MASTER
MBEWMaterial ValuationMATERIAL MASTER
MARDStorage Location Data for MaterialMATERIAL MASTER
MARMUnits of Measure for Material  MATERIAL MASTER
MVKESales Data for MaterialMATERIAL MASTER
MPOPForecast ParametersMATERIAL MASTER
MPGD_MASSPlanning DataMATERIAL MASTER
MLANTax Classification for MaterialMATERIAL MASTER
MLGTMaterial Data for Each Storage TypeMATERIAL MASTER
MVERMaterial ConsumptionMATERIAL MASTER
MTQSSMaterial master view: QMMATERIAL MASTER
MKPFHeader: Material DocumentMATERIAL MASTER
MKALProduction Versions of MaterialMATERIAL MASTER
MLGNMaterial Data for Each Warehouse NumberMATERIAL MASTER
MOFFOutstanding Material Master RecordsMATERIAL MASTER
MSTAMaterial Master StatusMATERIAL MASTER
MASTMaterial to BOM LinkMATERIAL MASTER
MSEGDocument Segment: MaterialMATERIAL MASTER
MEANInternational Article Numbers (EANs) for MaterialMATERIAL MASTER

Company and Company Code

In SAP world, very frequently you might be coming across the Word Company and Company Code. Sometimes it is understood that these two words are interchangeable and have the same meaning. But in fact, these are not interchangeable and are two different words with different meaning. Hence one should not derive the same meaning from the two. In SAP, to understand the definition and assignment of enterprise structure and terminology used for different organizational level, it is necessary to understand the following definition of these two words. Read more

Useful Function Modules

 

This is an article listed few of the SAP function Modules, which are available in the system and can be used for various purposes, Some of them are left undocumented, which are left for further exploration. User may explore them and find out how useful they can be for their purposes. 

1 .WS_DOWNLOAD: File transfer from internal table into presentation server file.

2. WS_UPLOAD: File transfer from presentation server file to internal table. This function Module transfers file from workstation to SAP System. Pass on the name of ASCII file user wants to upload and that gets uploaded in memory. Read more

Concept and Structure of Tables in SAP

All data in SAP neccesarily sits in tables. A table is nothing but a matirx containing rows and columns which how the database would handle the data. In SAP, each table contains a header. The header defines the fields i.e. columns in the table. Each table also contains data values which are identically configured rows which contain data values. There are normally four types of tables in SAP. Read more

FAQ On SAP

In this paper following topics covered with Questions and Answer in detail,very useful for beginners;

1) SAP ARCHITECTURE.
2) DICTIONARY
3) TRANSACTIONS(DIALOG).
4) TRANSACTIONS.
5) SAP SCRIPT
6) BATCH DATA COMMUNICATION.
7) ALE/EDI Read more

Customized Transactions:SE93

One of the most asked question in a SAP interview is whether it is possible to have a self defined transaction code in SAP. The answer to the question is simple and if given tactfully can impress the interviewers.

To start with, yes, self-defined reports, transactions or functions are possible within SAP. There might be numerous reasons why a company might go in for customized transaction codes or for that matter reports. Read more

Useful Tables and Functional Modules(Updated)

 

  1. To find all the tables used in a transaction use table : D010TAB (Get the main program of the transaction from SE93)
  2. To find all the tables which contains a specific field use table : DD03L ( For text DD03T)
  3. To find all the segments that contains a specific fields use table : EDSAPPL
  4. To find all the Idoc basic type that contains a specific segment use table: IDOCSYN
  5. To find all the Idoc extensions that contains a specific segment use table: CIMSYN
  6. To find all the parameter Id Use table : TPARA
  7. To get the main program of a include use FM : RS_GET_MAINPROGRAMS Read more