SAP ABAP Table ACCTSD (Interface: Sales Order -> Accounting)
Hierarchy
☛
SRM_PLUS (Software Component) SRM_PLUS for mySAP SRM
⤷ SRM-EBP-TEC-MW (Application Component) Middleware
⤷ ACID (Package) Package for Copied IDOC Objects
⤷ SRM-EBP-TEC-MW (Application Component) Middleware
⤷ ACID (Package) Package for Copied IDOC Objects
Basic Data
Table Category | INTTAB | Structure |
Structure | ACCTSD | Table Relationship Diagram |
Short Description | Interface: Sales Order -> Accounting |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | Key: FI/CO Document Header | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
4 | AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
5 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
6 | AWSYS | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
7 | VRGNG | CO_VORGANG | J_VORGANG | CHAR | 4 | 0 | CO Business Transaction | * | |
8 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
9 | AWTYP2 | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
10 | AWREF2 | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
11 | AWORG2 | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
12 | AWPOS | AWPOS | AWPOS | CHAR | 10 | 0 | Reference line item | ||
13 | AWID2 | AWID | AWID | CHAR | 10 | 0 | Reference document: Current identification | ||
14 | VRGNG2 | CO_VORGANG | J_VORGANG | CHAR | 4 | 0 | CO Business Transaction | * | |
15 | ORVTP | ORVTP | ORVTP | CHAR | 1 | 0 | Value type of purchase order/sales order values | ||
16 | AWTYP_R | AWTYP_PRE | AWTYP | CHAR | 5 | 0 | Previous document: Reference procedure | * | |
17 | AWREF_R | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
18 | AWORG_R | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
19 | AWPOS_R | AWPOS | AWPOS | CHAR | 10 | 0 | Reference line item | ||
20 | WRBTR | WTGXXO | WERTV8 | CURR | 15 | 2 | Original value in transaction currency | ||
21 | WRBTROP | WTGXOP | WERTV8 | CURR | 15 | 2 | Open Remaining Amount in Transaction Currency | ||
22 | OAUMEOP | MC_OAUME | MENGV15_3 | QUAN | 15 | 3 | Open orders quantity in base unit of measure | ||
23 | BASME | BASME | MEINS | UNIT | 3 | 0 | Base Unit of Measure for BOM | T006 | |
24 | SKONTO | MC_SKONTO | WERTV10 | CURR | 19 | 2 | Cash management and forecast: cash discount | ||
25 | SKFBT | KAWRT | WERTV8 | CURR | 15 | 2 | Condition Basis | ||
26 | STEUERN | MC_STEUER | WERTV10 | CURR | 19 | 2 | Cash management and forecast: taxes | ||
27 | TWAER | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | * | |
28 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
29 | KURSF | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
30 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
31 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
32 | ZBD1T | DZBD1T | ZBDXT | DEC | 3 | 0 | Cash discount days 1 | ||
33 | ZBD2T | DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
34 | ZBD3T | DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
35 | ZBD1P | DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
36 | ZBD2P | DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
37 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
38 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
39 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
40 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
41 | LOEKZ | QGEL | QKZ | CHAR | 1 | 0 | Data Record Was Deleted | ||
42 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
43 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
44 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
45 | SAKNR | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
46 | PSPNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
47 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
48 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
49 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
50 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
51 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
52 | DELTA | ACCTSD_DELTA | QKZ | CHAR | 1 | 0 | Delta Posting for FI/CO Interface Sales Order | ||
53 | FPLTR | FPLTR | FPLTR | NUMC | 6 | 0 | Item for billing plan/invoice plan/payment cards | * | |
54 | ETENR | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
55 | AWPOS_DP | AWPOS | AWPOS | CHAR | 10 | 0 | Reference line item | ||
56 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
57 | .INCLUDE | 0 | 0 | CO-PA: Fields (Characteristics, Values) | |||||
58 | RKE_ARTNR | ARTNR | MATNR | CHAR | 18 | 0 | Product number | * | |
59 | RKE_BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
60 | RKE_FKART | FKART | FKART | CHAR | 4 | 0 | Billing Type | * | |
61 | RKE_GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
62 | RKE_KAUFN | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
63 | RKE_KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
64 | RKE_KMBRND | RKESKMBRND | RKESKMBRND | NUMC | 2 | 0 | Brand | ||
65 | RKE_KMCATG | RKESKMCATG | RKESKMCATG | NUMC | 2 | 0 | Business field | * | |
66 | RKE_KMHI01 | HIEZU01 | KUNNR | CHAR | 10 | 0 | Customer hierarchy Level 1 | * | |
67 | RKE_KMHI02 | HIEZU02 | KUNNR | CHAR | 10 | 0 | Customer hierarchy Level 2 | * | |
68 | RKE_KMHI03 | HIEZU03 | KUNNR | CHAR | 10 | 0 | Customer hierarchy Level 3 | * | |
69 | RKE_KMKDGR | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
70 | RKE_KMLAND | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | * | |
71 | RKE_KMMAKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
72 | RKE_KMNIEL | NIELS | NIELS | CHAR | 2 | 0 | Nielsen ID | * | |
73 | RKE_KMSTGE | RKESKMSTGE | RKESKMSTGE | NUMC | 2 | 0 | Strategic Business Unit | * | |
74 | RKE_KMVKBU | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
75 | RKE_KMVKGR | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
76 | RKE_KMVTNR | VRTNR | PERNR | NUMC | 8 | 0 | Sales employee | ||
77 | RKE_KNDNR | KUNDE_PA | KUNNR | CHAR | 10 | 0 | Customer | * | |
78 | RKE_KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
79 | RKE_KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
80 | RKE_KWABFK | RKESKWABFK | WERTV8 | CURR | 15 | 2 | Variance: Shipment Costs | ||
81 | RKE_KWABLG | RKESKWABLG | WERTV8 | CURR | 15 | 2 | Lot size variance | ||
82 | RKE_KWABLK | RKESKWABLK | WERTV8 | CURR | 15 | 2 | Idle-Capacity Costs | ||
83 | RKE_KWABMG | RKESKWABMG | WERTV8 | CURR | 15 | 2 | Quantity Variance | ||
84 | RKE_KWABPR | RKESKWABPR | WERTV8 | CURR | 15 | 2 | Price Variance | ||
85 | RKE_KWABSG | RKESKWABSG | WERTV8 | CURR | 15 | 2 | Other variances | ||
86 | RKE_KWABST | RKESKWABST | WERTV8 | CURR | 15 | 2 | Resource-Usage Variance | ||
87 | RKE_KWAKRB | RKESKWAKRB | WERTV8 | CURR | 15 | 2 | Special offer discount | ||
88 | RKE_KWBONI | RKESKWBONI | WERTV8 | CURR | 15 | 2 | Bonuses | ||
89 | RKE_KWBRUM | RKESKWBRUM | WERTV8 | CURR | 15 | 2 | Gross sales | ||
90 | RKE_KWFKFX | RKESKWFKFX | WERTV8 | CURR | 15 | 2 | Fixed Manufacturing Costs | ||
91 | RKE_KWFKVA | RKESKWFKVA | WERTV8 | CURR | 15 | 2 | Variable Production Costs | ||
92 | RKE_KWFOEN | RKESKWFOEN | WERTV8 | CURR | 15 | 2 | Research and Development | ||
93 | RKE_KWKDRB | RKESKWKDRB | WERTV8 | CURR | 15 | 2 | Customer Discount | ||
94 | RKE_KWKLFK | RKESKWKLFK | WERTV8 | CURR | 15 | 2 | Accrued shipment costs | ||
95 | RKE_KWLOGI | RKESKWLOGI | WERTV8 | CURR | 15 | 2 | Logistics | ||
96 | RKE_KWMAEK | RKESKWMAEK | WERTV8 | CURR | 15 | 2 | Direct Material Costs | ||
97 | RKE_KWMAGK | RKESKWMAGK | WERTV8 | CURR | 15 | 2 | Material overhead costs | ||
98 | RKE_KWMARB | RKESKWMARB | WERTV8 | CURR | 15 | 2 | Material discount | ||
99 | RKE_KWMGRB | RKESKWMGRB | WERTV8 | CURR | 15 | 2 | Quantity discount | ||
100 | RKE_KWMKAD | RKESKWMKAD | WERTV8 | CURR | 15 | 2 | Advertising | ||
101 | RKE_KWMKDP | RKESKWMKDP | WERTV8 | CURR | 15 | 2 | Marketing Department | ||
102 | RKE_KWMKPR | RKESKWMKPR | WERTV8 | CURR | 15 | 2 | Promotion | ||
103 | RKE_KWSKTO | RKESKWSKTO | WERTV8 | CURR | 15 | 2 | Cash discount | ||
104 | RKE_KWSVME | RKESKWSVME | MENGV15_3 | QUAN | 15 | 3 | Sales quantity | ||
105 | RKE_KWSVME_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
106 | RKE_KWVERW | RKESKWVERW | WERTV8 | CURR | 15 | 2 | Administration Costs | ||
107 | RKE_KWVKPV | RKESKWVKPV | WERTV8 | CURR | 15 | 2 | Sales commission | ||
108 | RKE_KWVSEK | RKESKWVSEK | WERTV8 | CURR | 15 | 2 | Sales Special Direct Costs | ||
109 | RKE_KWVTAD | RKESKWVTAD | WERTV8 | CURR | 15 | 2 | Sales field service | ||
110 | RKE_KWVTID | RKESKWVTID | WERTV8 | CURR | 15 | 2 | Sales office | ||
111 | RKE_PPRCTR | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
112 | RKE_PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
113 | RKE_PSPNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
114 | RKE_RKAUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
115 | RKE_SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
116 | RKE_VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
117 | RKE_VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
118 | RKE_WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
119 | RKE_ABSMG | RKE2_ABSMG | MENGV15_3 | QUAN | 15 | 3 | Sales quantity | ||
120 | RKE_ABSMG_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
121 | RKE_AUSFR | RKE2_AUSFR | WERTV8 | CURR | 15 | 2 | Outgoing freight | ||
122 | RKE_BONUS | BONUS | BONUS | CHAR | 2 | 0 | Volume rebate group | * | |
123 | RKE_BRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | * | |
124 | RKE_BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
125 | RKE_EFORM | RKEG_EFORM | RKEG_EFORM | CHAR | 5 | 0 | Form of manufacture | * | |
126 | RKE_ERLOS | RKE2_ERLOS | WERTV8 | CURR | 15 | 2 | Revenue | ||
127 | RKE_GEBIE | RKEG_GEBIE | RKEG_GEBIE | CHAR | 4 | 0 | Area | * | |
128 | RKE_KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
129 | RKE_LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | * | |
130 | RKE_MAABC | MAABC | MAABC | CHAR | 1 | 0 | ABC indicator | * | |
131 | RKE_MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
132 | RKE_MRABA | RKE2_MRABA | WERTV8 | CURR | 15 | 2 | Quantity discount | ||
133 | RKE_PRABA | RKE2_PRABA | WERTV8 | CURR | 15 | 2 | Price reduction | ||
134 | RKE_PROVV | RKE2_PROVV | WERTV8 | CURR | 15 | 2 | External Sales Commission | ||
135 | RKE_RABAT | RKE2_RABAT | WERTV8 | CURR | 15 | 2 | Other discounts | ||
136 | RKE_UMSLZ | RKE2_UMSLZ | WERTV8 | CURR | 15 | 2 | Licensing Fees | ||
137 | RKE_VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
138 | RKE_VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
139 | RKE_VRPRS | RKE2_VRPRS | WERTV8 | CURR | 15 | 2 | Stock Value | ||
140 | RKE_VSVP | RKE2_VSVP | WERTV8 | CURR | 15 | 2 | Dispatch Packaging | ||
141 | RKE_VTRGK | RKE2_VTRGK | WERTV8 | CURR | 15 | 2 | Sales overhead costs | ||
142 | RKE_VWGK | RKE2_VWGK | WERTV8 | CURR | 15 | 2 | Administration Overhead Costs | ||
143 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
144 | .INCLUDE | 0 | 0 | Fields for fund management in the Public Sector | |||||
145 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
146 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
147 | FPLNR | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
148 | FAREG | FAREG | FAREG | CHAR | 1 | 0 | Rule in billing plan/invoice plan | ||
149 | WRBTR_OPFM | WTGXOPFI | WERTV8 | CURR | 15 | 2 | Open Remaining Amount in Trans. Currency, Reduction via FI | ||
150 | KWMENG_D | KWMENG | MENG15 | QUAN | 15 | 3 | Cumulative order quantity in sales units | ||
151 | FKIMG | FKIMG | MENG13 | QUAN | 13 | 3 | Actual billed quantity | ||
152 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
153 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | * | |
154 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
155 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
156 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
157 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
158 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
159 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
160 | ABGRU | ABGRU | ABGRU | CHAR | 2 | 0 | Reason for rejection of quotations and sales orders | ||
161 | PSM_BUDAT | PSM_BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
162 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
163 | .INCLU--AP | 0 | 0 | OLC: Append Structure for Transaction Number | |||||
164 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
165 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
166 | .INCLU--AP | 0 | 0 | Append for Operation Level Costing | |||||
167 | AUFPL_OAA | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
168 | APLZL_OAA | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
169 | .INCLU--AP | 0 | 0 | FMFG Additional fields for structure | |||||
170 | FMFGUS_KEY | FMFG_US_KEY | SYSUUID_22 | CHAR | 22 | 0 | United States Federal Government Fields |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ACCTSD | BASME | T006 | MSEHI | C | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |