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
⤷ 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 |