SAP ABAP Table S007 (Communications Table SD -> CO-PA)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category INTTAB    Structure 
Structure S007   Table Relationship Diagram
Short Description Communications Table SD -> CO-PA    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 WAERK WAERS WAERS CUKY 5   0   Currency Key *
9 VRKME VRKME MEINS UNIT 3   0   Sales unit *
10 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
11 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
12 VOLEH VOLEH MEINS UNIT 3   0   Volume unit *
13 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
14 SUPKZ SUPKZ SUPKZ CHAR 1   0   Statistics update indicator (post in/post out)  
15 VBELN VBELN VBELN CHAR 10   0   Sales and Distribution Document Number *
16 POSNR POSNR POSNR NUMC 6   0   Item number of the SD document *
17 ETENR ETENR ETENR NUMC 4   0   Schedule line *
18 FPLNR FPLNR FPLNR CHAR 10   0   Billing plan number / invoicing plan number FPLA
19 FPLTR FPLTR FPLTR NUMC 6   0   Item for billing plan/invoice plan/payment cards FPLT
20 KSCHL KSCHA KSCHL CHAR 4   0   Condition Type *
21 STUNR STUNR STUNR NUMC 3   0   Level Number *
22 ZAEHK DZAEHK ZAEHK NUMC 2   0   Condition counter  
23 FKART FKART FKART CHAR 4   0   Billing Type *
24 FKTYP FKTYP FKTYP CHAR 1   0   Billing Category  
25 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
26 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
27 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
28 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
29 GSBER GSBER GSBER CHAR 4   0   Business Area *
30 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
31 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
32 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
33 MATNR MATNR MATNR CHAR 18   0   Material Number *
34 SPART SPART SPART CHAR 2   0   Division *
35 WERKS WERKS_D WERKS CHAR 4   0   Plant *
36 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
37 KDGRP KDGRP KDGRP CHAR 2   0   Customer group *
38 BZIRK BZIRK BZIRK CHAR 6   0   Sales district *
39 LAND1 LLAND LAND1 CHAR 3   0   Destination Country *
40 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
41 COUNC COUNC COUNC CHAR 3   0   County Code *
42 CITYC CITYC CITYC CHAR 4   0   City Code *
43 BONUS BONUS BONUS CHAR 2   0   Volume rebate group *
44 PROVG PROVG PROVG CHAR 2   0   Commission group *
45 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
46 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
47 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
48 AUBEL VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
49 AUPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
50 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
51 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
52 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
53 FKIMG FKIMG MENG13 QUAN 13   3   Actual billed quantity  
54 FKLMG FKLMG MENG13 QUAN 13   3   Billing quantity in stockkeeping unit  
55 KAPPL KAPPL KAPPL CHAR 2   0   Application *
56 KALSM KALSM_D KALSM CHAR 6   0   Procedure (Pricing, Output Control, Acct. Det., Costing,...) *
57 KNTYP KNTYP KNTYP CHAR 1   0   Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost  
58 KWERT KWERT WERTV7 CURR 13   2   Condition Value  
59 FAKWR FAKWR WERTV8 CURR 15   2   Value to be billed/calc. on date in billing/invoice plan  
60 NETWR NETWR WERTV8 CURR 15   2   Net Value in Document Currency  
61 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
62 KWERH KWERH WERTV7 CURR 13   2   Condition value in local currency  
63 HWAER HWAER WAERS CUKY 5   0   Local Currency *
64 SAKN1 SAKNR SAKNR CHAR 10   0   G/L Account Number *
65 KZZUAB SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
66 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
67 VBELV VBELV VBELN CHAR 10   0   Originating document *
68 GLXDOCNR DOCNR BELNR CHAR 10   0   Doc. Number  
69 GLXDOCLN DOCLN DOCLN CHAR 3   0   Document line  
70 PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
71 KINAK KINAK KINAK CHAR 1   0   Condition is inactive  
72 KSTAT KSTAT XFELD CHAR 1   0   Condition is used for statistics  
73 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
74 ERZET ERZET UZEIT TIMS 6   0   Entry time  
75 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
76 KOAID KOAID KOAID CHAR 1   0   Condition class  
77 NTGEW NTGEW_15 MENG15 QUAN 15   3   Net weight  
78 BRGEW BRGEW_15 MENG15 QUAN 15   3   Gross weight  
79 VOLUM VOLUM_15 MENG15 QUAN 15   3   Volume  
80 SFAKN SFAKN VBELN CHAR 10   0   Cancelled billing document number *
81 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
82 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
83 .INCLUDE       0   0   Partner Field String from VBPA  
84 PKUNAG KUNAG KUNNR CHAR 10   0   Sold-to party *
85 PKUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
86 PKUNRE KUNRE KUNNR CHAR 10   0   Bill-to party *
87 PKUNRG KUNRG KUNNR CHAR 10   0   Payer *
88 PSPDNR SPDNR LIFNR CHAR 10   0   Carrier *
89 PVRTNR VRTNR PERNR NUMC 8   0   Sales employee  
90 PLAAG PLAAG LAND1 CHAR 3   0   Country of the sold-to party *
91 PLAWE PLAWE LAND1 CHAR 3   0   Country of ship-to party *
92 PLARE PLARE LAND1 CHAR 3   0   Country of the bill-to party *
93 PLARG PLARG LAND1 CHAR 3   0   Country of the payer *
94 PLASP PLASP LAND1 CHAR 3   0   Country of the carrier *
95 PLAVE PLAVE LAND1 CHAR 3   0   Country of the representative *
96 PABLA PABLA TEXT25 CHAR 25   0   Unloading point of the ship-to party  
97 PZONE PZONE ZONE CHAR 10   0   Transportation zone of the ship-to party *
98 .INCLUDE       0   0   User Section: Additional Partner(s) from VBPA  
99 PDUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
100 PZPERS DZPERS PERNR NUMC 8   0   Person responsible  
101 PLAZM PLAZM LAND1 CHAR 3   0   Country of Employee Responsible *
102 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
103 VDATU MC_VDATUM DATUM DATS 8   0   Date of update for statistics updating  
104 KBMENG KBMENG MENG15 QUAN 15   3   Cumulative confirmed quantity in sales unit  
105 KLMENG KLMENG MENG15 QUAN 15   3   Cumulative Confirmed Quantity in Base Unit of Measure  
106 LSMENG LSMENG MENG15 QUAN 15   3   Cumulative Target Delivery Qty (all dlv-relev.sched.lines)  
107 KWMENG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
108 BMENG BMENG MENG13 QUAN 13   3   Confirmed quantity  
109 LMENG LMENG MENG13 QUAN 13   3   Required quantity for mat.management in stockkeeping units  
110 WMENG WMENG MENG13 QUAN 13   3   Order quantity in sales units  
111 ZMENG DZMENG MENG13 QUAN 13   3   Target quantity in sales units  
112 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM *
113 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
114 LOEKZ QGEL QKZ CHAR 1   0   Data Record Was Deleted  
115 EDATU EDATU DATUM DATS 8   0   Schedule line date  
116 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure TTYP
117 AWREF AWREF AWREF CHAR 10   0   Reference document number  
118 AWORG AWORG AWORG CHAR 10   0   Reference organisational units  
119 AWSYS LOGSYSTEM LOGSYS CHAR 10   0   Logical System TBDLS
120 VRGNG CO_VORGANG J_VORGANG CHAR 4   0   CO Business Transaction TJ01
121 ORVTP ORVTP ORVTP CHAR 1   0   Value type of purchase order/sales order values  
122 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
123 DELTA ACCTSD_DELTA QKZ CHAR 1   0   Delta Posting for FI/CO Interface Sales Order  
124 ABDIS ABDIS ABRAB CHAR 1   0   MRP for Release Types  
125 KWMENG_ORG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
126 FAREG FAREG FAREG CHAR 1   0   Rule in billing plan/invoice plan  
127 POSAR POSAR POSAR CHAR 1   0   Item type  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S007 AUBEL VBUK VBELN    
2 S007 AUPOS VBUP POSNR    
3 S007 AWSYS TBDLS LOGSYS    
4 S007 AWTYP TTYP AWTYP    
5 S007 FPLNR FPLA FPLNR    
6 S007 FPLTR FPLT FPLTR    
7 S007 VRGNG TJ01 VRGNG    
History
Last changed by/on SAP  20130529 
SAP Release Created in