SAP table S008 (Communications Table SD -> CO/Projects)

SAP table S008 has 16 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,VBELN,POSNR,ETENR,FPLNR,FPLTR,KSCHL,STUNR,ZAEHK,ALTNEU.

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 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 and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
ETENR Schedule Line Number NUMC 4 0 VBEP ETENR
FPLNR Billing plan number / invoicing plan number CHAR 10 0 FPLNR
FPLTR Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
KSCHL Condition Type CHAR 4 0 KSCHA
STUNR Step Number NUMC 3 0 STUNR
ZAEHK Condition Counter NUMC 3 0 DZAEHK
ALTNEU Statistics update indicator (post in/post out) CHAR 1 0 SUPKZ
0 Returns item in standard order (SD only)
1 Old status: charge off (negative posting)
2 New status: record
3 Standard item in a return (SD only)
FKART Billing Type CHAR 4 0 FKART
FKTYP Billing Category CHAR 1 0 FKTYP
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
S CRM Billing Document
U Billing request
W POS billing document
X Billing using general interface
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)
PERIV Fiscal Year Variant CHAR 2 0 PERIV
BUKRS Company Code CHAR 4 0 BUKRS
GSBER Business Area CHAR 4 0 GSBER
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
KUNAG Sold-to Party CHAR 10 0 KUNAG
ANGDT Quotation/Inquiry is Valid From DATS 8 0 ANGDT_V
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To Date) DATS 8 0 BNDDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 13 2 SKFBT_CS
ABSTA Release status (current release, old release) CHAR 1 0 ABSTA
ERLMENGE_L Completed quantity (delivery) QUAN 13 3 ERLMENGE_L
ERLMENGE_F Invoiced quantity in basic unit of measure QUAN 13 3 ERLMENGE_F
MATNR Material Number CHAR 40 0 MATNR
FKREL Relevant for Billing CHAR 1 0 FKREL
Not relevant for billing
A Delivery-related billing document
B Relevant for order-related billing - status acc.to order qty
C Relevant for ord.-related billing - status acc.to target qty
D Relevant for pro forma
F Order-related billing doc. - status according to invoice qty
G Order-related billing of the delivery quantity
H Delivery-related billing - no zero quantities
I Order-relevant billing - billing plan
J Relevant for deliveries across EU countries
K Delivery-related invoices for partial quantity
L Pro forma - no zero quantities
M Delivery-related invoices-no zero qtys (incl main batch itm)
N Pro forma - no zero quantities (including main batch items)
O Delivery-rel. invoices for partial quantity - No zero qtys
P Delivery-related invoices for CSFG - No batch split items
Q Delivery-related invoices for CRM
R Delivery-related invoices for CRM - No zero quantities
S IBS-DI: Order-Related Bill. Doc. with DP w/o Billing Plan
T Delivery-Related Invoices for CRM with IB in CRM
U Delivery-Rel. Invoices for CRM with IB in CRM - No Zero Qtys
V Delivery-Related ICB of Stock Transport Orders in CRM
W Delivery-Rel. ICB of StTransportOrders in CRM - No Zero Qtys
X Billing request related via an order related billing plan
Y Intercompany billing – delivery-related invoice
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
MATWA Material Entered CHAR 40 0 MARA MATWA
PMATN Pricing Reference Material CHAR 40 0 MARA PMATN
KBVER Allowed deviation in quantity (in percent) DEC 3 0 KBVER
KEVER Days by which the quantity can be shifted DEC 3 0 KEVER
STDAT Key date of the bill of material DATS 8 0 STDAT
STLNR Bill of Material CHAR 8 0 STNUM
STPOS Bill of material item number DEC 4 0 STPOS_D
AWAHR Order Probability of the Item NUMC 3 0 AWAHR
000 Sales order probability
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
SPART Division CHAR 2 0 SPART
WERKS Plant CHAR 4 0 WERKS_D
FKDAT Billing Date DATS 8 0 FKDAT
KDGRP Customer Group CHAR 2 0 KDGRP
BZIRK Sales District CHAR 6 0 BZIRK
LAND1 Destination Country/Region CHAR 3 0 LLAND
REGIO Region (State, Province, County) CHAR 3 0 REGIO
COUNC County Code CHAR 3 0 COUNC
CITYC City Code CHAR 4 0 CITYC
BONUS Volume rebate group CHAR 2 0 BONUS
PROVG Commission Group CHAR 2 0 PROVG
VKGRP Sales group CHAR 3 0 VKGRP
VKBUR Sales office CHAR 4 0 VKBUR
FBUDA Date on which services are rendered DATS 8 0 FBUDA
BUDAT Posting Date in the Document DATS 8 0 BUDAT
WADAT Goods Issue Date DATS 8 0 WADAT
BLDAT Document Date in Document DATS 8 0 BLDAT
AUBEL Sales Document CHAR 10 0 VBELN_VA
AUPOS Sales Document Item NUMC 6 0 POSNR_VA
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
KOSTL Cost Center CHAR 10 0 KOSTL
PRCTR Profit Center CHAR 10 0 PRCTR
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
KWMENG Cumulative order quantity in sales units QUAN 15 3 KWMENG
ZMENG Target Quantity in Sales Units QUAN 13 3 DZMENG
ZIEME Target Quantity UoM UNIT 3 0 DZIEME
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
FKIMG Actual billed quantity QUAN 13 3 FKIMG
LFIMG Actual quantity delivered (in sales units) QUAN 13 3 LFIMG
VRKME Sales unit UNIT 3 0 VRKME
FKLMG Billing quantity in stock keeping unit QUAN 13 3 FKLMG
MEINS Base Unit of Measure UNIT 3 0 MEINS
LMENG Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
BDDAT Requirement date (deadline for procurement) DATS 8 0 BDDAT
WMENG Order Quantity in Sales Units QUAN 13 3 WMENG
BMENG Confirmed Quantity QUAN 13 3 BMENG
KAPPL Application CHAR 2 0 T681A KAPPL
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 KALSM_D
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
KWERT Condition Value CURR 13 2 KWERT
WAERK Currency Key CUKY 5 0 WAERS
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
KWERH Condition value in local currency CURR 13 2 KWERH
HWAER Local Currency CUKY 5 0 HWAER
SAKN1 G/L Account Number CHAR 10 0 SAKNR
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
OBJNR Object Number at Item Level CHAR 22 0 OBJPO
AUART Sales Document Type CHAR 4 0 AUART
GRPOS Item for Which this Item is an Alternative NUMC 6 0 GRPOS
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
ERLMENGE Quantity for completion (sales) in basic unit of measure QUAN 13 3 ERLMENGE
FAREG Rule in billing plan/invoice plan CHAR 1 0 FAREG
1 Milestone billing on a percentage basis
2 Milestone billing on a value basis
3 Closing invoice in milestone billing
4 Down payment in milestone billing on percentage basis
5 Down payment in milestone billing on a value basis
6 Periodic billing (rent)
FPROZ Percentage of value to be invoiced DEC 5 2 FPROZ

S008 foreign key relationships

Table Field Check Table Check Field
0 S008 AUFNR AUFK Order master data AUFNR
1 S008 ETENR VBEP Sales Document: Schedule Line Data MANDT
1 S008 ETENR VBEP Sales Document: Schedule Line Data VBELN
1 S008 ETENR VBEP Sales Document: Schedule Line Data POSNR
1 S008 ETENR VBEP Sales Document: Schedule Line Data ETENR
0 S008 KAPPL T681A Conditions: Applications KAPPL
1 S008 MATWA MARA General Material Data MATNR
0 S008 PMATN MARA General Material Data MATNR
1 S008 PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 S008 PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR