1. Home
  2. Resources
  3. SAP Tables
  4. S260 - SD - Sales order

SAP Table S260

SD - Sales order

S260 (SD - Sales order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link S260 to other SAP tables.

S260 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SSOUR Statistic(s) origin SSOUR CHAR 4 0
VRSIO Version number in the information structure VRSIO CHAR 3 0
SPMON Period to analyze - month SPMON NUMC 6 0
SPTAG Period to analyze - current date SPTAG DATS 8 0
SPWOC Period to analyze - week SPWOC NUMC 6 0
SPBUP Period to analyze - posting period SPBUP NUMC 6 0
VBELN Sales Document VBELN_VA VBUK CHAR 10 0
POSNR Sales Document Item POSNR_VA VBUP NUMC 6 0
ETENR Delivery Schedule Line Number ETENR VBEP NUMC 4 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
VWDAT Pointer to administrative data VWDAT NUMC 10 0
WAERK SD Document Currency WAERK TCURC CUKY 5 0
HWAER Local Currency HWAER CUKY 5 0
STWAE Statistics currency STWAE CUKY 5 0
BUKRS Company Code BUKRS CHAR 4 0
AUART Sales Document Type AUART CHAR 4 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
VKBUR Sales Office VKBUR CHAR 4 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
VKGRP Sales Group VKGRP CHAR 3 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
SPARA Division for order header SPART_AK CHAR 2 0
AUGRU Order reason (reason for the business transaction) AUGRU CHAR 3 0
FAKSK Billing block in SD document FAKSK CHAR 2 0
LIFSK Delivery block (document header) LIFSK CHAR 2 0
VGTYP_AK Sales Document Category of Reference Doc. in Order Header MC_VBTYPAK CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
OIISOIL Sales order created by IS-Oil: X=Yes BLANK=No OID_ISOIL CHAR 1 0
X Yes
NULL No
OIPTRFNC Partner function OID_PTRFNC CHAR 2 0
OIPARTNR Customer name (sold-to party or ship-to party) OID_PARTNR CHAR 10 0
OICHEADOFF Head office account number (in branch accounts) KNRZE CHAR 10 0
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
OICFKARTDI Differential invoice billing type proposal OICFKARTDI CHAR 4 0
OIAEVGTYPE Evergreen type OIA_EVTYPE CHAR 1 0
NULL None
R Regular
U Unlimited
OIPTRM1 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPFLIC IS-OIL partner function for tax exemption license OIH_PFLIC CHAR 2 0
OIG_SSTSF TD Shipment Status (Functional) OIG_SSTSF CHAR 1 0
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
OIC_NXTINV Next billing date for invoice if status is provisional OIC_NXINV DATS 8 0
PSTYV Sales document item category PSTYV CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
PRODH Product hierarchy PRODH_D CHAR 18 0
MATKL Material Group MATKL CHAR 9 0
CHARG Batch Number CHARG_D CHAR 10 0
FAKSP Billing block for item FAKSP_AP CHAR 2 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
ROUTE Route ROUTE CHAR 6 0
SPART Division SPART CHAR 2 0
PKUNWE Ship-to party KUNWE CHAR 10 0
PKUNRE Bill-to party KUNRE CHAR 10 0
PKUNRG Payer KUNRG CHAR 10 0
PSPDNR Forwarding agent SPDNR CHAR 10 0
PVRTNR Sales employee VRTNR NUMC 8 0
PABLA Unloading point of the ship-to party PABLA CHAR 25 0
MVGR1 Material group 1 MVGR1 CHAR 3 0
MVGR2 Material group 2 MVGR2 CHAR 3 0
MVGR3 Material group 3 MVGR3 CHAR 3 0
MVGR4 Material group 4 MVGR4 CHAR 3 0
MVGR5 Material group 5 MVGR5 CHAR 3 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
ABSTA Rejection status for SD item ABSTA_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALL General Incompletion Status of Item UVALL_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK Incompletion status of the item with regard to delivery UVVLK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK Item Incompletion Status with Respect to Billing UVFAK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Pricing for item is incomplete UVPRS_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KDGRP Customer group KDGRP CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AEDAT Changed On AEDAT DATS 8 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
FBUDA Date on which services rendered FBUDA DATS 8 0
STADAT Statistics date STADAT DATS 8 0
VRKME Sales unit VRKME T006 UNIT 3 0
MEINS Base Unit of Measure MEINS UNIT 3 0
ZIEME Target quantity UoM DZIEME UNIT 3 0
GEWEI Weight Unit GEWEI UNIT 3 0
VOLEH Volume unit VOLEH UNIT 3 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
UMZIZ Factor for converting sales units to base units (target qty) UMZIZ DEC 5 0
UMZIN Factor for converting sales units to base units (target qty) UMZIN DEC 5 0
CMKUA Credit data exchange rate for requested delivery date CMKUA DEC 9 5
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
STCUR Exchange rate for statistics STCUR DEC 9 5
NETPR Net price NETPR CURR 11 2
VGTYP Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIPLANTD Plant determination active or not active OID_PLANTD CHAR 1 0
X Yes
NULL No
OIBYPASS IS-Oil plant determination indicator: x=yes blank=no OID_BYPASS CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIEDBAL Excise duty balancing is required (indicator) OIH_EDBAL CHAR 1 0
X Yes
NULL No
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIINEX Code for internal or external excise duty rate determination OIH_INEX CHAR 2 0
OIDRC Differential Reference Code (DRC) OIC_DRC CHAR 5 0
OIPSDRC Pricing DRC (grouping customers by DRC for pricing) OIC_PSDRC CHAR 5 0
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIC_LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
OIC_DCITYC Destination city code OIC_DCITYC CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC CHAR 3 0
OIC_OCITYC Origin city code OIC_OCITYC CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC CHAR 3 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_PBATCH Pipeline operator�s external batch number OIC_PBATCH CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT TVTR CHAR 2 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP TOIA2 CHAR 4 0
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC T008 CHAR 1 0
OICONTNR Outline agreement: contract OIC_CONTNR CHAR 10 0
OIFEECH Fee edit control OIA_FEECH CHAR 1 0
1 Add, delete, change, reprice abilities active
2 Change, reprice only
3 Display only active
OIH_LICTP License type OIH_LICTP CHAR 4 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
OID_SHIP Ship-to party OI0BW_KUNWE CHAR 10 0
NETWR Net value of the order item in document currency NETWR_AP CURR 15 2
WAVWR Cost in document currency WAVWR CURR 13 2
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
ZWERT Target Value for Outline Agreement in Document Currency DZWERT CURR 13 2
ZMENG Target quantity in sales units DZMENG QUAN 13 3
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
LSMENG Cumulative required delivery qty (all dlv-relev.sched.lines) LSMENG QUAN 15 3
KBMENG Cumulative confirmed quantity in sales unit KBMENG QUAN 15 3
KLMENG Cumulative confirmed quantity in base unit KLMENG QUAN 15 3
LFMNG Minimum delivery quantity in delivery note processing MINLF QUAN 13 3
BRGEW Gross Weight of the Item BRGEW_AP QUAN 15 3
NTGEW Net Weight of the Item NTGEW_AP QUAN 15 3
VOLUM Volume of the item VOLUM_AP QUAN 15 3
ANZAU Number of orders MC_ANZAU DEC 9 0
ANZAUPOS Number of order items MC_ANZAUPO DEC 9 0
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13 3
OIFEETOT Fee total (document currency) OIA_FEETOTD CURR 13 2
OISMENGE Called-off/delivered/goods receipt quantity OIA_SMENGE QUAN 13 3
OIINTQTY Quantity scheduled to be exchanged OIA_INTQTY QUAN 13 3
OIMEINS Quantity schedule-related UoM OIA_MEINS T006 UNIT 3 0
OIRECQTY Quantity intended against an exchange OIA_RECQTY QUAN 13 3
ETTYP Schedule line category ETTYP CHAR 2 0
LIFSP Schedule line blocked for delivery LIFSP_EP CHAR 2 0
LDDAT Loading Date LDDAT DATS 8 0
TDDAT Transportation Planning Date TDDAT_D DATS 8 0
EDATU Schedule line date EDATU DATS 8 0
WADAT Goods Issue Date WADAT DATS 8 0
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
WLDATBE Desired del. date in confirmed schedule lines WLDATBE DATS 8 0
WMENG Order quantity in sales units WMENG QUAN 13 3
LMENG Required quantity for mat.management in stockkeeping units LMENG QUAN 13 3
BMENG Confirmed Quantity BMENG QUAN 13 3
CMENG Corrected quantity in sales unit CMENG QUAN 13 3

S260 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
S260 ETENR S260 POSNR VBEP Sales Document: Schedule Line Data POSNR
S260 ETENR S260 ETENR VBEP Sales Document: Schedule Line Data ETENR
S260 ETENR S260 MANDT VBEP Sales Document: Schedule Line Data MANDT
S260 ETENR S260 VBELN VBEP Sales Document: Schedule Line Data VBELN
S260 KUNNR S260 MANDT KNA1 General Data in Customer Master MANDT
S260 KUNNR S260 KUNNR KNA1 General Data in Customer Master KUNNR
S260 MANDT S260 MANDT T000 Clients MANDT
S260 OIC_LIFNR S260 OIC_LIFNR LFA1 Vendor Master (General Section) LIFNR
S260 OIC_LIFNR T000 MANDT LFA1 Vendor Master (General Section) MANDT
S260 OIC_MOT T000 MANDT TVTR Routes: Modes of Transport MANDT
S260 OIC_MOT S260 OIC_MOT TVTR Routes: Modes of Transport VKTRA
S260 OIEXGTYP S260 OIEXGTYP TOIA2 Exchange types EXGTYP
S260 OIEXGTYP SYST MANDT TOIA2 Exchange types MANDT
S260 OIMEINS SYST MANDT T006 Units of Measurement MANDT
S260 OIMEINS S260 OIMEINS T006 Units of Measurement MSEHI
S260 OINETCYC SYST MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
S260 OINETCYC S260 OINETCYC T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
S260 POSNR S260 VBELN VBUP Sales Document: Item Status VBELN
S260 POSNR S260 POSNR VBUP Sales Document: Item Status POSNR
S260 POSNR S260 MANDT VBUP Sales Document: Item Status MANDT
S260 VBELN S260 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
S260 VBELN S260 VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
S260 VRKME S260 VRKME T006 Units of Measurement MSEHI
S260 VRKME S260 MANDT T006 Units of Measurement MANDT
S260 WAERK S260 MANDT TCURC Currency Codes MANDT
S260 WAERK S260 WAERK TCURC Currency Codes WAERS