SAP SD Tables PDF
SAP SD Tables PDF
SAP SD Tables PDF
Plant and specific procurement type information like consigment ,stock transfer
List of pricing procedures ex: RVAA01
List of pricing procedures descriptions ex: RVAA01- Standard
Stores the information about company code currencies ex: USD,EUR,INR etc
Stores the information about company code currencies exchange rates
Stores the information about company code currencies descriptions: US dollors,euros,indian rupees etc.
Stores the information about company code currency decimals allowed ex: .00,.000 etc
Information about cutomer specific inco terms ex: CFR - costs and fright etc
Contains list of Controlling areas ex: 0001,1000,etc
Contains list of Controlling areas assigned with Company codes ex: 0001 to 0001,1000 to 1000,etc
Information about customer classification descriptions
Information about customer delivery priority ex: 01- as soon as possible etc
define the purpose of the maintenance notification for your company.
Stores all the Sales documents reason for rejections information ex: Poor quality, price too high,damages ect
Stores all the Sales documents information ex: Inquiry,Quotation,Sales order,Contracts,returns etc
Stores all the Sales documents header text information ex: Inquiry,Quotation,Sales order,Contracts,returns etc
Stores all the Sales documents header order reasons information ex: Sales call,
Stores all the Sales groups with relevant sales offices information of a perticular Sales org
Stores all Billing documents information ex: Invoice,cash invoice,Inter company invoice,Credit meo,debit memo etc
Stores all the Sales documents header text information ex: Inquiry,Quotation,Sales order,Contracts,returns etc
Stores all the information about reason for blocking the billing documents ex: FI interface problem
Stores all the information of a perticular Sales group description
Stores all the information of a perticular Sales office description
Stores all the sales offices information assighned with Sales org
Stores all the information of a perticular Sales org
Stores all the information of Description of a perticular Sales org
Stores all Delivery documents information ex: delivery with order,cash sales,returns,sto etc
Stores all Delivery documents description information ex: LF-delivery with order etc
Stores all Delivery documents Resons for blocking information ex: Blocked due to schdule lines etc
Stores all the information of a perticular Route descriptions
Stores all the information of Shipping points descriptions
Information about Sales areas ex: Combinations of Sales org/DC/Div
Stores all the information of Distribution chaneels descriptions ex: 10- direct etc
Stores all the information about cutomer groups descriptions ex: 01 - Whole saler etc
Stores all the information about cutomer specific payment terms descriptions ex: 0001- Immediately etc
It means how a sales order should behave will be defined here like sold-to-party, sales office, sales group, pricing date, document d
items will be customised here like item category, order quantity, material, batch number, product hierarchy, plant, material group,
schedule lines represent when the item will be delivered. Ex schedule line number, delivery date, order quantity, confirmed quant
Individual documents also a part of a chain of inter-related documents.ex a sales document contain a quotation, a sales order, del
Stores
Businessall the Sales documents
transactions Business
may have information
one or more ex:involved
partners Paymet in
terms,Inco terms,Delivery
the transaction.EX dates
Sold-to etc.placing the
Party
order.Ship-to Party receiving the delivery invoice may go to another entity called the Bill-to Party
Header contains general data which applies to the entire billing document. Ex No. of payer, billing date payment condition etc.
Items show data which is valid for one particular item. X Material no., Billing Qty, Net value of individual item etc.
In a transaction we will be having header data It means header data is where you have all the main elements i.e., sales document n
It contains all the item details. In VBUP there is a field FKSTK.By this filed status we can find billing status of particular sale order.
It offer functions for managing addresses. You can store and further process addresses, using different address types. Ex. Address
The header data of the change project for an object ID in a specific object class is stored in the change document header. A change
The change document item contains the older and new value for a field of a specific change project, as well as a change flag. Ex. U
Information about customer general details like name, phone number, address etc
Information about customer sales details Delivery plant,shipping condiitons,inco terms, delivery priorities etc
Pricing conditions - header information
Information about vendor general details like name, phone number, address etc
Stores all the information about Delivery document header
Stores all the information about Delivery document line item related
Material Description information in material master
Material general information in material master
Plant related information in material master
Material unit of measures information in material master ex: EA,PC etc
HR master record table contains personnel number and all details of an employee
List of all company codes
stores all info of Plant valuation area with company code
List of all storage locations
List of all storage locations with in a plant
Language specific text and its decription
List of all document types like accounting document type ,vendor invoice etc
store all Order type information like category ,number range etc
Order type and text description
Document type and text description
Chart of accounts and its descripetion like COA -USA
Stores all inforamtion for countries with country key like IN fro india
stores regiones for countries
Tables are a group of tables that hold the fiscal year information.
For maintain a year dependent fiscal year, you need to enter the month, year offset, period details etc .
stores the MRP Controller data there is indeed a Purchasing Group field.
Stores all information of purchasing organization like 008 IDES US
terms of payment details and daily limit
stores information of customer account number and its description like 001-sold to party
Material and material type description
text for industry sector and its description
Stores all information of Purchasing doc type eg number range ,partner determination procedure ,referance doc type etc
text for Purchasing document type and relevant category and description eg standard purchase order NB
text for customer specific sales zones like north region ,west region
group, pricing date, document date, order reason, document currency, price group, sales district, customer group, shipping condition, incoterms, paym
hierarchy, plant, material group, shipping point, route, delivery priority, customer material, item number, etc.
order quantity, confirmed quantity, material availability date, loading date, proposed goods issue date, transportation date, movement type, shipping
in a quotation, a sales order, delivery and an invoice.
Claim header
Client Y Y T000
Sales Document Y Y VBUK
Sales Document Item Y Y VBUP
Material Number Y MARA
Material entered Y MARA
Pricing Reference Material Y MARA
Batch Number Y MCHA
Material Group Y T023
Short text for sales order item
Sales document item category Y TVPT
Item type
Item is relevant for delivery
Relevant for Billing
Higher-level item in bill of material structures
Item for which this item is an alternative
Reason for rejection of quotations and sales orders
Y TVAG
Product hierarchy Y T179
Target Value for Outline Agreement in Document Currency
Target quantity in sales units
Target quantity UoM Y T006
Factor for converting sales units to base units (target qty)
Time Zone
Distribution Status (Decentralized Warehouse Processing)
MSR_C_RET_REFUND
MSR_C_RET_REFUND
MSR_C_RET_REASON
/VSO/R_DPOINT
WRF_PSCD_TCHAINH
V_KNA1WETT
TCSCP_COMP_LVL
/BEV1/LUT906
/DSD/SL_TGTYP
/DSD/SV_CNTGR
/DSD/VC_GRP
WRFMATBSTAT
WRF_BRANDS
WRF_FIBER_CODES
WRF_FIBER_CODES
WRF_FIBER_CODES
WRF_FIBER_CODES
WRF_FIBER_CODES
TCSCP_COMP_LVL
TCSCP_CONV_TYPE
WRFT_CONS_PROCG
WRF_REF_RFS
Data Type
ACCP
CHAR
CLNT
CUKY
CURR
DATS
DEC
FLTP
INT1
INT2
INT4
LANG
LCHR
LRAW
NUMC
PREC
QUAN
RAW
TIMS
UNIT
VARC
Description
Posting period. The length is set to 6 places for this data type. The format is YYYYMM. In input and output, a point
is inserted between the year and month, so the template of this data type has the form ‘____.__’.
Character string. Fields of type CHAR may have a maximum length of only 255 in tables. If longer character fields
are to be used in tables, data type LCHR must be selected. In structures there are no restrictions on the length of
such fields.
Client. Client fields always have three places.
Currency key. Fields of this type are referenced by fields of type CURR. The length is set to 5 places for this data
type.
Currency field. Equivalent to a DEC amount field. A field of this type must refer to a field of type CUKY (reference
field). The maximum length for this data type is 17 places.
Date. The length is set to 8 places for this data type. The output template can be determined with the user profile.
Counter or amount field with decimal point, sign, and commas separating thousands. A DEC field has a maximum
length of 31 places. In tables, only DEC fields with a length <= 17 may be used.
Floating-point number. The length (including decimal places) is set to 16 places for this data type.
1-byte integer between 0 and 255. The length of this data type is set to 3 places.
2-byte integer between -32767 and 32767. Fields of this type should only be used for length fields. These long
fields are positioned immediately in front of a long field (type LCHR, LRAW). With INSERT or UPDATE on the long
field, the database interface enters the length which was actually used in the length field. The length for this data
type is set to 5 places.
4-byte integer between -2177483647 and 2177483647. The length is set to 10 places for this data type.
Language key. Has its own field format for special functions. This data type always has a length of 1.
Character string of arbitrary length, but with a minimum of 256 characters. Fields of this type must be located at the
end of transparent tables and must be preceded by a length field of type INT2. If there is an INSERT or UPDATE in
ABAP programs, this length field must be filled with the length actually required.
Uninterpreted byte string of arbitrary length, but with a minimum length of 256. Fields of this type must be located at
the end of transparent tables and must be preceded by a length field of type INT2. If there is an INSERT or
UPDATE in ABAP programs, this length field must be filled with the length actually required.
Long character field in which only numbers can be entered. The length of this field is limited to a maximum of 255
places.
Accuracy of a QUAN field. The length for this data type is set to 2 places.
Quantity. Equivalent to an amount field DEC. A field of this type must always refer to a units field with UNIT format
(reference field). The maximum length for this data type is 17 places.
Uninterpreted sequence of bytes. Fields of type RAW may have only a maximum length of 255 in tables. If longer
raw fields are required in tables, you should select data type LRAW.
Time. The length for this data type is set to 6 places. The format is hhmmss. The template for input and output has
the form ‘__.__.__’.
Units key. Fields of this type are referenced by fields of type QUAN. The length of this data type is set to 2 or 3
places.
Character field of variable length. Creation of new fields of this data type is not supported as of Release 3.0.
However, existing fields with this data type can still be used.
Column1 Column2
Numeric
Char
Char
Char
Decimal
Date
Decimal
Double ??
Int
Char
Char