SAP SD Tables Overview

MODULE    FUNCTIONAL 
   AREA
TABLE  NAME DESCRIPTION TABLE  OVERVIEW
SD Credit Management KNKA Customer Master Credit Mgmt. KNKA table defines the Customer Master Credit Mgmt. By using this table you can find the customer number, total credit limit across all control areas, credit limit for individual control area,currency and Date of the last general information. Additional Info: Key field for this table is Customer Number.
SD Credit Management KNKK Customer Master Credit Control Area Data (credit limits) KNKK table defines the Customer Master Credit Control Area Data.By using this table you can find the customer number,Controlling Area,credit limit,sales value,total receivables,special liabilities,Exceeds(Date on which the credit limit exceeded), created date, created by,blocked status, risk categories such as high, low, medium etc. and customer credit group etc.Additional Info: Key fields for this table are Customer Number and Credit control area.
SD Credit Management S066 Open orders: credit management S066 table defines the Open orders credit management information.By using this table you can find the credit control areas, credit account number,Period to analyze - month,Period to analyze - week,Period to analyze - posting period,currency,open order credit, guaranteed open orders. Additional Info: Key fields for this table are Statistic(s) origin,Version number in the information structure,Credit control area,Customer's account number with credit limit reference,Period to analyze - month,Period to analyze - current date,Period to analyze - week and Period to analyze - posting period.
SD Customer Master related  KNB5 Customer Master – Dunning info KNB5 table defines the Customer Master – Dunning info.The dunning program sets the dunning level automatically when the customer or vendor receives a dunning notice. By using this table you can find the customer, company code, Dunning Area,Dunning Procedure,Dunning Block, Last Dunned, date,Account number of the dunning recipient,Date of the legal dunning proceedings and Dunning clerk. Additional Info: Key fields for this table are  Customer Number,Dunning Area and Company Code.
SD Customer Master related  KNVI Customer Master Tax Indicator KNVI table defines the Customer Master Tax Indicator. By using this table you can find the customer number, country, tax category, tax classification such as Specify the tax liability of the customer, based on the tax structure of the customer's country. Additional Info: Key fields for this table are Customer Number, Departure country (country from which the goods are sent) and Tax category (sales tax, federal sales tax,...).
SD Customer Master related  KNVP Partner Function key KNVP table defines the Partner Function key. By using this table you can find the customer number, sales area,partner function,etc.Additional Info: Key fields for this table are Customer Number,Sales Organization,Distribution Channel,Division,Partner Function and Partner counter.
SD Customer Master related  KNVS Customer Master Ship Data KNVS table defines Customer Master Shipping Data.By using this table you can find the customer goods/service to ship them through specific shipping point.Additional Info: Key fields for this table are Customer Number and Shipping Point/Receiving Point.
SD Customer Master related  KLPA Customer/Vendor Link KLPA table defines the Customer/Vendor Link.By using this table you can find the  account type such as Assets,Customers,Vendors,Material,G/L accounts, company code,cust/vendor,Partner Function Category in FI etc. Additional Info: Key fields for this table are Customer or Vendor Number,Company Code,Account type,Partner Function Category in FI,Customer or Vendor Number,Company Code, Account type. These are applicable for both Customer and vendors.
SD Customer Master related  T151T Customers: Customer groups: Texts T151T table identifies a particular group of customers (for example, wholesale or retail) for the purpose of pricing or generating statistics.By using this table you can find the customer group ID and text. Additional Info: Key fields for this table are Language Key and Customer group.
SD Customer Master related  KNVK Customer Master Contact Partner KNVK table defines the Customer Master Contact Partner. By using this table you can find the contact person ID, customer ID, first name , name 1,city, business address,department, home address,telephone no, note about the contact person,etc. Additional Info: Key fields for this table are Number of contact person and Customer Master Contact Partner.
SD Customer Master related  KNC1 Customer master (transaction figures) KNC1 table defines the Customer master (transaction figures).By using this table you can find the customer, company code, fiscal year,created on,user name,balance carry forward,Total of the Debit Postings for the Month,Total of the Credit Postings for the Month,Sales in the Posting Period,Authorized deductions (in local currency),Accepted deductions taken after end of discount period,Accumulated clearing amount in the fiscal year etc. Additional Info: Key fields for this table are Customer Number,Company Code and Fiscal Year.
SD Customer Master related  KNVA Customer Master Unloading Points KNVA table defines the Customer Master Unloading Points.By using this table you can find the customer number, uploading point,customer factory calander, Monday to Sunday, default uploading point,etc.Additional Info: Key fields for this table are Customer Number and Unloading Point.
SD Customer Master related  KNMT Customer-Material Info Record KNMT table defines the Customer-Material Info Record.By using this table you can find the customer number, sales org., distribution channel, Org. material number, customer material number,created on, created by, min. delivery, under delivery tolerance, over delivery,over delivery tolerance,unlimited tolerance,plant,rounding profile,etc. Additional Info: Key fields for this table are Sales Organization,Distribution Channel,Customer number and Material Number.
SD Customer Master related  KNVH Customer Hierarchies KNVH table defines the Customer Hierarchies. By using this table you can find the hierarchy type,customer,sales org.,Distribution channel,division,validity,etc.Additional Info: Key fields for this table are Customer,Customer hierarchy type,Sales Organization,Distribution Channel,Division and Start of validity period for assignment.
SD Customer Master related  KNC3 Customer master (special G/L transaction figures) KNC3 table defines the Customer master (special G/L transaction figures). By using this table you can find the customer, company code,fiscal year,special G/L indicator,balance carryforward, current year debits and current year credit. Additional Info: Key fields for this table are Customer Number,Company Code,Fiscal Year and Special G/L Indicator
SD Customer Master related  KNAS Customer master (VAT registration numbers general section) KNAS table defines the Customer master (VAT registration numbers general section). By using this table you can find the customer and country key and VAT registration number. Additional Info: Key fields for this table are Customer Number and Country Key.
SD Customer Master related  VKDFS SD Index: Billing Initiator VKDFS table defines the SD Index: Billing Initiator. By using this table you can find the billing status for various sales documents for different customers. And also you can find its billing type, billing block indicator for various sales areas. Additional Info: Key fields for this table are Billing category,Sales Organization,Billing Date for Billing Index and Printout,Sold-To Party,Billing Type,Country of Destination, and Sales and Distribution Document Number.
SD Customer Master related  MSSA Total Customer Orders on Hand MSSA tables defines the posting of the material against sales document and plant within a specific year and period.And also it defines the various inventory stock types such as unrestricted stock, quality inspection stock,blocked stock, restricted stock etc.We can find Total Customer Orders on Hand.Additional Info: Key fields for this table are material number, plant, batch number, sales and distribution document number and item number of SD document number.
SD Customer Master related  KNB4 Customer Payment History KNB4 table defines the Customer Payment History. By using this table you can find the customer, company code, payment date,year, month, payment with cash discount, without discount,Average Arrears for Payments Where No Cash Discount Taken, etc. Additional Info: Key fields for this table are Customer Number and Company Code.
SD Inventory Management MSKU Special Stocks with Customer MSKU table defines  how many special stocks are posted in which year and which period. Moreover it contains stock information in various business scenarios. By using this table you can clear the aged stock of the material in various plants and storage locations and warehouse stocks. Additional Info: Key fields for this table are Material Number, plant, batch number, special stock indicator, and customer number.
SD Logistic LIPS Delivery Document item data, includes referencing PO LIPS table defines the Delivery Document item data, includes referencing PO. By using this table you can find the delivery document number and its item number, Item category,created by,created on, material attributes such as material group, UOM etc., plant and it storage location, batch number, Profit center, movement type etc. Additional Info: Key fields for this table are Delivery and Delivery Item.
SD Logistic LIKP Delivery Document Header data LIKP table defines the Delivery Document Header data.By using this table you can find the delivery number,created by, created on,shipping point,sales org., delivery types, complete delivery flag, Planned goods movement date, loading date, transportation planning date, delivery date,picking date,incoterms,routing, number, flags like billing block and delivery block, sales document categories, factory calendar, delivery priority, shipping conditions,warehouse number,etc. Additional Info: Key field for this table is Delivery.
SD Logistic S067 Open deliveries/billing documents (KM) S067 table defines the Open deliveries/billing documents (KM). By using this table you can find the version, credit control area,credit account number,Period to analyze - month,Period to analyze - current date,Period to analyze - week,Period to analyze - posting period,open delivery credit amount,open bill document credit,currency etc. Additional Info: Key fields for this table are Statistic(s) origin,Version number in the information structure,Credit control area,Customer's account number with credit limit reference,Period to analyze - month,Period to analyze - current date,Period to analyze - week and Period to analyze - posting period.
SD Logistic TVRO Routes TVRO table defines various Routes in logistic process. By using this table you can find the route number, route description, transit in no. of days,transportation planning in days,factory calendar, mode of transport such as sea, air, road, mail etc.,service agent code, etc. Additional Info: Key field for this table is Route.
SD Logistic TVROT Routes: Texts TVROT table defines various Routes in logistics process to supply goods/ service. Additional Info: Key fields for this table are Language Key and Route.
SD Logistic VEKP Handling Unit Header VEKP table defines the handling unit information while shipping the goods / services. It contains  various units for header level goods / service. By using this table you can find various materials total weight, loading weight, allowed loading weight, tare weight and also total volume, loading volume, allowed volume, tare volume etc. while shipping goods/service. Additional Info: Key field for this table is Internal Handling Unit Number.
SD Logistic VEPO Handling Unit Item (Content) VEPO table defines the handling unit information while shipping the goods / services. It contains various units for item level goods / service. By using this table you can find the handling unit and its related delivery note and line item, materials information, which plant and storage location shipping  has been performed etc. Additional Info: Key fields for this table are Internal Handling Unit Number and Handling Unit Item.
SD Logistic VTTK Shipment Header VTTK  table defines the Shipment Header information with its shipping number. By using this table you can find the shipment types like individual shipment, collective shipment etc., shipping types like truck, sea, air etc, transportation planning, shipping conditions, route, container id. And also this table will capture all stages of planned time as well as actual time.  Additional Info: Key fields for this table are Shipment Number,SD document category,Shipment type,Transportation planning point etc.
SD Logistic VTTP Shipment Item VTTP table defines the Shipment item level  information with combination of shipping number and delivery number. By using this table you can find the shipment number and its item level with delivery number, created by, created date.  Additional Info: Key fields for this table are Shipment Number,Shipment item,Delivery,Itinerary of shipment items,Name of Person Who Created the Object,Date on Which Record Was Created,Entry time, and there are Packed Deliveries Dependent on Shipping.
SD Logistic VTTS Stage of Shipment VTTS table defines mainly various stages in shipment process while  transportation.By using this table you can find the shipment number , stage of transportation number, stage category like 1= transporation, 2=load transfer, 3= border, route of stage, departure point and destination points, and its planned and actual timing are captured. Additional Info: Key fields for this table are Shipment Number and Stage of transport number.
SD Logistic VEPVG Delivery Due Index VEPVG table defines the Delivery Due Index for various sales documents such as quotation, sales order etc.By using this table you can find the Shipping point/receiving point, sales document, delivery creation date , customer,sales area( is nothing but Sales Ordg., Distribution Channel, and Division),  Delivery priority, Goods Issues dates etc.Additional Info: Key fields for this table are Shipping Point/Receiving Point,Delivery Creation Date,Delivery Priority,Route,Forwarding agent,Goods Issue Date,Ship-To Party,Sales and Distribution Document Number and Delivery block for header or schedule line.
SD Logistic TVSBT Shipping Conditions: Texts TVSBT table defines the Shipping Conditions.By using this table you can find the Shipping condition code and description. Additional Info: Key fields for this table are Language Key and Shipping Conditions.
SD Logistic EKPV Shipping Data For Stock Transfer of Purchasing Document Item EKPV table defines the Shipping Data For Stock Transfer of Purchasing Document Item. By using this table you can find the stock transfer order number and its line item,shipping point,delivery priority,route,customer,sales area,shipping conditions,loading group, transportation group,etc. Additional Info: Key fields for this table are Purchasing Document Number and Item Number of Purchasing Document.
SD Logistic TVSWZ Shipping Points per Plant TVSWZ table defines the Shipping Points per Plant.By using this table you can find the assignment of  each shipping point to plant. Additional Info: Key fields for this table are Plant and Shipping Point/Receiving Point.
SD Sales Documents    VBAKUK Sales Document - Header Data VBAKUK table defines the Sales Document - Header Data status such as sales order, ref. document, sales area information, delivery status, billing status, and also you can find item delivery information. This is  one of the most useful tables for analysts to calculate overall cycle time for sales documents. Sales documents such as inquiry, quotation, sales order, contract, item proposal, scheduling agreement etc. Additional Info: Key field for this table is Sales Document.
SD Sales Documents    VBUK Header Status and Administrative Data VBUK table has the functionality of various documents workflow in header level. You can find the these documents flow status with identifiers. It is useful for quick check of any document status which has certain transaction.Additional Info: Key field for this table is Sales and Distribution Document Number
SD Sales Documents    VBAK Sales Document - Header Data VBAK table defines Sales Document - Header Data.Sales documents like inquire, quotations, order, contract, scheduling, debit memo orders , credit memo orders details are stored  in header level. The data which is stored in document header is applicable to the entire document such as customer, header text, incoterms etc. Additional Info: Key field for this table is Sales Document
SD Sales Documents    VBKD Sales Document - Business Data VBKD table helps you to find out Payment conditions , pricing conditions, exchange rates conversion for particular sales document. And also it captures the incoterms and purchasing flow.Additional Info: Key fields for this table are Sales and Distribution Document Number and Item number of the SD document.
SD Sales Documents    VBUP Item Status VBUP table has the functionality of various documents flow in item level. You can find these documents flow status with identifiers. It is useful for quick check of any document status which has certain transaction.Additional Info: Key fields for this table are Sales and Distribution Document Number and Item number of the SD document.
SD Sales Documents    VBAP Sales Document - Item Data Customizing Data in VBAP

In standard Release 4.6B, the customizing fields RRREL and ACDATV are stored in the VBKD table at item level. In IS-SW, we stored these fields in VBAP (item level). The conversion program performs the necessary transfer of data from VBAP to VBKD.

The algorithm is as follows:

Select all revenue recognition relevant items from VBAP

For each record

Select corresponding item level entry in VBKD If found, update fields RRREL, ACDATV

If not found, select the corresponding header entry in VBKD Insert item level record with header as reference

If header entry not found in VBKD, it is an error
Additional Info: Key fields for this table are Sales Document and line item.
SD Sales Documents    VBPA Partners VBPA table is basically used for assigning partner functions to various sales documents. Further it has time zone assignment with respective countries.Additional Info: Key fields for this table are Sales and Distribution Document Number,Item number of the SD document and Partner Function.
SD Sales Documents    VBFA Document Flow VBFA table defines the document flow records (entries maintained in the table VBFA) are required to execute the order allocation run changes in the sales documents and the delivery documents during scenarios such as Open quantity during the Contract Call-off handling and Identifying Delivery Quantity to compare with the Allocated Quantity. Additional Info: Key fields for this table are Preceding sales and distribution document,Preceding item of an SD document,Subsequent sales and distribution document, Subsequent item of an SD document and Document category of subsequent document.
SD Sales Documents    VBEP Sales Document Schedule Line VBEP table has further drilldown of VBAP table, which has detailed info from sales document such as schedule line, scheduled dates, scheduled qty., confirmed qty., which movement use etc. This table basically helps to find out sales document line item details for planning of the goods to be delivered.Additional Info: Key fields for this table are Sales Document,Sales Document Item and Schedule Line Number.
SD Sales Documents    VBBE Sales Requirements: Individual Records VBBE table provides the material availability, sales documents, from which plant the document is created, line and document type. Apart from this it is also provides the information about sold to party id.Additional Info: Key fields for this table are Sales Document,Sales Document Item and Schedule Line Number.
SD Sales order BOM KDST Sales Order to BOM Link KDST table defines the Sales Order to BOM Link. By using this table you can find the sales order, line item, material, plant, BOM Usage,BOM  number(Number used in combination with the BOM category to uniquely identify a BOM or a BOM group), alternate BOM,created, etc. Additional Info: Key fields for this table are Sales Order,Sales order item,Material Number,Plant,BOM Usage,Bill of material and Alternative BOM.
SD Sales Price related EIPA Order Price History: Info Record EIPA table defines the Order Price History: Info Record. By using this table you can find the info record number, purchase order and its line item, info category such as 0=Standard,2=Consignment,3=Subcontracting,P=Pipeline, and plant purchase org. PO date,Net Price, Price , qty. etc. Additional Info: Key fields for this table are Number of purchasing info record,Purchasing Document Number and Item Number of Purchasing Document.
SD Sales related VRKPA Sales Index: Bills by Partner Functions VRKPA table defines the Sales Index: Bills by Partner Functions. By using this table you can find the billing document, which partner function is assigned to billing process, what kind of billing document is created, in which fiscal year it is created, in which sales org., and billing document, created date. Additional Info: Key fields for this table are Partner number (KUNNR, LIFNR, or PERNR),Partner Function,Sales Organization,Billing Type,Payer,Sold-To Party,SD document category, Billing Document etc.
SD Sales related VEDA Contract Data VEDA table defines the sales Contract Data such as contract start date and contract end date, validity period categories like 1= 6 months contracts, 2=1year contracts and 3= years contract in your business.Additional Info: Key fields for this table are Sales Document,Sales Document Item,Validity period of contract,Unit of validity period of contract,Validity period category of contract,Installation date,Date on which contract is signed,Date on which cancellation request is received,Reason for Cancellation of Contract etc.
SD Sales related MSKAH Sales Order Stock: History MSKAH table defines the Sales Order Stock History with combination of material, plant and storage location and fiscal year and period. By using this table you can find the various inventory stock types such as unrestricted stock, quality inspection stock,blocked stock,restricted stock etc. Additional Info: Key fields for this table are Material Number,Plant,Storage Location,Batch Number,Special Stock Indicator,Sales and Distribution Document Number,Item number of the SD document,Fiscal Year of Current Period,and Current period (posting period).
SD Sales related KNVV Sales Area Data (terms, order probability) KNVV table defines the customer number with its sales area assignment.By using this table you can find  which Pricing procedure is assigned to this customer,  Customer order block (sales area), to which Customer group does this customer number fall, to which Price group (customer) does this customer fall, what is the Price list type,what is the % of Order probability of the item,Incoterms (Part 1 and Part-2),Customer delivery block (sales area),Maximum Number of Partial Deliveries Allowed Per Item,Delivery Priority,Shipping Conditions,Billing block for customer (sales and distribution),currency, account assignment type,payment type,sales office etc. . Additional Info: Key fields for this table are Customer Number,Sales Organization,Distribution Channel and Division.
SD Sales related KNVD Output type KNVD table defines various output types(pint out related configuration).By using this table you can find  the output determination.Additional Info: Key fields for this table are Customer Number,Sales Organization,Distribution Channel,Division,Output Type and Message language.
SD Sales related TSPAT Organizational Unit: Sales Divisions: Texts TSPAT table defines one of the Organizational Units i.e. Sales Division.By using this table you can find various sales divisions code and text. Additional Info: Key fields for this table are Language Key and Division.
SD Sales related BGMK Master Warranty Header BGMK table defines the number of the master warranty.This number, which has a maximum of 20 digits, can be assigned both internally and externally, depending on the way the system is set up for your company.By using this table you can find the warranty number and its text,validity, extend warranty,warranty period like 6 months, 12 months, 3 years, 4 years etc., created by,warranty type,Indicator: Pass on Warranty,. Additional Info: Key field for this table is Master warranty number.
SD Sales related TVAKT Sales Document Types: Texts TVAKT table defines the Sales Document Types: Texts.By using this table you can find various document types such as Standard order,Inquiry,Quotation, contracts etc. Additional Info: Key fields for this table are Language Key and Sales Document Type.
SD Sales related TVGRT Organizational Unit: Sales Groups: Texts TVGRT table defines one of the Sales Organizational Units i.e. Sales Group.By using this table you can find various sales groups and its text. Additional Info: Key fields for this table are Language Key and Sales group.
SD Sales related TVKBT Organizational Unit: Sales Offices: Texts TVKBT table defines one of the Sales Organizational Units i.e. Sales Office. By using this table you can find various sales offices and its text. Additional Info: Key fields for this table are Language Key and Sales Office.
SD Sales related TVKO Organizational Unit: Sales Organizations TVKO table defines the Sales Organizational Units and its link to various Purchase org.By using this table you can find various sales org. code and text, company code,currency, reference sales org., rebate procedure active flag, Purchase org, Purchase group, vendor,order type, plant,purchase document category, movement ype,tax number, etc. Additional Info: Key field for this table is Sales Org.
SD Sales related TVKOT Organizational Unit: Sales Organizations: Texts TVKOT table defines one of the Organizational Units i.e.Sales Organization.By using this table you can find the sales org. code and text. Additional Info: Key fields for this table are Language Key and Sales Organization.
SD Sales related TVAPT Sales document item categories: Texts TVAPT table defines the Sales document item categories and its description.By using this table you can find the sales order item categories such as AGN =Standard Item,AGNN = Free of Charge Item etc. Additional Info: Key fields for this table are Language Key and Sales Document Item Category. 
SD Sales related BGMKOBJ Master Warranty - Object Assignment BGMKOBJ table defines the Master Warranty - Object Assignment.By using this table you can find the object number,warranty type such as customer warranty, vendor warranty etc, begin guarantee date, warranty end date,created on, etc. Additional Info: Key fields for this table are Object number and Warranty type.
SD Sales related AFPO Order item AFPO table defines the Order item.By using this table you can find the order number and line item,special procurement key such as  Consignment,IS-OIL only: Stock transfer reservation,Standard external procurement,Standard in-house production,Stock transfer,Subcontracting, etc., WBS element,planned order,sales order, and its line item,scrap qty.,G/R qty.,material,planning plant and storage location,order type, etc.Additional Info: Key fields for this table are Order Number and Order item number.
SD Sales related EBEW Sales Order Stock Valuation EBEW table defines the Sales Order Stock Valuation. By using this table you can find the past, current and future moving average price anad standard prices. And also you can find material, valuation area, valuation type,special stock indicator,document and its  line item,total, total values, fiscal year and period,product cost estimate no., etc. Additional Info: Key fields for this table are Material Number,Valuation Area,Valuation type,Special Stock Indicator,Sales and Distribution Document Number and Item number of the SD document.

Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget