TINV_INV_TRANSF SAP (Transfer Table for Bill Data to FI-CA) Table details
Description: Transfer Table for Bill Data to FI-CA
Related tables to TINV_INV_TRANSF
Access table TINV_INV_TRANSF
Table field list including key, data, relationships and ABAP select examples
TINV_INV_TRANSF is a standard SAP Table which is used to store Transfer Table for Bill Data to FI-CA data and is available within R/3 SAP systems depending on the version and release level.
The TINV_INV_TRANSF table consists of various fields, each holding specific information or linking keys about Transfer Table for Bill Data to FI-CA data available in SAP. These include INT_TRANSF_NO (Internal ID of Transfer Line), INT_INV_DOC_NO (Internal Number of Bill Document/Payment Advice Document), INT_INV_LINE_NO (Line Item Number of Bill/Payment Advice Note Document), DATE_OF_RECEIPT (Document Date of Receipt).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TINV_INV_TRANSF table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
INT_TRANSF_NO | Internal ID of Transfer Line | INV_INT_TRANSF_NO | NUMC | 18 | INV_INT_TRANSF_NO | ||||
INT_INV_DOC_NO | Internal Number of Bill Document/Payment Advice Document | INV_INT_INV_DOC_NO | NUMC | 18 | INV_INT_INV_DOC_NO | TINV_INV_DOC | |||
INT_INV_LINE_NO | Line Item Number of Bill/Payment Advice Note Document | INV_INT_INV_LINE_NO | NUMC | 8 | INV_INT_INV_LINE_NO | ||||
DATE_OF_RECEIPT | Document Date of Receipt | INV_DATE_OF_RECEIPT | DATS | 8 | INV_DATE_OF_RECEIPT | ||||
INVOICE_DATE | Bill/Payment Advice Note Date | INV_INVOICE_DATE | DATS | 8 | INV_INVOICE_DATE | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
THBLN_EXT | Aggregated Document Number | THBLN_EXT | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
THBLN_TYPE | Document Number Type | INV_THBLN_TYPE | CHAR | 1 | INV_THBLN_TYPE | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
THPRD | Actual Date for Transfer to Third Party | THPRD_KK | DATS | 8 | DATUM | ||||
THPDT | Planned date for transfer of payment to third party | THPDT_KK | DATS | 8 | DATUM | ||||
THPST | Entry status | THPST_KK | CHAR | 1 | THPST_KK | ||||
WAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
TAXBW | Tax Amount in Transaction Currency | INV_TAXBW | CURR | 13(2) | WRTV7 | ||||
STPRZ | Tax rate | STPRZ_KK | NUMC | 6 | STPRZ_KK | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
RECEIVER_TYPE | Type of Bill/PAN Recipient | INV_RECEIVER_TYPE | NUMC | 2 | INV_RECEIVER_TYPE | ||||
INT_RECEIVER | Internal Description of Bill/Payment Advice Recipient | INV_INT_RECEIVER | CHAR | 15 | INV_INT_SENDREC | ||||
SENDER_TYPE | Type of Bill/PAN Sender | INV_SENDER_TYPE | NUMC | 2 | INV_SENDER_TYPE | ||||
INT_SENDER | Internal Description of Bill/Payment Advice Note Sender | INV_INT_SENDER | CHAR | 15 | INV_INT_SENDREC | ||||
GPART | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
INVCAT | Bill Category of a General Ledger Account/Contract Account | INV_INVCAT | CHAR | 4 | INV_INVCAT | ||||
LINE_TYPE | Line Type | INV_LINE_TYPE | NUMC | 4 | Assigned to domain | INV_LINE_TYPE | |||
LINE_CONTENT | Content of Bill/Payment Advice Note Line | INV_LINE_CONTENT | NUMC | 2 | INV_LINE_CONTENT | ||||
INT_LINE_REF_NO | Internal Reference Number to Link Several Doc. Line Items | INV_INT_LINE_REF_NO | NUMC | 18 | |||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
QUANTITY | Quantity | INV_QUANT | QUAN | 15(3) | INV_QUANTITY | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PAYLOCH | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
PAYLOCV | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
INV_BVT | Bank Details ID for Sender | INV_BVT | CHAR | 4 | |||||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
CHANGE_DATE | Changed On | AEDAT | DATS | 8 | DATUM | ||||
SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR | 13(2) | WRTV7 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
DPPRC | Down Payment Process for Supplier: Posting Category | INV_DPPRC | CHAR | 1 | INV_DPPRC | ||||
INVDUMMY | Checkbox | XFELD | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table TINV_INV_TRANSF using ABAP code
The following ABAP code Example will allow you to do a basic selection on TINV_INV_TRANSF to SELECT all data from the tableDATA: WA_TINV_INV_TRANSF TYPE TINV_INV_TRANSF.
SELECT SINGLE *
FROM TINV_INV_TRANSF
INTO CORRESPONDING FIELDS OF WA_TINV_INV_TRANSF
WHERE...
How to access SAP table TINV_INV_TRANSF
Within an ECC or HANA version of SAP you can also view further information about TINV_INV_TRANSF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects