What is main transaction SAP?
The main transactions controls the receivable and payable accounts. The Subtransaction controls the revenue,tax account determinations.
What is sub transaction?
Noun. subtransaction (plural subtransactions) (databases) A transaction making up part of a larger transaction.
What is main transaction and sub transaction in SAP?
Main and subtransactions are categories, which are used to specify items for a document in the Collections/Disbursements system. They are specified with regard to the combination of parameters controlling the processing of these items in the Collections/Disbursements system and account determination.
What is Account determination ID in SAP FICA?
Account Determiantion ID is a charactersitic used with Company Code, division, main transaction, and sub transaction to determine a GL A/c. (
What is Subtransaction in Postgres?
Subtransactions in PL/pgSQL Every time you enter a block with an EXCEPTION clause, a new subtransaction is started. The subtransaction is committed when you leave the block, and rolled back when you enter the exception handler.
What is Savepoint in Postgres?
A savepoint is a special mark inside a transaction that allows all commands that are executed after it was established to be rolled back, restoring the transaction state to what it was at the time of the savepoint.
What is main transaction and sub transaction in SAP FICA?
Main Transaction & Sub Transaction Use In FICA convergent invoicing Main Transaction and Sub Transaction are used to determine some dependent data automatically in the system. The below post shows how the main and sub transaction are used in CI posting area to determine the G/L account(s).
How increase exception PostgreSQL?
To raise an error, you use the exception level after the raise statement. Note that raise statement uses the exception level by default. The option can be: message : set error message.
What is the difference between rollback to savepoint and release savepoint?
The ROLLBACK TO SAVEPOINT statement rolls back a transaction to the named savepoint without terminating the transaction. The RELEASE SAVEPOINT statement removes the named savepoint from the set of savepoints of the current transaction. No commit or rollback occurs.
How do you create a savepoint?
A SAVEPOINT is a point in a transaction in which you can roll the transaction back to a certain point without rolling back the entire transaction. Syntax for Savepoint command: SAVEPOINT SAVEPOINT_NAME; This command is used only in the creation of SAVEPOINT among all the transactions.
What are the exceptions in PostgreSQL?
EXCEPTION is the default level and the only one that will halt the procedure. Each level generates an error message with detailed information based on priority levels. Users can control where these error messages will be reported (i.e., on client screen, server logs or on both) by setting the postgresql.
What is raise exception in PostgreSQL?
Introduction to PostgreSQL RAISE EXCEPTION. PostgreSQL raises an exception is used to raise the statement for reporting the warnings, errors and other type of reported message within a function or stored procedure.
How are main transactions and sub transactions used?
Thus main transactions and sub transactions are used to identify items based on their type (such as interest and charge) as well as the business process from which they originated (payments, account statements, and so on). Internal transactions are hard coded and are reserved by the FSCD system.
How to create a sub transaction in FICA?
Go to Tx- FICAIMG and as highlighted below the Main transaction can be created and then the sub-transaction can be created and assigned to the main transaction. Define Main Transaction. Define Sub Transaction. Loading…
How are main and sub transactions determined in CI?
BITs – When BIT is created based on the sub process and billable item type the main and sub transaction are determined. When the CI billing document is created for the BITs and from Billing document the CI invoicing doc is created, the posting document is also created.
Why do you need a sub transaction in FSCD?
The sub transaction is also required for the revenue account determination. This enables you to allocate different revenue accounts to one business transaction (i.e main transaction) by defining special sub transactions. It is also possible to allocate different revenue accounts for each company code and division.
https://www.youtube.com/watch?v=S9-7PDF0fsk