SE11 ABAP Dictionary SE11 T001W

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

T001W

Plants/Branches
SAP SAP Transparent Table 62 Fields
Primary Key:
MANDT WERKS

Dictionary Fields Fields

(62 dari 62 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
WERKS
KEY Plant CHAR 4 - T001W Plant
3
NAME1
- Name 1 CHAR 30 - - Name
4
BWKEY
- Val. Area CHAR 4 - - Valuation Area
5
KUNNR
- CustNoPlnt CHAR 10 - KNA1 Customer number of plant
6
LIFNR
- VendNoPlnt CHAR 10 - LFA1 Vendor number of plant
7
FABKL
- Calendar CHAR 2 - - Factory calendar key
8
NAME2
- Name 2 CHAR 30 - - Name 2
9
STRAS
- Street CHAR 30 - - House number and street
10
PFACH
- PO Box CHAR 10 - - PO Box
11
PSTLZ
- Post.Code CHAR 10 - - Postal Code
12
ORT01
- City CHAR 25 - - City
13
EKORG
- Purch.Org. CHAR 4 - - Purchasing Organization
14
VKORG
- SlsOrgIV CHAR 4 - - Sales organization for intercompany billing
15
CHAZV
- BS mgmt CHAR 1 - - Indicator: batch status management active
16
KKOWK
- Cond.plnt CHAR 1 - - Indicator: Conditions at plant level
17
KORDB
- Srce.list CHAR 1 - - Indicator: Source list requirement
18
BEDPL
- ReqmtsPlng CHAR 1 - - Activating requirements planning
19
LAND1
- Country CHAR 3 - T005 Country Key
20
REGIO
- Region CHAR 3 - - Region (State, Province, County)
21
COUNC
- County cde CHAR 3 - - County Code
22
CITYC
- City code CHAR 4 - - City Code
23
ADRNR
- Address CHAR 10 - - Address
24
IWERK
- Plng plant CHAR 4 - - Maintenance Planning Plant
25
TXJCD
- Tax Jur. CHAR 15 - - Tax Jurisdiction
26
VTWEG
- DistrCh.IV CHAR 2 - - Distribution channel for intercompany billing
27
SPART
- Div. IV CHAR 2 - - Division for intercompany billing
28
SPRAS
- Language LANG 1 - T002 Language Key
29
WKSOP
- SOP plant CHAR 1 - - SOP plant
30
AWSLS
- Var. key CHAR 6 - - Variance Key
31
CHAZV_OLD
- BS mgmt CHAR 1 - - Indicator: batch status management active
32
VLFKZ
- Plant cat. CHAR 1 - - Plant category
33
BZIRK
- District CHAR 6 - - Sales district
34
ZONE1
- Region CHAR 10 - - Supply region (region supplied)
35
TAXIW
- TaxIndPlnt CHAR 1 - - Tax Indicator: Plant (Purchasing)
36
BZQHL
- Reg. vend. CHAR 1 - - Take regular vendor into account
37
LET01
- Reminder 1 DEC 3 - - Number of Days for First Reminder/Expediter
38
LET02
- Reminder 2 DEC 3 - - Number of Days for Second Reminder/Expediter
39
LET03
- Reminder 3 DEC 3 - - Number of Days for Third Reminder/Expediter
40
TXNAM_MA1
- Text1stDun CHAR 16 - - Text name of 1st dunning of vendor declarations
41
TXNAM_MA2
- Text2ndDun CHAR 16 - - Text name of the 2nd dunning of vendor declarations
42
TXNAM_MA3
- Text3rdDun CHAR 16 - - Text name of 3rd dunning of vendor declarations
43
BETOL
- PO toler. NUMC 3 - - Number of days for PO tolerance - Compress info records - SU
44
J_1BBRANCH
- Bus. Place CHAR 4 - - Business Place
45
VTBFI
- Sales area CHAR 2 - - Rule for determining the sales area for stock transfers
46
FPRFW
- Dist.prof. CHAR 3 - - Distribution profile at plant level
47
ACHVM
- Arch.markr CHAR 1 - - Central archiving marker for master record
48
DVSART
- DMS type CHAR 1 - - Batch Record: Type of DMS Used
49
NODETYPE
- Node type CHAR 3 - - Node type: supply chain network
50
NSCHEMA
- NamingStrc CHAR 4 - - Structure for name formation
51
PKOSA
- CostObject CHAR 1 - - Cost Object Controlling linking active
52
MISCH
- Mixed cstg CHAR 1 - - Updating is active for mixed costing
53
MGVUPD
- Act. cstg CHAR 1 - - Updating is active in actual costing
54
VSTEL
- Ship Point CHAR 4 - - Shipping Point/Receiving Point
55
MGVLAUPD
- Act.activi CHAR 1 - - Update of Activity Consumption in the Quantity Structure
56
MGVLAREVAL
- CreditCCt CHAR 1 - - Control of Credit of Cost Centers
57
SOURCING
- AFSD CHAR 1 - - Invoke Added-Function Source Determination via ATP
58
OILIVAL
- Exg. val. CHAR 1 - - Exchange valuation indicator
59
OIHVTYPE
- Vend.type. CHAR 1 - - Vendor type (refinery/mill/other) (Brazil)
60
OIHCREDIPI
- Cred IPI? CHAR 1 - - IPI credit allowed
61
STORETYPE
- Store Cat CHAR 1 - - Store Category to Differentiate Store, Dep. Store, Shop
62
DEP_STORE
- S-DS CHAR 4 - - Superior Department Store

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk T001W.

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes
SE11 SE16
Related Tables
KNA1 LFA1 T005 T002
ANSI SQL Query 
SELECT a.WERKS,
       a.NAME1,
       a.BWKEY,
       a.KUNNR,
       a.LIFNR,
       a.FABKL
FROM T001W AS a
WHERE a.WERKS = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~werks,
       a~name1,
       a~bwkey,
       a~kunnr,
       a~lifnr,
       a~fabkl
  FROM t001w AS a
  WHERE a~werks = '0001'
  INTO TABLE @DATA(lt_t001w)
  UP TO 100 ROWS.