SAP Table S014

CAS Document Information

S014 (CAS Document Information) 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 S014 to other SAP tables.

S014 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
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 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
PERIV Fiscal Year Variant PERIV CHAR 2 0
VWDAT Pointer to administrative data VWDAT NUMC 10 0
STWAE Statistics currency STWAE CUKY 5 0
MIN_VALUE Lowest document value MIN_VALUE CURR 17 2
MAX_VALUE Highest doc.value MAX_VALUE CURR 17 2
DELTA_VAL Mean value of documents DELTA_VAL CURR 17 2
SUM_VALUE Total document value SUM_VALUE CURR 17 2
OFF_VALUE Open value OFF_VALUE CURR 17 2
OFF_COUNT Number of open documents OFF_COUNT DEC 9 0
OFF_POSI Number of open document items OFF_POSI DEC 9 0
BEL_COUNT Number of documents BEL_COUNT DEC 9 0
POSI_COUNT Number of line items POSI_COUNT DEC 9 0

S014 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
S014 KUNNR S014 MANDT KNA1 General Data in Customer Master MANDT
S014 KUNNR S014 KUNNR KNA1 General Data in Customer Master KUNNR
S014 SPART S014 SPART TSPA Organizational Unit: Sales Divisions SPART
S014 SPART S014 MANDT TSPA Organizational Unit: Sales Divisions MANDT
S014 VKORG S014 MANDT TVKO Organizational Unit: Sales Organizations MANDT
S014 VKORG S014 VKORG TVKO Organizational Unit: Sales Organizations VKORG
S014 VTWEG S014 MANDT TVTW Organizational Unit: Distribution Channels MANDT
S014 VTWEG S014 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG