In this article, we will explore various tables related to

Warning: This manual is still in draft stage. It contains grammatical and other errors. For updates, please check https.

Company Code
Vendor
Customer

And the linkage between different SAP tables.

Updating Telepnone in table ADRC. Does anyone know a FM/BAPI to update table ADRC in R/3? I am using FM ADDRINSERT but it doesn’t update the telephone extension, as it uses structure ADDR1DATA. Apart from that it works fine.
Options for config tables and development objects to find who/when changed. For config objects like tables/views, you can search E071K with wild card (i.e., with ‘.’ ) search strings for transport request no., view/table name, key value. For development objects like ABAP code, search table E071 with trans.req#, object type, object name.

Company Code Address Details:

Kimber aegis trigger job. We maintain SAP Company Code in Transaction / TCode: OX02.
Table T001 stored Company Code details.
Table ADRC Stored Address Details of all SAP object, including Company Code Address. Download mitwa marathi movie.

Fm To Update Adrc Table 2020

Go to Transaction / Tcode: SE16 or SE16N
Enter Table: T001
Enter Company Code and execute.
Check the value in column “Address“, technical field name: “ADRNR“.
Use this value in the next table.
In SE16 / SE16N, enter table ADRC, and enter ADRNR copied in the previous step in field “Address Number” (technical field name: ADDRNUMBER).
Here you can see the details you have entered in the transaction / tcode OX02 while creating the company code.

For detailed information on “How to create Company Code in SAP?” and the relationship between “Company Code table” and “Company code address table”, please refer the link “SAP Company Code Table and Transaction“.

Various Tables related to Company Code in SAP

Business Partner (Customer) Details:

We maintain SAP Business Partners (Customer) in transaction XD01. XD02 and XD03
Table KNA1 and KNB1 stores Customer Master details, and
Table ADRC stores Address Details.

Go to Transaction / TCode: SE16 or SE16N
Enter Table: KNA1, and then enter the Customer Number in the field “Customer” (technical name: KUNNR) and execute.
Check the value in the column “Address” (technical name ADRNR).
Use this value in the next field.
In SE16 / SE16N, enter table ADRC, and enter ADRNR copied in the previous step in field “Address Number” (technical field name: ADDRNUMBER).
Here you can see the address details, maintained in customer master.

Various Tables related to Customer and Vendor in SAP

Hope this post answers your query related to Company Code Tables, Vendor Tables and Customer Tables.
You can post your comments if you want to know something specific.
Do let us know your experience in the comment section below.

LOVE YOURSELF: Her

(as of 13th August 2021 - )

Related content you might be interested in:

HomeSAP DevelopmentABAP StatementsHelp DocsSAP TablesS4Hana TablesT-Code ListFM's

SAP provides you with the ability to restrict access to data while the table is being updated. This is fairlysimple to implement via the use of a lock object (Created in SE11).
Basically the following steps will create two function modules, one to lock the data which starts with ENQUEUE_ andone to release the lock which starts with DEQUEUE_.
When you want to update the data you simple use the ENQUEUE FMbefore you perform any updates and when the updates have finished you simply release the lock using the DEQUEUE FM

Step 1 - Create Lock object (SE11)
Step 2 - ABAP code to lock table entries
Add the following code in-order to create the table lock, use the a pattern functionality within the ABAP editorto automatically generate the function call code. This will then bring through all appropriate importing and exportingparameters. This function module must be called before any update takes place as this is what sets the lock. If alock has already been taken out it will display the appropriate message.

Step 3 - ABAP code to Remove table lock(s)
The following code will remove the lock for the specific table entries.

Step 4 - Lock function module parameters
Further details about the parameters of the ENQUEUE(lock) and DEQUEUE(unlock) function modules:
mode_ZTABLENAME - set lock mode
S = Read Lock (share lock for read only access), other users can requerst read access when this lock is active
E = Write Lock (Exclusive lock which prevents all other lock types from other users)
X = Exclusive not cumulative. Even same user can't request another write lock until previous lock has been released
_SCOPE - defines the level of the lock owner
1 - Only exists in dialog transaction. Dequeue, Commit work and roll back releases the lock
2 - Exists in the update transaction so will be release with DEQUEUE or when the normal SAP update task has competed, commit work or rollback has no effect.Remember commit work triggers the update process to start so the lock release will happen after that has completed.
3 - combination of the above
_WAIT
If a lock exists the _wait parameter allows you to assign a certain amount which the FM will wait and try again to see if lock is released
_COLLECT
X or blank - Allows you to collect multiple locks locally and then send them all to server together using FLUSH_ENQUEUE

Related Articles

Create SAP database table within the data dictionary transaction SE11
SAP Dictionary objects - Example code and information of the SAP dictionary
Download SAP database structure to file
Retrieve fixed SAP domain values Fm To Update Adrc Table

Modify your SAP database table maintenance events, screen, interface and code
Create and maintain parameter values in TVARVC using STVAR SAP transaction Update

Create SAP database table maintenance for your custom Z table using transaction SE11
SAP database table settings for Master, Application, Transaction and Customizing data
SAP text table create
Creating transaction code for table maintenance (SM30)
Retrieve text for table field

Fm To Update Adrc Table