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