SAP Table S008

Communications Table SD -> CO/Projects

S008 (Communications Table SD -> CO/Projects) 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 S008 to other SAP tables.

S008 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT 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 and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
ETENR Delivery Schedule Line Number ETENR VBEP NUMC 4 0
FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
KSCHL Condition type KSCHA CHAR 4 0
STUNR Step number STUNR NUMC 3 0
ZAEHK Condition counter DZAEHK NUMC 2 0
ALTNEU Statistics update indicator (post in/post out) SUPKZ CHAR 1 0
1 Old status: charge off (negative posting)
2 New status: record
3 Standard item in a return (SD only)
0 Returns item in standard order (SD only)
FKART Billing Type FKART CHAR 4 0
FKTYP Billing category FKTYP CHAR 1 0
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
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
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
PERIV Fiscal Year Variant PERIV CHAR 2 0
BUKRS Company Code BUKRS CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
KUNAG Sold-to party KUNAG CHAR 10 0
ANGDT Quotation/Inquiry is valid from ANGDT_V DATS 8 0
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
ABSTA Release status (current release, old release) ABSTA CHAR 1 0
ERLMENGE_L Completed quantity (delivery) ERLMENGE_L QUAN 13 3
ERLMENGE_F Invoiced quantity in basic unit of measure ERLMENGE_F QUAN 13 3
MATNR Material Number MATNR CHAR 18 0
FKREL Relevant for Billing FKREL CHAR 1 0
NULL 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)
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
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
MATWA Material entered MATWA MARA CHAR 18 0
PMATN Pricing Reference Material PMATN MARA CHAR 18 0
KBVER Allowed deviation in quantity (in percent) KBVER DEC 3 0
KEVER Days by which the quantity can be shifted KEVER DEC 3 0
STDAT Key date of the bill of material STDAT DATS 8 0
STLNR Bill of material STNUM CHAR 8 0
STPOS Bill of material item number STPOS_D DEC 4 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
SPART Division SPART CHAR 2 0
WERKS Plant WERKS_D CHAR 4 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
KDGRP Customer group KDGRP CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
LAND1 Country of Destination LLAND CHAR 3 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
BONUS Volume rebate group BONUS CHAR 2 0
PROVG Commission group PROVG CHAR 2 0
VKGRP Sales Group VKGRP CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
FBUDA Date on which services rendered FBUDA DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WADAT Goods Issue Date WADAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
AUBEL Sales Document VBELN_VA VBUK CHAR 10 0
AUPOS Sales Document Item POSNR_VA VBUP NUMC 6 0
VGBEL Document number of the reference document VGBEL VBUK CHAR 10 0
VGPOS Item number of the reference item VGPOS VBUP NUMC 6 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
KOSTL Cost Center KOSTL CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 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
KWMENG Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
ZMENG Target quantity in sales units DZMENG QUAN 13 3
ZIEME Target quantity UoM DZIEME UNIT 3 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
FKIMG Actual Invoiced Quantity FKIMG QUAN 13 3
LFIMG Actual quantity delivered (in sales units) LFIMG QUAN 13 3
VRKME Sales unit VRKME UNIT 3 0
FKLMG Billing quantity in stockkeeping unit FKLMG QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
LMENG Required quantity for mat.management in stockkeeping units LMENG QUAN 13 3
BDDAT Requirement date (deadline for procurement) BDDAT DATS 8 0
WMENG Order quantity in sales units WMENG QUAN 13 3
BMENG Confirmed Quantity BMENG QUAN 13 3
KAPPL Application KAPPL T681A CHAR 2 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ 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
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Input Tax not Deductible
O Variants
P Base amount including tax
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
a Reserved (fixed extra pay)
b Transfer Price for Group Valuation
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
KWERT Condition value KWERT CURR 13 2
WAERK Currency Key WAERS CUKY 5 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
KWERH Condition value in local currency KWERH CURR 13 2
HWAER Local Currency HWAER CUKY 5 0
SAKN1 G/L Account Number SAKNR CHAR 10 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
OBJNR Object number at item level OBJPO CHAR 22 0
AUART Sales Document Type AUART CHAR 4 0
GRPOS Item for which this item is an alternative GRPOS NUMC 6 0
VBELV Originating document VBELV CHAR 10 0
POSNV Originating item POSNV NUMC 6 0
ERLMENGE Quantity for completion (sales) in basic unit of measure ERLMENGE QUAN 13 3
FAREG Rule in billing plan/invoice plan FAREG CHAR 1 0
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 FPROZ DEC 5 2

S008 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
S008 AUBEL S008 AUBEL VBUK Sales Document: Header Status and Administrative Data VBELN
S008 AUBEL S008 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
S008 AUFNR S008 MANDT AUFK Order master data MANDT
S008 AUFNR S008 AUFNR AUFK Order master data AUFNR
S008 AUPOS S008 AUPOS VBUP Sales Document: Item Status POSNR
S008 AUPOS S008 MANDT VBUP Sales Document: Item Status MANDT
S008 AUPOS S008 AUBEL VBUP Sales Document: Item Status VBELN
S008 ETENR S008 MANDT VBEP Sales Document: Schedule Line Data MANDT
S008 ETENR S008 VBELN VBEP Sales Document: Schedule Line Data VBELN
S008 ETENR S008 POSNR VBEP Sales Document: Schedule Line Data POSNR
S008 ETENR S008 ETENR VBEP Sales Document: Schedule Line Data ETENR
S008 KAPPL S008 KAPPL T681A Conditions: Applications KAPPL
S008 MATWA S008 MATWA MARA General Material Data MATNR
S008 MATWA S008 MANDT MARA General Material Data MANDT
S008 PMATN S008 MANDT MARA General Material Data MANDT
S008 PMATN S008 PMATN MARA General Material Data MATNR
S008 PS_PSP_PNR S008 MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
S008 PS_PSP_PNR S008 PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
S008 VGBEL S008 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
S008 VGBEL S008 VGBEL VBUK Sales Document: Header Status and Administrative Data VBELN
S008 VGPOS S008 MANDT VBUP Sales Document: Item Status MANDT
S008 VGPOS S008 VGBEL VBUP Sales Document: Item Status VBELN
S008 VGPOS S008 VGPOS VBUP Sales Document: Item Status POSNR