SAP ABAP Table WTYBRF_CUST_GEN (BRF Data Source: General Data for Customer)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ LO-WTY (Application Component) Warranty Claim Processing
⤷ ISAUTO_WTY (Package) Warranty Processing
⤷ LO-WTY (Application Component) Warranty Claim Processing
⤷ ISAUTO_WTY (Package) Warranty Processing
Basic Data
Table Category | INTTAB | Structure |
Structure | WTYBRF_CUST_GEN | Table Relationship Diagram |
Short Description | BRF Data Source: General Data for Customer |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | HANDLE | WTY_HANDLE | WTY_HANDLE | CHAR | 22 | 0 | Warranty Handling, Number | ||
2 | PNGUID | WTY_GUID | SYSUUID | RAW | 16 | 0 | GUID Warranty Claim | ||
3 | .INCLUDE | 0 | 0 | BAPI Interface Structure with KNA1 Fields Without Address | |||||
4 | CUSTOMER | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
5 | ACC_1_TIME | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
6 | ADDRESS | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
7 | ORDR_BLK_G | AUFSD_X | KAUFS | CHAR | 2 | 0 | Central order block for customer | * | |
8 | EXPR_STAT | BAHNE | BAHNH | CHAR | 25 | 0 | Express train station | ||
9 | TRAIN_STAT | BAHNS | BAHNH | CHAR | 25 | 0 | Train station | ||
10 | LOC_NO_1 | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
11 | LOC_NO_2 | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
12 | AUTH_GROUP | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
13 | INDUSTRY | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | T016 | |
14 | CHK_DIGIT | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
15 | DATA_LINE | DATLT | TEXT14 | CHAR | 14 | 0 | Data communication line no. | ||
16 | CREAT_DATE | ERDAT_RF | DATUM | DATS | 8 | 0 | Date on which the Record Was Created | ||
17 | ENTERED_BY | ERNAM_RF | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
18 | UNLOAD_PT | EXABL | XFELD | CHAR | 1 | 0 | Indicator: Unloading points exist | ||
19 | BILL_BLK_G | FAKSD_X | FAKSP | CHAR | 2 | 0 | Central billing block for customer | * | |
20 | FISK_ADDR | FISKN_D | KUNNR | CHAR | 10 | 0 | Account number of the master record with the fiscal address | * | |
21 | WORK_TIME | KNAZK | WFCID | CHAR | 2 | 0 | Working Time Calendar | TFACD | |
22 | ALT_PAYER | KNRZA | KUNNR | CHAR | 10 | 0 | Account number of an alternative payer | * | |
23 | GROUPKEY | KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
24 | ACCNT_GRP | KTOKD | KTOKD | CHAR | 4 | 0 | Customer Account Group | T077D | |
25 | CLASSIFIC | KUKLA | KUKLA | CHAR | 2 | 0 | Customer classification | * | |
26 | VENDOR_NO | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
27 | DELI_BLK_G | LIFSD_X | LIFSP | CHAR | 2 | 0 | Central delivery block for the customer | * | |
28 | LOC_CODE | LOCCO | LOCCO | CHAR | 10 | 0 | City Coordinates | ||
29 | DEL_FLAG_G | LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
30 | REG_MARKET | RPMKR | RPMKR | CHAR | 5 | 0 | Regional market | ||
31 | PSTG_BLK_G | SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
32 | TAX_NO_1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
33 | TAX_NO_2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
34 | EQUAL_TAX | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
35 | SLS_PUR_TX | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
36 | PAYER_DOC | XREGU | XFELD | CHAR | 1 | 0 | Indicator: Is an alternative payer allowed in document? | ||
37 | TRADE_ID | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
38 | VAT_REG_NO | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
39 | COMPETITOR | DEAR1 | XFELD | CHAR | 1 | 0 | Indicator: Competitor | ||
40 | SLSPARTNER | DEAR2 | XFELD | CHAR | 1 | 0 | Indicator: Sales partner | ||
41 | PROSPECT | DEAR3 | DEAR3 | CHAR | 1 | 0 | Indicator: Sales prospect | ||
42 | CUSTTYPE_4 | DEAR4 | XFELD | CHAR | 1 | 0 | Indicator for customer type 4 | ||
43 | DFLT_SP | DEAR5 | XFELD | CHAR | 1 | 0 | ID for default sold-to party | ||
44 | LEGALSTAT | GFORM | GFORM | CHAR | 2 | 0 | Legal status | * | |
45 | IND_CODE_1 | BRAN1_D | BRACO | CHAR | 10 | 0 | Industry code 1 | * | |
46 | IND_CODE_2 | BRAN2 | BRACO | CHAR | 10 | 0 | Industry code 2 | * | |
47 | IND_CODE_3 | BRAN3 | BRACO | CHAR | 10 | 0 | Industry code 3 | * | |
48 | IND_CODE_4 | BRAN4 | BRACO | CHAR | 10 | 0 | Industry code 4 | * | |
49 | IND_CODE_5 | BRAN5 | BRACO | CHAR | 10 | 0 | Industry code 5 | * | |
50 | INITCONTCT | EKONT | VBELN | CHAR | 10 | 0 | Initial contact | * | |
51 | ANN_SALES | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
52 | SALES_YEAR | UMJAH | JAHR | NUMC | 4 | 0 | Year For Which Sales are Given | ||
53 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
54 | CURRENCY_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
55 | EMPLOYEES | JMZAH | JMZAH | NUMC | 6 | 0 | Yearly number of employees | ||
56 | EMPL_YEAR | JMJAH | JAHR | NUMC | 4 | 0 | Year for which the number of employees is given | ||
57 | ATTRIBUTE | KATR1 | ATTR1 | CHAR | 2 | 0 | Attribute 1 | * | |
58 | ATTRIB_2 | KATR2 | ATTR2 | CHAR | 2 | 0 | Attribute 2 | * | |
59 | ATTRIB_3 | KATR3 | ATTR3 | CHAR | 2 | 0 | Attribute 3 | * | |
60 | ATTRIB_4 | KATR4 | ATTR4 | CHAR | 2 | 0 | Attribute 4 | * | |
61 | ATTRIB_5 | KATR5 | ATTR5 | CHAR | 2 | 0 | Attribute 5 | * | |
62 | ATTRIB_6 | KATR6 | ATTR6 | CHAR | 3 | 0 | Attribute 6 | * | |
63 | ATTRIB_7 | KATR7 | ATTR7 | CHAR | 3 | 0 | Attribute 7 | * | |
64 | ATTRIB_8 | KATR8 | ATTR8 | CHAR | 3 | 0 | Attribute 8 | * | |
65 | ATTRIB_9 | KATR9 | ATTR9 | CHAR | 3 | 0 | Attribute 9 | * | |
66 | ATTRIB_10 | KATR10 | ATTR10 | CHAR | 3 | 0 | Attribute 10 | * | |
67 | SOLE_PROP | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
68 | ANN_SALES1 | BAPICURR_D | BAPICURR | DEC | 23 | 4 | Currency amount in BAPI interfaces | ||
69 | TAXJURCODE | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
70 | FY_VARIANT | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
71 | DLVSCHEDUSE | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
72 | INSPBYCUST | QINSPBYDEB | QKZ | CHAR | 1 | 0 | Inspection Carried Out By Customer (No Inspection Lot) | ||
73 | INSPAFTDEL | QINSPATDEB | QKZ | CHAR | 1 | 0 | Inspection for a Delivery Note After Outbound Delivery | ||
74 | REF_ACTGR | KTOCD | KTOKD | CHAR | 4 | 0 | Reference Account Group for One-Time Account (Customer) | * | |
75 | PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
76 | DME_IND | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
77 | INSTR_KEY | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
78 | DATA_TRANS | DUEFL_BKPF | DUEFL_BKPF | CHAR | 1 | 0 | Status of Data Transfer into Subsequent Release | ||
79 | ASSIGN_HI | HZUOR | HZUOR | NUMC | 2 | 0 | Assignment to Hierarchy | ||
80 | PMNT_BLOCK | SPERZ | XFELD | CHAR | 1 | 0 | Payment Block | ||
81 | LABCUSTGRP | ETIKG | ETIKG | CHAR | 10 | 0 | IS-R Labeling: customer/plant group | * | |
82 | NON_MILIT | CIVVE | XFELD | CHAR | 1 | 0 | ID for mainly non-military use | ||
83 | MILIT_USE | MILVE | XFELD | CHAR | 1 | 0 | ID for mainly military use | ||
84 | CUST_COND_GRP1 | KDKG1 | KDKGR | CHAR | 2 | 0 | Customer condition group 1 | * | |
85 | CUST_COND_GRP2 | KDKG2 | KDKGR | CHAR | 2 | 0 | Customer condition group 2 | * | |
86 | CUST_COND_GRP3 | KDKG3 | KDKGR | CHAR | 2 | 0 | Customer condition group 3 | * | |
87 | CUST_COND_GRP4 | KDKG4 | KDKGR | CHAR | 2 | 0 | Customer condition group 4 | * | |
88 | CUST_COND_GRP5 | KDKG5 | KDKGR | CHAR | 2 | 0 | Customer condition group 5 | * | |
89 | ALTPAYERAC | XKNZA | XFELD | CHAR | 1 | 0 | Indicator: Alternative payer using account number | ||
90 | TAX_TYPE | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | * | |
91 | TAX_NO_TY | J_1ATOID | J_1ATOID | CHAR | 2 | 0 | Tax Number Type | * | |
92 | TAX_NO_3 | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
93 | TAX_NO_4 | STCD4 | CHAR18 | CHAR | 18 | 0 | Tax Number 4 | ||
94 | NO_ICMS | J_1BTCICMS | XFELD | CHAR | 1 | 0 | Customer is ICMS-exempt | ||
95 | NO_IPI | J_1BTCIPI | XFELD | CHAR | 1 | 0 | Customer is IPI-exempt | ||
96 | SUBT_GRP | J_1BTCST | J_1BTCST1 | CHAR | 3 | 0 | Customer group for Substituiçao Tributária calculation | * | |
97 | CFOP_CAT | J_1BINDUS1 | J_1BINDUS1 | CHAR | 2 | 0 | Customer's CFOP category | ||
98 | TAXLAWICMS | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | 0 | Tax law: ICMS | * | |
99 | TAXLAWIPI | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | 0 | Tax law: IPI | * | |
100 | BCW | CCC01 | XFELD | CHAR | 1 | 0 | Indicator for biochemical warfare for legal control | ||
101 | NUCL_NONP | CCC02 | XFELD | CHAR | 1 | 0 | Indicator for nuclear nonproliferation for legal control | ||
102 | NATL_SEC | CCC03 | XFELD | CHAR | 1 | 0 | Indicator for national security for legal control | ||
103 | MISS_TECH | CCC04 | XFELD | CHAR | 1 | 0 | Indicator for missile technology for legal control | ||
104 | SALES_BLKG | CASSD_X | CASSP | CHAR | 2 | 0 | Central sales block for customer | ||
105 | URL | URL | TEXT132 | CHAR | 132 | 0 | Uniform resource locator | ||
106 | REP_NAME | REPRES | REPRES | CHAR | 10 | 0 | Name of Representative | ||
107 | BUS_TYPE | GESTYP | GESTYP | CHAR | 30 | 0 | Type of Business | * | |
108 | IND_TYPE | INDTYP | INDTYP | CHAR | 30 | 0 | Type of Industry | * | |
109 | CONF_ST | CONFS_X | CHAR1 | CHAR | 1 | 0 | Status of Change Authorization (Central) | ||
110 | CONF_DATE | UPDAT_RF | DATUM | DATS | 8 | 0 | Date on Which the Changes Were Confirmed | ||
111 | CONF_TIME | UPTIM_RF | AS4TIME | TIMS | 6 | 0 | Time of Last Change Confirmation | ||
112 | NO_DELETE | NODEL_X | XFELD | CHAR | 1 | 0 | Central deletion block for master record | ||
113 | CONSUMER | DEAR6 | XFELD | CHAR | 1 | 0 | Indicator: Consumer | ||
114 | .INCLU--AP | 0 | 0 | Append for BAPICUSTOMER_KNA1 | |||||
115 | TAX_NO_5 | STCD5 | CHAR60 | CHAR | 60 | 0 | Tax Number 5 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | WTYBRF_CUST_GEN | ACCNT_GRP | T077D | KTOKD | |||
2 | WTYBRF_CUST_GEN | CUSTOMER | KNA1 | KUNNR | |||
3 | WTYBRF_CUST_GEN | INDUSTRY | T016 | BRSCH | |||
4 | WTYBRF_CUST_GEN | WORK_TIME | TFACD | IDENT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |