| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/KPRCPT | Detail of receipt | 25 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
2 | /ATL/KPRCPTKP | Detail of temporary receipt | 25 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
3 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 56 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
4 | BSEC | One-Time Account Data Document Segment | 20 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
5 | FUDT_VDOCBSEC | One-Time Account Data Segment of Verification Document | 20 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
6 | FUDT_VDOCBSECH | One-Time Account Data Segment of Verification Doc(History) | 20 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
7 | J_1UF_CUSTTAX | Customer tax data on a time basis | 4 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
8 | J_1UF_REEIN_NUM | Incoming Documents in Unified Register | 8 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
9 | J_1UF_REEI_XML_A | XML table for J_1UF_REEI with User | 19 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
10 | J_1UF_REP_XML | XML table for J_1UF_REP | 18 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
11 | J_1UF_REP_XML_A | XML table for J_1UF_REEI with User | 19 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
12 | J_1UF_RES_XML | XML table for J_1UF_RES | 21 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
13 | J_1UF_VENTAX | Vendor tax data on a time basis | 4 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
14 | T7RU_521B | Payee Keys (Russia extension for T521B) | 10 | STCD1 | Regional Tax Code | nvarchar | 16 | 0 | | |
15 | TZD0A | Darwin: Customer default values per trans. type for KNA1 | 14 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
16 | WBRD | Agency Business: Bank Data Suspense Account | 15 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPAutomatic Payments |
17 | PAYRQ | Payment Requests | 43 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPBasic Data |
18 | NGPA | IS-H: Business Partners | 51 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPBasic Functions |
19 | VBPA3 | Tax Numbers for One-Time Customers | 5 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPBusiness Partner |
20 | TIVBPVENDORGEN | Vendor Preassignment (General Data) | 24 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
21 | BP1020 | BP: Business Partner - Fiscal Data | 3 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPChile |
22 | PA3235 | HR Master Record: Infotype 3235 | 37 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
23 | T7CL10 | Institution Master Data | 5 | STCD1 | RUT Number | nvarchar | 15 | 0 | | |
TOPContract Accounts Receivable and Payable |
24 | DPAYP | Payment program - data on paid item | 54 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPCross-Application Components |
25 | BC490KKNA1 | General data in customer master | 53 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
26 | KKNA1 | General Data in Customer Master | 53 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
27 | SKNA1 | Customer Master table for BC417 Course | 53 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPCustomer Master |
28 | KNA1 | General Data in Customer Master | 53 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPFinancial Accounting |
29 | /OPT/VIM_1HEAD | Document Header | 223 | STCD1 | CNPJ Number | nvarchar | 14 | 0 | | |
30 | FOTRFDITM | VAT Refund Items | 52 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
31 | FOTRFDITMCHG | Change Documents, VAT Refund Item | 26 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
32 | J_1UF_REEII_XML | XML table for J_1UF_REEII | 21 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
33 | J_1UF_REEI_XML | XML table for J_1UF_REEI | 18 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | | |
34 | LFA1 | Vendor Master (General Section) | 41 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
35 | T001N | Company Code - EC Tax Numbers / Notifications | 15 | STCD1 | Tax Number for Plants Abroad | nvarchar | 16 | 0 | | |
36 | VBSEC | Document Parking One-Time Data Document Segment | 20 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPFunds Management-Specific Postings |
37 | PAYRC | Additional Header Data for Recovery Order | 27 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
38 | PSOSEC | Recurring Request Document Segment, One-Time Data | 22 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPGL Account Posting |
39 | TCJ_CPD | FBCJ: One-Time Account Data of Cash Journal Document Items | 21 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPInformation System |
40 | DKKOS | Balance Audit Trail | 52 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
41 | DKOKS | Open Item Account Balance Audit Trail Master Record | 55 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPInvoice Verification |
42 | RBKP | Document Header: Invoice Receipt | 95 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPLoans Management |
43 | VDAUSZ | Drawings on Disbursement | 32 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
44 | VDZNB_USAGE | Payment Postprocessing: Usage of a Payment Postpr. Activity | 46 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
45 | VZFZE_VDAUSZ | Central Entry Table for Release Procedure | 34 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
46 | VZFZE_VDNBZE | Central Entry Table for Release Procedure | 66 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPLocalization |
47 | IDKR_CUSTVAT | VAT registration number against customer on a time basis | 4 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
48 | IDKR_VENVAT | VAT registration number against vendor on a time basis | 4 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
49 | J_1BBRANCH | Business Place | 15 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
50 | J_1BCTE_D_DOCREF | Reference to the NF-e being transported | 10 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
51 | J_1BCTE_D_REF | Reference to the NF-e being transported | 10 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
52 | J_1BNFCPD | Nota Fiscal one-time accounts | 18 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
53 | J_1BNFEPARKDOC | Nota fiscal electronica: Invoice create failed | 5 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
54 | J_1BNFEPARKLIN | Nota fiscal electronica: Invoice create failed | 5 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
55 | J_1BNFEPARKTAX | Nota fiscal electronica: Invoice create failed | 5 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
56 | J_1BNFE_ACTIVE | Electronic Nota Fiscal: Actual Status | 11 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
57 | J_1BNFE_INVALID | Electronic Nota Fiscal: Invalid Status Actions | 14 | STCD1 | CNPJ Number of Document Issuer | nvarchar | 14 | 0 | | |
TOPLogistics - General |
58 | WBHP | Trading Contract: Partner Assignment | 17 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPMaster Data |
59 | T012 | House Banks | 7 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPPayment Transactions |
60 | REGUH | Settlement data from payment program | 23 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPPayroll |
61 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 45 | STCD1 | Danové císlo 1 | nvarchar | 16 | 0 | | |
62 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 50 | STCD1 | Danové císlo 1 | nvarchar | 16 | 0 | | |
63 | T7UA_521B | Payee Keys (Ukranian extension for table T521B) | 8 | STCD1 | Regional Tax Code | nvarchar | 16 | 0 | | |
TOPPersonnel Administration |
64 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 42 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
65 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 47 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPReal Estate Management |
66 | VIAKBSEG | Document Line Item from SCS for Interface | 74 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPRecruitment |
67 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 42 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPRussia |
68 | T7RU1B | Payee Keys of receiving orders (Russia standard) | 27 | STCD1 | Regional Tax Code | nvarchar | 16 | 0 | | |
TOPSpain |
69 | PA0887 | HR master record, infotype 0887 | 45 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPTransfer Postings |
70 | J_1AAWAYBL | Way Bills for asset movements | 40 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
TOPTravel Expenses |
71 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 9 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
72 | T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data | 12 | STCD1 | Tax Number 1 | nvarchar | 1 | 0 | | |
TOPTreasury |
73 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 30 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |
74 | VZPARZA | Partner addit. data (general part) | 26 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | | |