DDL example Schema DDL
116 U929-J-Z125-9-76
85 LOCATION MODE IS CALC USING ARTICLE-NAME
86 DUPLICATES ARE ALLOWED
87 WITHIN CLOTHING, HOUSEHOLD-GOODS, SPORTS-ARTICLES, FOOD,
88 LEISURE, STATIONERY AREA-ID IS RLM-SELECTION-3.
89 *
90 01 ART-NO PICTURE IS 9(6).
91 01 ARTICLE-NAME TYPE IS CHARACTER 40.
92 01 MATERIAL OCCURS 4 TIMES.
93 02 PERZENT PICTURE IS 99.
94 02 MAT-CODE PICTURE IS X.
95 01 LENGTH-FIELD TYPE IS BINARY 15.
96 01 ART-INFO PICTURE IS LX(500)
97 DEPENDING ON LENGTH-FIELD.
98 *
99 *
100 RECORD NAME IS ARTICLE
101 LOCATION MODE IS CALC USING ART-NO, COL-NO, ART-SIZE
102 DUPLICATES ARE NOT ALLOWED
103 WITHIN CLOTHING, HOUSEHOLD-GOODS, SPORTS-ARTICLES, FOOD,
104 LEISURE, STATIONERY AREA-ID IS RLM-SELECTION-4
105 SEARCH KEY IS ART-NO-AVAIL, COL-NO-AVAIL, ART-SIZE
106 USING CALC NAME IS SEARCH-TAB-ARTICLE-1
107 DUPLICATES ARE NOT ALLOWED
108 SEARCH KEY IS ARTICLE-NAME USING CALC
109 NAME IS SEARCH-TAB-ARTICLE-2 DUPLICATES ARE ALLOWED.
110 *
111 01 ART-NO PICTURE IS 9(6).
112 01 COL-NO PICTURE IS 99.
113 01 ARTICLE-NAME TYPE IS CHARACTER 40.
114 01 ART-NO-AVAIL PICTURE IS 9(4).
115 01 COL-NO-AVAIL PICTURE IS 99.
116 01 ART-SIZE PICTURE IS 99.
117 01 PRICE TYPE IS DECIMAL 7,2.
118 01 INSTALMENT-PRICE TYPE IS DECIMAL 7,2.
119 01 MAX-STOCK TYPE IS DECIMAL 10.
120 01 MIN-STOCK TYPE IS DECIMAL 3.
121 01 CURR-STOCK TYPE IS DECIMAL 10.
122 01 STATISTICS TYPE IS DECIMAL 15.
123 01 NOT-AVAIL-CODE PICTURE IS X.
124 *
125 *
126 RECORD NAME IS SUBSET
127 WITHIN HOUSEHOLD-GOODS, SPORTS-ARTICLES
128 AREA-ID IS RLM-SELECTION-5.
129 *
130 01 QUANTITY PICTURE IS 99.
131 *
132 *