SAP table S009 (CAS: Last Documents)

SAP table S009 has 12 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,VKORG,VTWEG,SPART,KUNNR,VBTYP.

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
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TVTA SPART
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
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
VWDAT Pointer to administrative data NUMC 10 0 VWDAT
BEL01 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL02 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL03 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL04 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL05 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL06 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL07 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL08 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL09 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL10 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL11 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL12 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL13 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL14 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL15 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL16 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL17 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL18 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL19 Sales and Distribution Document Number CHAR 10 0 * VBELN
BEL20 Sales and Distribution Document Number CHAR 10 0 * VBELN

S009 foreign key relationships

Table Field Check Table Check Field
0 S009 KUNNR KNA1 General Data in Customer Master MANDT
0 S009 KUNNR KNA1 General Data in Customer Master KUNNR
1 S009 SPART TVTA Organizational Unit: Sales Area(s) MANDT
1 S009 SPART TVTA Organizational Unit: Sales Area(s) VKORG
1 S009 SPART TVTA Organizational Unit: Sales Area(s) VTWEG
1 S009 SPART TVTA Organizational Unit: Sales Area(s) SPART
0 S009 VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 S009 VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 S009 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 S009 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG