SAP table S260 (SD - Sales order)

SAP table S260 has 10 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,VBELN,POSNR,ETENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SSOUR Statistic(s) origin CHAR 4 0 SSOUR
VRSIO Version number in the information structure CHAR 3 0 VRSIO
SPMON Period to analyze - month NUMC 6 0 SPMON
SPTAG Period to analyze - current date DATS 8 0 SPTAG
SPWOC Period to analyze - week NUMC 6 0 SPWOC
SPBUP Period to analyze - posting period NUMC 6 0 SPBUP
VBELN Sales Document CHAR 10 0 VBELN_VA
POSNR Sales Document Item NUMC 6 0 POSNR_VA
ETENR Schedule Line Number NUMC 4 0 VBEP ETENR
PERIV Fiscal Year Variant CHAR 2 0 PERIV
VWDAT Pointer to administrative data NUMC 10 0 VWDAT
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
HWAER Local Currency CUKY 5 0 * HWAER
STWAE Statistics Currency CUKY 5 0 * STWAE
BUKRS Company Code CHAR 4 0 BUKRS
AUART Sales Document Type CHAR 4 0 * AUART
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
VKBUR Sales office CHAR 4 0 * VKBUR
KVGR1 Customer Group 1 CHAR 3 0 * KVGR1
KVGR2 Customer Group 2 CHAR 3 0 * KVGR2
KVGR3 Customer Group 3 CHAR 3 0 * KVGR3
KVGR4 Customer Group 4 CHAR 3 0 * KVGR4
KVGR5 Customer Group 5 CHAR 3 0 * KVGR5
VKGRP Sales group CHAR 3 0 * VKGRP
KUNNR Sold-to Party CHAR 10 0 KNA1 KUNAG
SPARA Division for order header CHAR 2 0 * SPART_AK
AUGRU Order Reason (Reason for the Business Transaction) CHAR 3 0 * AUGRU
FAKSK Billing Block in SD Document CHAR 2 0 * FAKSK
LIFSK Delivery Block (Document Header) CHAR 2 0 * LIFSK
VGTYP_AK Sales Document Category of Reference Doc. in Order Header CHAR 4 0 MC_VBTYPAK
PSTYV Sales document item category CHAR 4 0 * PSTYV
MATNR Material Number CHAR 40 0 MATNR
PRODH Product hierarchy CHAR 18 0 * PRODH_D
MATKL Material Group CHAR 9 0 MATKL
CHARG Batch Number CHAR 10 0 * CHARG_D
FAKSP Billing Block for Item CHAR 2 0 * FAKSP_AP
WERKS Plant CHAR 4 0 WERKS_D
LGORT Storage location CHAR 4 0 * LGORT_D
VSTEL Shipping Point / Receiving Point CHAR 4 0 * VSTEL
ROUTE Route CHAR 6 0 * ROUTE
SPART Division CHAR 2 0 SPART
PKUNWE Ship-to Party CHAR 10 0 * KUNWE
PKUNRE Bill-to Party CHAR 10 0 * KUNRE
PKUNRG Payer CHAR 10 0 * KUNRG
PSPDNR Forwarding Agent CHAR 10 0 * SPDNR
PVRTNR Sales employee NUMC 8 0 VRTNR
PABLA Unloading point of the ship-to party CHAR 25 0 PABLA
MVGR1 Material Group 1 CHAR 3 0 * MVGR1
MVGR2 Material Group 2 CHAR 3 0 * MVGR2
MVGR3 Material Group 3 CHAR 3 0 * MVGR3
MVGR4 Material Group 4 CHAR 3 0 * MVGR4
MVGR5 Material Group 5 CHAR 3 0 * MVGR5
ABGRU Reason for Rejection of Sales Documents CHAR 2 0 * ABGRU_VA
ABSTA Rejection Status (Item) CHAR 1 0 ABSTA_VB
UVALL Incompletion Status (Item) CHAR 1 0 UVALL_UP
UVVLK Delivery Incompletion Status (Item) CHAR 1 0 UVVLK_UP
UVFAK Billing Incompletion Status (Item) CHAR 1 0 UVFAK_UP
UVPRS Pricing Incompletion Status (Item) CHAR 1 0 UVPRS_UP
KDGRP Customer Group CHAR 2 0 * KDGRP
BZIRK Sales District CHAR 6 0 * BZIRK
INCO1 Incoterms (Part 1) CHAR 3 0 * INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
KTGRD Account Assignment Group for this Customer CHAR 2 0 * KTGRD
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
FKDAT Billing Date DATS 8 0 FKDAT
FBUDA Date on which services are rendered DATS 8 0 FBUDA
STADAT Statistics date DATS 8 0 STADAT
VRKME Sales unit UNIT 3 0 T006 VRKME
MEINS Base Unit of Measure UNIT 3 0 * MEINS
ZIEME Target Quantity UoM UNIT 3 0 * DZIEME
GEWEI Weight Unit UNIT 3 0 * GEWEI
VOLEH Volume unit UNIT 3 0 * VOLEH
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
UMZIZ Factor for Converting Sales Units to Base Units (Target Qty) DEC 5 0 UMZIZ
UMZIN Factor for Converting Sales Units to Base Units (Target Qty) DEC 5 0 UMZIN
CMKUA Credit data exchange rate for requested delivery date DEC 9 5 CMKUA
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
STCUR Exchange rate for statistics DEC 9 5 STCUR
NETPR Net Price CURR 11 2 NETPR
VGTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
PS_POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
NETWR Net Value of the Order Item in Document Currency CURR 15 2 NETWR_AP
WAVWR Cost in Document Currency CURR 13 2 WAVWR
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
ZWERT Target Value for Outline Agreement in Document Currency CURR 13 2 DZWERT
ZMENG Target Quantity in Sales Units QUAN 13 3 DZMENG
KWMENG Cumulative order quantity in sales units QUAN 15 3 KWMENG
LSMENG Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines) QUAN 15 3 LSMENG
KBMENG Cumulative Confirmed Quantity in Sales Unit QUAN 15 3 KBMENG
KLMENG Cumulative Confirmed Quantity in Base Unit QUAN 15 3 KLMENG
LFMNG Minimum Delivery Quantity in Delivery Note Processing QUAN 13 3 MINLF
BRGEW Gross Weight of the Item QUAN 15 3 BRGEW_AP
NTGEW Net Weight of the Item QUAN 15 3 NTGEW_AP
VOLUM Volume of the item QUAN 15 3 VOLUM_AP
ANZAU Number of Orders DEC 9 0 MC_ANZAU
ANZAUPOS Number of Order Items DEC 9 0 MC_ANZAUPO
ETTYP Schedule line category CHAR 2 0 * ETTYP
LIFSP Schedule Line Blocked for Delivery CHAR 2 0 * LIFSP_EP
LDDAT Loading Date DATS 8 0 LDDAT
TDDAT Transportation Planning Date DATS 8 0 TDDAT_D
EDATU Schedule line date DATS 8 0 EDATU
WADAT Goods Issue Date DATS 8 0 WADAT
MBDAT Material Staging/Availability Date DATS 8 0 MBDAT
WLDATBE Desired del. date in confirmed schedule lines DATS 8 0 WLDATBE
WMENG Order Quantity in Sales Units QUAN 13 3 WMENG
LMENG Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
BMENG Confirmed Quantity QUAN 13 3 BMENG
CMENG Corrected quantity in sales unit QUAN 13 3 CMENG

S260 foreign key relationships

Table Field Check Table Check Field
0 S260 ETENR VBEP Sales Document: Schedule Line Data MANDT
0 S260 ETENR VBEP Sales Document: Schedule Line Data VBELN
0 S260 ETENR VBEP Sales Document: Schedule Line Data POSNR
0 S260 ETENR VBEP Sales Document: Schedule Line Data ETENR
1 S260 KUNNR KNA1 General Data in Customer Master MANDT
1 S260 KUNNR KNA1 General Data in Customer Master KUNNR
0 S260 VRKME T006 Units of Measurement MANDT
0 S260 VRKME T006 Units of Measurement MSEHI
1 S260 WAERK TCURC Currency Codes MANDT
1 S260 WAERK TCURC Currency Codes WAERS