SAP Table V_T001W_BWKEY
Generated Table for View
V_T001W_BWKEY (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link V_T001W_BWKEY to other SAP tables.
V_T001W_BWKEY table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| BWKEY | Valuation Area | BWKEY | T001K | CHAR | 4 | 0 | ||||||||
| WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||
| NAME1 | Name | NAME1 | CHAR | 30 | 0 | |||||||||
| NAME2 | Name 2 | NAME2 | CHAR | 30 | 0 | |||||||||
| STRAS | House number and street | STRAS | CHAR | 30 | 0 | |||||||||
| PFACH | PO Box | PFACH | CHAR | 10 | 0 | |||||||||
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||||||||
| ORT01 | City | ORT01 | CHAR | 25 | 0 | |||||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||
| VKORG | Sales organization for intercompany billing | VKOIV | TVKO | CHAR | 4 | 0 | ||||||||
| CHAZV | Indicator: batch status management active | CHAZV | CHAR | 1 | 0 |
Possible values
|
||||||||
| FABKL | Factory calendar key | FABKL | TFACD | CHAR | 2 | 0 | ||||||||
| KKOWK | Indicator: Conditions at plant level | KKOWK | CHAR | 1 | 0 |
Possible values
|
||||||||
| KORDB | Indicator: Source list requirement | KORDB | CHAR | 1 | 0 |
Possible values
|
||||||||
| BEDPL | Activating requirements planning | BEDPL | CHAR | 1 | 0 |
Possible values
|
||||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| REGIO | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||
| COUNC | County Code | COUNC | T005E | CHAR | 3 | 0 | ||||||||
| CITYC | City Code | CITYC | T005G | CHAR | 4 | 0 | ||||||||
| ADRNR | Address | ADRNR | CHAR | 10 | 0 | |||||||||
| IWERK | Maintenance Planning Plant | IWERK | T001W | CHAR | 4 | 0 | ||||||||
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 | 0 | ||||||||
| VTWEG | Distribution channel for intercompany billing | VTWIV | TVTW | CHAR | 2 | 0 | ||||||||
| SPART | Division for intercompany billing | SPAIV | TSPA | CHAR | 2 | 0 | ||||||||
| KUNNR | Customer number of plant | KUNNR_WK | KNA1 | CHAR | 10 | 0 | ||||||||
| SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| WKSOP | SOP plant | WKSOP | CHAR | 1 | 0 |
Possible values
|
||||||||
| AWSLS | Variance Key | AWSLS | TKV01 | CHAR | 6 | 0 | ||||||||
| CHAZV_OLD | Indicator: batch status management active | CHAZV | CHAR | 1 | 0 |
Possible values
|
||||||||
| VLFKZ | Plant category | VLFKZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| LIFNR | Vendor number of plant | LIFNR_WK | LFA1 | CHAR | 10 | 0 | ||||||||
| BZIRK | Sales district | BZIRK | T171 | CHAR | 6 | 0 | ||||||||
| ZONE1 | Supply region (region supplied) | LFREG | TZONE | CHAR | 10 | 0 | ||||||||
| TAXIW | Tax Indicator: Plant (Purchasing) | TAXIW1 | TMKW1 | CHAR | 1 | 0 | ||||||||
| BZQHL | Take regular vendor into account | BZQHL | CHAR | 1 | 0 |
Possible values
|
||||||||
| LET01 | Number of Days for First Reminder/Expediter | MAHN1 | DEC | 3 | 0 | |||||||||
| LET02 | Number of Days for Second Reminder/Expediter | MAHN2 | DEC | 3 | 0 | |||||||||
| LET03 | Number of Days for Third Reminder/Expediter | MAHN3 | DEC | 3 | 0 | |||||||||
| TXNAM_MA1 | Text name of 1st dunning of vendor declarations | TXNAM_MA1 | CHAR | 16 | 0 | |||||||||
| TXNAM_MA2 | Text name of the 2nd dunning of vendor declarations | TXNAM_MA2 | CHAR | 16 | 0 | |||||||||
| TXNAM_MA3 | Text name of 3rd dunning of vendor declarations | TXNAM_MA3 | CHAR | 16 | 0 | |||||||||
| BETOL | Number of days for PO tolerance - Compress info records - SU | BETOL | NUMC | 3 | 0 | |||||||||
| J_1BBRANCH | Business Place | J_1BBRANC_ | J_1BBRANCH | CHAR | 4 | 0 | ||||||||
| VTBFI | Rule for determining the sales area for stock transfers | VTBFI | CHAR | 2 | 0 |
Possible values
|
||||||||
| FPRFW | Distribution profile at plant level | FPRFW | TWFPF | CHAR | 3 | 0 | ||||||||
| ACHVM | Central archiving marker for master record | ACHVM_X | CHAR | 1 | 0 |
Possible values
|
||||||||
| DVSART | Batch Record: Type of DMS Used | DVSART | CHAR | 1 | 0 |
Possible values
|
||||||||
| NODETYPE | Node type: supply chain network | NODETYPE | MDRP_NODT | CHAR | 3 | 0 | ||||||||
| NSCHEMA | Structure for name formation | CKML_NSCHEMA | CKMLMV007 | CHAR | 4 | 0 | ||||||||
| PKOSA | Cost Object Controlling linking active | CKML_FLG_PKOSA | CHAR | 1 | 0 |
Possible values
|
||||||||
| MISCH | Updating is active for mixed costing | CKML_FLG_MISCH | CHAR | 1 | 0 |
Possible values
|
||||||||
| MGVUPD | Updating is active in actual costing | CKML_FLG_MGVUPD | CHAR | 1 | 0 |
Possible values
|
||||||||
V_T001W_BWKEY foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_T001W_BWKEY | AWSLS | V_T001W_BWKEY | MANDT | TKV01 | Variance Keys: Cost Centers/Costing | MANDT |
| V_T001W_BWKEY | AWSLS | 'OR' | TKV01 | Variance Keys: Cost Centers/Costing | AWOBA | |
| V_T001W_BWKEY | AWSLS | V_T001W_BWKEY | AWSLS | TKV01 | Variance Keys: Cost Centers/Costing | AWSLS |
| V_T001W_BWKEY | BWKEY | V_T001W_BWKEY | BWKEY | T001K | Valuation area | BWKEY |
| V_T001W_BWKEY | BWKEY | V_T001W_BWKEY | MANDT | T001K | Valuation area | MANDT |
| V_T001W_BWKEY | BZIRK | V_T001W_BWKEY | MANDT | T171 | Customers: Sales Districts | MANDT |
| V_T001W_BWKEY | BZIRK | V_T001W_BWKEY | BZIRK | T171 | Customers: Sales Districts | BZIRK |
| V_T001W_BWKEY | CITYC | V_T001W_BWKEY | LAND1 | T005G | City | LAND1 |
| V_T001W_BWKEY | CITYC | V_T001W_BWKEY | REGIO | T005G | City | REGIO |
| V_T001W_BWKEY | CITYC | V_T001W_BWKEY | CITYC | T005G | City | CITYC |
| V_T001W_BWKEY | CITYC | V_T001W_BWKEY | MANDT | T005G | City | MANDT |
| V_T001W_BWKEY | COUNC | V_T001W_BWKEY | MANDT | T005E | County | MANDT |
| V_T001W_BWKEY | COUNC | V_T001W_BWKEY | LAND1 | T005E | County | LAND1 |
| V_T001W_BWKEY | COUNC | V_T001W_BWKEY | REGIO | T005E | County | REGIO |
| V_T001W_BWKEY | COUNC | V_T001W_BWKEY | COUNC | T005E | County | COUNC |
| V_T001W_BWKEY | EKORG | V_T001W_BWKEY | MANDT | T024E | Purchasing Organizations | MANDT |
| V_T001W_BWKEY | EKORG | V_T001W_BWKEY | EKORG | T024E | Purchasing Organizations | EKORG |
| V_T001W_BWKEY | FABKL | V_T001W_BWKEY | FABKL | TFACD | Factory calendar definition | IDENT |
| V_T001W_BWKEY | FPRFW | V_T001W_BWKEY | FPRFW | TWFPF | Plant Profiles for Merchandise Distribution | FPRFW |
| V_T001W_BWKEY | FPRFW | V_T001W_BWKEY | MANDT | TWFPF | Plant Profiles for Merchandise Distribution | MANDT |
| V_T001W_BWKEY | IWERK | V_T001W_BWKEY | MANDT | T001W | Plants/Branches | MANDT |
| V_T001W_BWKEY | IWERK | V_T001W_BWKEY | IWERK | T001W | Plants/Branches | WERKS |
| V_T001W_BWKEY | J_1BBRANCH | V_T001W_BWKEY | MANDT | J_1BBRANCH | Business Place | MANDT |
| V_T001W_BWKEY | J_1BBRANCH | * | J_1BBRANCH | Business Place | BUKRS | |
| V_T001W_BWKEY | J_1BBRANCH | V_T001W_BWKEY | J_1BBRANCH | J_1BBRANCH | Business Place | BRANCH |
| V_T001W_BWKEY | KUNNR | V_T001W_BWKEY | MANDT | KNA1 | General Data in Customer Master | MANDT |
| V_T001W_BWKEY | KUNNR | V_T001W_BWKEY | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| V_T001W_BWKEY | LAND1 | V_T001W_BWKEY | MANDT | T005 | Countries | MANDT |
| V_T001W_BWKEY | LAND1 | V_T001W_BWKEY | LAND1 | T005 | Countries | LAND1 |
| V_T001W_BWKEY | LIFNR | V_T001W_BWKEY | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| V_T001W_BWKEY | LIFNR | V_T001W_BWKEY | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| V_T001W_BWKEY | MANDT | V_T001W_BWKEY | MANDT | T000 | Clients | MANDT |
| V_T001W_BWKEY | NODETYPE | V_T001W_BWKEY | NODETYPE | MDRP_NODT | Node Type for DRP Network | NODETYPE |
| V_T001W_BWKEY | NSCHEMA | V_T001W_BWKEY | MANDT | CKMLMV007 | Name formation (structure table) | MANDT |
| V_T001W_BWKEY | NSCHEMA | V_T001W_BWKEY | NSCHEMA | CKMLMV007 | Name formation (structure table) | NSCHEMA |
| V_T001W_BWKEY | REGIO | V_T001W_BWKEY | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| V_T001W_BWKEY | REGIO | V_T001W_BWKEY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| V_T001W_BWKEY | REGIO | V_T001W_BWKEY | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| V_T001W_BWKEY | SPART | V_T001W_BWKEY | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| V_T001W_BWKEY | SPART | V_T001W_BWKEY | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| V_T001W_BWKEY | SPRAS | V_T001W_BWKEY | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
| V_T001W_BWKEY | TAXIW | V_T001W_BWKEY | TAXIW | TMKW1 | Taxes: Plant (Purchasing) | TAXIW |
| V_T001W_BWKEY | TAXIW | V_T001W_BWKEY | MANDT | TMKW1 | Taxes: Plant (Purchasing) | MANDT |
| V_T001W_BWKEY | TAXIW | V_T001W_BWKEY | LAND1 | TMKW1 | Taxes: Plant (Purchasing) | LAND1 |
| V_T001W_BWKEY | TXJCD | V_T001W_BWKEY | TXJCD | TTXJ | Check Table for Tax Jurisdiction | TXJCD |
| V_T001W_BWKEY | TXJCD | V_T001W_BWKEY | MANDT | TTXJ | Check Table for Tax Jurisdiction | MANDT |
| V_T001W_BWKEY | TXJCD | T005 | KALSM | TTXJ | Check Table for Tax Jurisdiction | KALSM |
| V_T001W_BWKEY | VKORG | V_T001W_BWKEY | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| V_T001W_BWKEY | VKORG | V_T001W_BWKEY | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| V_T001W_BWKEY | VTWEG | V_T001W_BWKEY | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| V_T001W_BWKEY | VTWEG | V_T001W_BWKEY | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| V_T001W_BWKEY | ZONE1 | V_T001W_BWKEY | MANDT | TZONE | Customers: Regional zones | MANDT |
| V_T001W_BWKEY | ZONE1 | V_T001W_BWKEY | LAND1 | TZONE | Customers: Regional zones | LAND1 |
| V_T001W_BWKEY | ZONE1 | V_T001W_BWKEY | ZONE1 | TZONE | Customers: Regional zones | ZONE1 |
