SAP Inventory Accounting Tables
Are you looking for the right table related to SAP Inventory Accounting Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Inventory Accounting (FIN-BAC-INV) module.
Top 10 tables in Inventory Accounting
| Table | Description |
|---|---|
| FAIBSV09C | Rule: Special Parameters for Market Prices |
| UAIQSINV | Quantity Structure: Inventory Node |
| CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) |
| FAIBSV02 | Valuated Receipts |
| CFICR0C | FIN Objects for Cost Center/Resource Pool |
| FAIBSV01C | Rule for Balance Sheet Valuation |
| CFIORNTA0C | FIN Objects for Network Items |
| FAIBSV12C | Price Relationships |
| FAIBSV06C | Grouping by Rule (Balance Sheet Valuation) |
| FAIBSV11C | Configuration: Balance Sheet Valuation Procedure Attributes |
List of tables in Inventory Accounting
| Table | Description |
|---|---|
| FAIBSV09C | Rule: Special Parameters for Market Prices |
| UAIQSINV | Quantity Structure: Inventory Node |
| CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) |
| FAIBSV02 | Valuated Receipts |
| CFICR0C | FIN Objects for Cost Center/Resource Pool |
| FAIBSV01C | Rule for Balance Sheet Valuation |
| CFIORNTA0C | FIN Objects for Network Items |
| FAIBSV12C | Price Relationships |
| FAIBSV06C | Grouping by Rule (Balance Sheet Valuation) |
| FAIBSV11C | Configuration: Balance Sheet Valuation Procedure Attributes |
| FAIBSV07C | Rule: Input and Output Prices |
| CFIORMNF0C | FIN Objects for Manufacturing Orders |
| CFIOCONSI0C | FIN Objects for Consignment |
| FAIBSV01T | Texts for Rule |
| FAIBSV10C | Rule - Special Parameters for Percentage Write-Down |
| UAIQS_SNDRCV | Quantity Structure: Valuated Quantity Structure |
| UAIDETAILDATA | Trace Option for Realignment Runs |
| UAINVDEBCRI | Document Item for Revaluation Through Material Debit/Credit |
| FAIBSV15C | Persistence Objects for Balance Sheet Valuation |
| UAIQSWIP | Quantity Structure: WIP Node |
| UAINVREVALH | Document for INV Price Change and Inventory Revaluation |
| CFIOSENTR0C | FIN Objects for Services |
| FAIBSV11T | Configuration - Balance Sheet Val. Procedure Description |
| CON_ACC_TACTIVE | Activate Inventory Accounting in Client |
| UAI_ABGRIR_GUID | GUIDs for Transaction-Based GR/IR Clearing |
| CFIORSRV0C | FIN Objects for Service Orders |
| UAIQSVERSIONT | Text for Quantity Structure Version |
| UAIQSITEMCTRL | Quantity Structure: Control Table Items |
| CFIORWBS0C | FIN Objects for WBS Elements |
| CFIORQMM0C | FIN Objects for QM Orders |
| UAINVDEBUG | Debugging Support |
| FAIBSV17C | Rule: Currency Types |
| CFIPVLOCPRD0C | Product Depending on Company/Location |
| UAINVREVALI | Document Item for Inventory Price Change and Revaluation |
| UAIQS_BALANCE | Quantity Structure: Beginning/Ending Inventories and Values |
| CFIPVLOCPRDBTC0C | Product Depending on Company/Location/Batch |
| UAINV_CTRLCOGSC | Control Revaluation Cost of Sales |
| CFIORMNT0C | FIN Objects for Maintenance Orders |
| CONACCDATASOURCE | DataSources Inventory Accounting |
| FAIBSV02C | Percentage Writedown: Weighting Factors |
| UAINVTSTLRULES | Settlement Rule Sender |
| CFICC0C | FIN Objects for Cost Centers |
| FAIBSV08C | Rule - Special Parameters FIFO |
| FAIBSV04C | Configuration: Percentage Write-Down Key |
| CFIORNTW0C | FIN Objects for Networks |
| UAINVT4000 | Configuration Status of Inventory/WIP for Accounting Systems |
| CFIORPURITM0C | FIN Objects for Purchase Order Items |
| UAIQSCCTR | Quantity Structure: Cost Center Node |
| CFIORGEN0C | FIN Objects for Internal Orders |
| CFIFA0C | FIN Objects for Fixed Assets |
| UAINVTSTLRULER | Settlement Rule Receiver |
| FAIBSV16C | Price Type Assignment for Preliminary Market Prices |
| FAIBSV13C | Assignment of Valuation Procedures to Price Types |
| FAIBSV03 | Logistical Goods Movements |
| UAIQSEDGETYPE | Quantity Structure: Edge Type (of Sender/Rec. Relationship) |
| UAIQSACT | Quantity Structure: Activity Node |
| FAIBSV01 | Incoming/Outgoing Invoices |
| FAIBSV18C | Writedown Percentages to Specific Key: Range of Coverage |
| FAIBSV14C | Configuration: Application Class Market Prices |
| UAINVTMAPPING | Mapping Table New Accounting <-> R/3 Functions |
| UAINV_DYNRELACT | Activation of Dynamic Price Release |
| UAIQSVERSION | Quantity Structure: Version |
| UAINV_DERIVECO | Derivation for Revaluation CO-PA Structure |
| UAINVREVCOH | Header Table for Tracking the Revaluation Runs |
| UAI_ABGRIR_BTA | Business Trans. Categories of Transactional GR/IR Clearing |
| UAI_ABGRIR_ACTIV | Activation of Transaction-Based GR/IR Clearing |
| FAIBSV19C | Valuation Groups: Mapping of Field Names |
| UAIQSPURORD | Quantity Structure: Purchasing Node |
| UAINVAPPL | Application Specifics in Period-End Closing |
| UAINV_BTACOGSC | Additional Business Trans Categories for Revaluation of COS |
| UAINVDEBCRH | Document for Revaluation Through Material Debit/Credit |
| UAIQSTIME | Quantity Structure: Time Dimension |
| UAINV_DYNRELCUS | Customizing for Dynamic Price Release |