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