SAP has its own importance and here in this post we are going to talk about the full form of sap and its meaning and how the keyword SPLIT is used in ABAP programming.
Variants
1. SPLIT f AT g INTO h1 ... hn.
2. SPLIT f AT g INTO TABLE itab.
Variant 1
SPLIT f AT g INTO h1 ... hn.
Effect
Splits the contents of the f according to the delimiter g and places them in the fields h1 to hn ( n >= 2).g is used in its defined length. The return code value is set as follows:
SY-SUBRC = 0 All hi fields (1 <= i <= n ) were big enough.
SY_SUBRC = 4 One of the hi fields was not big enough and had to be truncated.
DATA: NAMES(30) VALUE 'Charly, John, Peter',
ONE(10),
TWO(10),
DELIMITER(2) VALUE ','.
SPLIT NAMES AT DELIMITER INTO ONE TWO.
Now, ONE has the value "Charly" and TWO has the value "John, Pete" .
SY-SUBRC is set to 4, since TWO was not big enough to include "John, Peter" .
DATA: NAMES2(30) VALUE 'Charly, John, Peter', THREE(10) VALUE 'New York',
FOUR(10),
FIVE(10),
SIX(10) VALUE 'SAP'.
SPLIT NAMES2 AT ',' INTO THREE FOUR FIVE SIX.
IF THREE = 'Charly' AND
FOUR = ' John' AND
FIVE = ' Peter' AND
SIX = SPACE.
WRITE 'SPLIT is OK'.
ENDIF.
Outputs "SPLIT is OK" .
Unless the number of target fields is greater than the number of delimiters in the source field, very little information ought to be lost. Therefore, the last target field in this case contains the "rest", including the delimiters .
If the source field does not contain the separator sequence at all, it is copied incomplete to the first
target field.
Variant 2
SPLIT f AT g INTO TABLE itab.
Effect
Like variant 1.
Stores the components of f in the internal table itab . For each part of f , a "special" table line is created. f is considered without trailing blanks.
Example
DATA: BEGIN OF ITAB OCCURS 10,
WORD(20),
END OF ITAB.
SPLIT 'STOP Two STOP Three STOP ' AT 'STOP' INTO
TABLE ITAB.
Now, ITAB has three lines. The first line is blank, the second contains 'Two' and the third contains 'Three' .
Performance
The runtime required for the SPLIT command in the first example for variant 1 is about 15 msn (standardized microseconds). If the sub-fields of f are written to an internal table, about 30 msn are needed.
Related Posts:
Business warehouse information and reporting overview
SAP BW information and reporting tools
SAP business scenario for material planning
Sales and operations planning in MySAP
MySAP sales and distribution strateties
SAP definition,full form,over veiw and introduction
SAP Full form of planning and distribution of goods
SAP full form for mrp,sales and materiel planning
What is SAP and Why do we are in need of It
sap full form,meaning and history of SAP
SAP full form syntax for SET
Variants
1. SPLIT f AT g INTO h1 ... hn.
2. SPLIT f AT g INTO TABLE itab.
Variant 1
SPLIT f AT g INTO h1 ... hn.
Effect
Splits the contents of the f according to the delimiter g and places them in the fields h1 to hn ( n >= 2).g is used in its defined length. The return code value is set as follows:
SY-SUBRC = 0 All hi fields (1 <= i <= n ) were big enough.
SY_SUBRC = 4 One of the hi fields was not big enough and had to be truncated.
DATA: NAMES(30) VALUE 'Charly, John, Peter',
ONE(10),
TWO(10),
DELIMITER(2) VALUE ','.
SPLIT NAMES AT DELIMITER INTO ONE TWO.
Now, ONE has the value "Charly" and TWO has the value "John, Pete" .
SY-SUBRC is set to 4, since TWO was not big enough to include "John, Peter" .
DATA: NAMES2(30) VALUE 'Charly, John, Peter', THREE(10) VALUE 'New York',
FOUR(10),
FIVE(10),
SIX(10) VALUE 'SAP'.
SPLIT NAMES2 AT ',' INTO THREE FOUR FIVE SIX.
IF THREE = 'Charly' AND
FOUR = ' John' AND
FIVE = ' Peter' AND
SIX = SPACE.
WRITE 'SPLIT is OK'.
ENDIF.
Outputs "SPLIT is OK" .
Unless the number of target fields is greater than the number of delimiters in the source field, very little information ought to be lost. Therefore, the last target field in this case contains the "rest", including the delimiters .
If the source field does not contain the separator sequence at all, it is copied incomplete to the first
target field.
Variant 2
SPLIT f AT g INTO TABLE itab.
Effect
Like variant 1.
Stores the components of f in the internal table itab . For each part of f , a "special" table line is created. f is considered without trailing blanks.
Example
DATA: BEGIN OF ITAB OCCURS 10,
WORD(20),
END OF ITAB.
SPLIT 'STOP Two STOP Three STOP ' AT 'STOP' INTO
TABLE ITAB.
Now, ITAB has three lines. The first line is blank, the second contains 'Two' and the third contains 'Three' .
Performance
The runtime required for the SPLIT command in the first example for variant 1 is about 15 msn (standardized microseconds). If the sub-fields of f are written to an internal table, about 30 msn are needed.
Related Posts:
Business warehouse information and reporting overview
SAP BW information and reporting tools
SAP business scenario for material planning
Sales and operations planning in MySAP
MySAP sales and distribution strateties
SAP definition,full form,over veiw and introduction
SAP Full form of planning and distribution of goods
SAP full form for mrp,sales and materiel planning
What is SAP and Why do we are in need of It
sap full form,meaning and history of SAP
SAP full form syntax for SET
