Brief scenario of check table / value table?
Answers were Sorted based on User's Feedback
Answer / guest
Value Table - This is maintained at Domain Level.
When ever you create a domain , you can entered allowed
values. For example you go to Domain SHKZG -
Debit/credit indicator. Here only allowed values is H or
S. When ever you use this Domain, the system will force you
to enter only these values. This is a sort of master
check . To be maintained as a customization object. This
mean that if you want to enter values to this table you
have to create a development request & transport the same.
Check table - For example you have Employee master table &
Employee Transaction table.
When ever an employee Transacts we need to check whether
that employee exists , so we can refer to the employee
master table. This is nothing but a Parent & Child
relationship . Here data can be maintained at client
level , no development involved. As per DBMS what we call
foregin key table, is called as check table in SAP.
| Is This Answer Correct ? | 40 Yes | 3 No |
Answer / girish.m
CHECK TABLE: this is given at field level.it contains only
valid values.when we are going to create foreign key
relationship b/t table A and table B, the table B secomes
check table for table A.
Example: they are 2 tables employee table and dept. table.
now we are going to create data of employees in employee
table. now it takes employees belongs to that dept.mentioned
in dept. table, it will not take other dept.
employees.Dept.table becomes check table for employee table.
VALUE TABLE: this is given at domin level. it contains all
possible values. when we press f4 help for the field in
selection-screen the values coming from value table.
| Is This Answer Correct ? | 27 Yes | 9 No |
Answer / sridhar kasthuri
Value Table:
Always Value table means table which contain the all
possible existing value for that field(key).It refers to F4
functionality. Usually we will create any value table
whenever we are creating the key's domain.
Check Table:
The name itself is defines that it is the table which is
giving the check function when the foreign key is populated
with some value.
I mean to say that at the time you are populating elements
into the foreign key table at that time
ex: foreign key [ ]
you entered some value in above field and pressed ENTER
key on key board then system automatically excutes the
select statement on the existing check table, in order to
know whether this key's entry exist in the check table or
not.
So here the check table means the reference for comparision.
And foreign key table means referee which is asking for
check.
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / k.nagalakshmi
Check table:it checks the field in its foreign table
Value table:its a table where it checks the field for its
existence
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / ravikiran
check table:1)it is maintained at table level.
2)it can be used to extract the data in the programs.
3)it forces the user to select any one of the check table field entries.
value table:1)it is maintained at domain level.
2)it can be used to extract the data since it is linked with the domain.
3)it does not forces the user since it has empty value by default.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prathyusha
check table : It is a field level validation,by checking the corresponding entries in the foreign table..
value table : It is the domain level validation,by checking into the corresponding entries into the reference table....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / uma
value table:
value table we maintained at domain level.it for exmaple
of domain is shkzg in this level the system maintain value
ranges like h or s.when ever we assigned the domain in
table only that perticuler field like what ever we
assigened domain into field it allows only existing values
like h or s.
check table:
for example of check table is first table is employee
master table like employee name,address etc.its standardand
another table is employee transaction table like employee
salary details,whch platforms like this .
when ever we give the employee name first it checks the
whether that employee is exit or not in employee master
table is nothing but check table.and transaction employee
table is foreign key table.
| Is This Answer Correct ? | 1 Yes | 3 No |
THE MAIN THING OF VALUE TABLE IS, IT DOES NOT RESTRICT ANY
VALUES. IT IS A USELESS TABLE.
IT JUST PROPOSES TO THE CHECK TABLE, AND WE CANNOT GET THE
F4 VALUES FOR THAT PARTICULAR DOMAIN.
| Is This Answer Correct ? | 5 Yes | 41 No |
what is use of info records,condition records in material master?
How can we omit a leading sign and a leading zero in sapscript?
what is difference between update and modify
What is the role of an abapper in developement process? What is the process of technical specification and how it is carried out?
SAP Date Format?
What are the Various Types of internal tables?
What is filter dependent BADI?
0 Answers Cap Gemini, Infosys,
how to migrate standard text in sap script to smart form?
What does hide statement do?
shell we use select-options in mpp?then how?
can we write at-line-selection and at-user-command at a time in same program. plz some body help me to know this answer.
what is a binary search ? and how it is useful in a sorted internal table?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)