TZD0A SAP (Darwin: Customer default values per trans. type for KNA1) Pooled Table details
Description: Darwin: Customer default values per trans. type for KNA1
Pooled Table field list including key, data, relationships and ABAP select examples
TZD0A is a standard SAP Pooled Table which is used to store Darwin: Customer default values per trans. type for KNA1 data and is available within R/3 SAP systems depending on the version and release level.
The TZD0A table consists of various fields, each holding specific information or linking keys about Darwin: Customer default values per trans. type for KNA1 data available in SAP. These include GSART (Product Type), FISKN (Account number of the master record with the fiscal address), KNRZA (Account number of an alternative payer), LIFNR (Account Number of Vendor or Creditor).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TZD0A pooled 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 | Assigned to domain | MANDT | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
BBBNR | German Standard Company Number (Batch Input Field) | BBBNR_BI | CHAR | 7 | CHAR7 | ||||
BBSNR | German Standard Company Number (Additional) (Batch Input) | BBSNR_BI | CHAR | 5 | CHAR5 | ||||
BUBKZ | German Standard Company Number Check Digit (Batch Input) | BUBKZ_BI | CHAR | 1 | CHAR1 | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
BRSCH | Industry key | BRSCH | CHAR | 4 | Assigned to domain | BRSCH | |||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG |
Key field | Non-key field |
How do I retrieve data from SAP table TZD0A using ABAP code
The following ABAP code Example will allow you to do a basic selection on TZD0A to SELECT all data from the tableDATA: WA_TZD0A TYPE TZD0A.
SELECT SINGLE *
FROM TZD0A
INTO CORRESPONDING FIELDS OF WA_TZD0A
WHERE...
How to access SAP table TZD0A
Within an ECC or HANA version of SAP you can also view further information about TZD0A 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