| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A501 | ServcAgent/Incoterms | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
2 | A514 | ServcAgent/Ship.type | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
3 | A519 | ServcAgent/Suppl. 3 | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
4 | A589 | Sales org./Distr. Chl/Matl Group/Material | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
5 | A615 | Condition Table for Pricing A615 | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
6 | A616 | Condition Table for Pricing A616 | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
7 | A619 | Condition Table for Pricing A619 | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
8 | A620 | Condition Table for Pricing A620 | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
9 | A634 | Camp. ID/Material | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
10 | A635 | Camp. ID/PH1/PH2/PH3 | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
11 | A636 | Camp. ID/Matl grp 1 | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
12 | A637 | Camp. ID | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
13 | A640 | Sales org./Distr. Chl/Customer/Material/Grid Value | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
14 | A641 | Sales org./Distr. Chl/Material/Grid Value | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
15 | A651 | Camp. ID/Material | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
16 | A652 | Camp. ID/PH1/PH2/PH3 | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
17 | A653 | Camp. ID/Matl grp 1 | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
18 | A700 | Sales org./Distr. Chl/Material/Product ID/Customer | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
19 | A701 | Distr. Chl/Material/Product ID | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
20 | A702 | Sales org./Distr. Chl/Material/Product ID | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
21 | A706 | Distr. Chl/Material/Product ID/Customer | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
22 | A707 | Sales org./Distr. Chl/TG/Material | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
23 | A710 | Surcharge/TradeLane/ServiceType/ContainerTypeSize | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
24 | A711 | Surcharge/TradeLane/ServiceType/POL/ContainerTypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
25 | A712 | Surcharge/TradeLane/ServiceType/POD/ContainerTypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
26 | A720 | Trade Lane/POR - City/POD - City/ServiceType/Cont.TypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
27 | A721 | TradeLane/POR-Countr/POD-Countr/ServiceType/Cont.TypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
28 | A722 | TradeLane/POR - City/POD-Countr/ServiceType/Cont.TypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
29 | A723 | TradeLane/POR-Countr/POD - City/ServiceType/Cont.TypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
30 | A724 | TradeLane/POL/POD/ServiceType/Cont.TypeSize | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
31 | A730 | TradeLane/ServiceType/ContainerTypeSize | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
32 | A731 | TradeLane/ServiceType/POL/ContainerTypeSize | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
33 | A732 | TradeLane/ServiceType/POD/ContainerTypeSize | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
34 | A911 | MProjectID/Material/Sales org. | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
35 | A913 | Material/Customer/Sales org. | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
36 | A914 | Sales org./Material | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
37 | A925 | Camp. ID/Shpg Cond. | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
38 | A926 | Tax code | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
39 | A927 | Plant | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
40 | A928 | Ctrl code | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
41 | A944 | Sales org./Distr. Chl/Mat.pr.grp/Shp.Cond. | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
42 | A945 | Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
43 | A946 | Sales org./Distr. Chl/TG | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
44 | A947 | Sales Org/Distr.Channel/Shipping Conditions | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
45 | A950 | Sales org./Distr. Chl/Customer/PH1/PH2/PH3 | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
46 | A951 | Sales org./Distr. Chl/HierarchyNode/Material | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
47 | A952 | Sales org./Distr. Chl/HierarchyNode/PH1/PH2/PH3 | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
48 | A960 | Sales org./Distr. Chl/Shp.Cond./Dest. Ctry/Region | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
49 | A963 | Sales Org/Distr.Channel/Shipping Conditions | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
50 | A965 | Country/Plant/TaxCl.Mat/TaxCl1Cust | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
51 | A966 | Country/Plant/TaxCl.2Mat/TaxCl2Cust | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
52 | A967 | Material/Plant | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
53 | A968 | Material/Plant/Ship-to | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
54 | A969 | Sales org./Distr. Chl/Division/Customer | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
55 | A990 | CoCode/Dest. Ctry/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
56 | A996 | Sales org./Distr. Chl/Shp.Cond./TG | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
57 | A999 | Camp. ID/Sales org./Distr. Chl/Division/Material | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPChargeback |
58 | A163 | Number/Material | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPCondition Technique |
59 | /SAPCND/T686E | Condition Processing Status | 2 | KBSTAT | Editing status | nvarchar | 2 | 0 | | |
60 | /SAPCND/T686F | Text Processing Status | 2 | KBSTAT | Editing status | nvarchar | 2 | 0 | | |
TOPConditions |
61 | A304 | Material with release status | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
62 | A305 | Customer/material with release status | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
63 | A306 | Price list category/currency/material with release status | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
64 | A307 | Customer with Release Status | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
65 | A350 | Sales org. | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
66 | A352 | ST Code/Post.code/PlntRegion | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
67 | A353 | ST Code/Region/PlntRegion | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
68 | A354 | Country/Region/PlntRegion | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
69 | A355 | Jur. code | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
70 | A356 | Country/PlntRegion/ST Code/TaxCl1Cust/TaxCl.Mat | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
71 | A357 | Country/Plant/Ctrl code | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
72 | A358 | Country/Plant/Ctrl code/Material | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
73 | A359 | Plant/Matl group | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
74 | A363 | Plant/Vendor/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
75 | A367 | Country/Plant/Region/Material | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
76 | A368 | Country/PlntRegion/Region/TaxCl1Cust/TaxCl.Mat | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
77 | A369 | Country/Plant/Ctrl code/TaxCl1Cust | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
78 | A371 | Country/Plant/Ctrl code/Ship-to | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
79 | A372 | Sales org./Ref.doc./Ref.item | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
80 | A523 | Camp. ID/Matl grp 1 | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
81 | A599 | SD doc./Item/Variant | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
82 | A602 | Condition Table for Pricing A602 | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
83 | A631 | Appl./Version/Status | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
84 | A667 | SD Doc./Item/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
85 | A668 | SD Doc./Item/Material/Billable/Grade | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
86 | A669 | SD Doc./Item/Material/Billable/Country | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
87 | A670 | SD Doc./Item/Material/Billable/Country/Grade | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
88 | A671 | SD Doc./Item/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
89 | A740 | SD Doc./Cust.grp.2/POR - City/POD - City/Shpg Cond./Variant | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
90 | A741 | SD Doc./Cust.grp.2/POR-Countr/POD-Countr/Shpg Cond./Variant | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
91 | A742 | SD Doc./Cust.grp.2/POR - City/POD-Countr/Shpg Cond./Variant | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
92 | A743 | SD Doc./Cust.grp.2/POR-Countr/POD - City/Shpg Cond./Variant | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
93 | A744 | SD Doc./Cust.grp.2/POL/POD/Shpg Cond./Variant | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
94 | A755 | Sales Org. D.C. Price Group | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
95 | A796 | ServcAgent/DepPostCde/RecipCntry | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
96 | A797 | ServcAgent/DestCtry/DepPostCde | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
97 | A799 | ServcAgent/DepPostCde/DestCtry/DestRegion | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
98 | A805 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
99 | A810 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest/FreightCl. | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
100 | A815 | ShipmntTyp/ServcAgent/TfZn P.Dep/FreightCl. | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
101 | A816 | ShipmntTyp/ServcAgent/TargPostCd | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
102 | A817 | ShipmntTyp/ServcAgent/TargPostCd/FreightCl. | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
103 | A818 | ShipmntTyp/ServcAgent/DepPostCde | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
104 | A819 | ShipmntTyp/ServcAgent/DepPostCde/FreightCl. | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
105 | A901 | Sales org./Distr. Chl/Sold-to pt/Region | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
106 | A907 | Sales org./Distr. Chl/Sold-to pt | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
107 | A909 | Sales org./Distr. Chl/Sold-to pt/Incoterms/Inco. 2 | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
108 | A910 | Sales org./Distr. Chl/Ship-to/Incoterms/Inco. 2 | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
109 | A915 | Sales org./Distr. Chl/Matl Group | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
110 | A920 | Organisation/Practice/Grade | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
111 | A921 | Organisation/Practice/Client/Grade | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
112 | A922 | Organisation/Practice/Client/Fee Earner | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
113 | A923 | Organisation/Practice/Matter/Grade | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
114 | A933 | Sales Organization/Incoterms | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
115 | A936 | Sales org./Distr. Chl/Shpg Cond./Incoterms/Plant/Ship-to | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
116 | A972 | Sales Organization/Distribution Channel/Material/WBS Element | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
117 | A973 | Sales ORg/Distr Chan/Material/WBS Elm/PersNr | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
118 | A976 | Sales Org/DistrChannel/Customer/Material/Personnel NR | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
119 | A981 | Sales org./Distr. Chl/Material/Billable | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
120 | A982 | Sales org./Distr. Chl/Material/Billable/Country | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
121 | A983 | Sales org./Distr. Chl/Material/Billable/Grade | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
122 | A984 | Sales org./Distr. Chl/Material/Billable/Country/Grade | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
123 | A985 | Customer/Material/Billable/Country/Grade | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
124 | A986 | Customer/Material/Billable/Country | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
125 | A987 | Customer/Material/Billable/Grade | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
126 | A988 | Customer/Material | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
127 | A991 | ServcAgent/Dlv.Prior./TfZn P.Dep/Tf zn.dest | 11 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
128 | A992 | DepPostCde/FreightCl. | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
129 | A993 | DepPostCde/MatlFrtGrp | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
130 | A994 | SD doc./Pers.no. | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
131 | A995 | Sales Doc./Item/Pers.No. | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
132 | A997 | Sales document/MnItm PrcRefMatl/Personnel Number | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
133 | T686E | Conditions: Processing Status | 2 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
134 | T686F | Conditions: Processing Status: Texts | 3 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPLocalization |
135 | A151 | Dest. Ctry/Comm. code | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
136 | A373 | Country/Plant/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
137 | A374 | Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
138 | A375 | Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2Mat | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
139 | A376 | Country/Sales org./Region/PlntRegion/TaxCl4Cust/TaxCl.4Mat | 13 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPLogistics - General |
140 | A364 | Trading Contract/Vendor/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
141 | A365 | Trading Contract/Vendor/Material | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
142 | A158 | PTT Circulation/Publication (CH) | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
143 | A159 | Package Type/PType Var./Country Grouping | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
144 | A385 | Sales Org./DChann./Division/Material/Status/Proc.Status | 10 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPTariffs, Duties and Permits |
145 | A419 | ED pricing/Origin/Tax Group/Handl.Type/Orig.reg. | 12 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPTraders and Schedulers Workbench |
146 | A339 | ClsGrp | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
TOPTrading Contract |
147 | A311 | TrCont.no. | 8 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |
148 | A312 | TrCont.no./Item no. | 9 | KBSTAT | Processing status for conditions | nvarchar | 2 | 0 | | |