SAP ABAP Table T5DB6 (Construction Site File: Order)
Hierarchy
☛
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
⤷ PY-DE-CI (Application Component) Construction Industry
⤷ P01B (Package) Payroll: Construction Industry
⤷ PY-DE-CI (Application Component) Construction Industry
⤷ P01B (Package) Payroll: Construction Industry
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | T5DB6 | Table Relationship Diagram |
Short Description | Construction Site File: Order |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
3 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
4 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
5 | .INCLUDE | 0 | 0 | Include Structure for Construction Site Fields | |||||
6 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
7 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
8 | BENDD | P01B_BENDD | DATUM | DATS | 8 | 0 | End of Construction | ||
9 | BBEGD | P01B_BEGDD | DATUM | DATS | 8 | 0 | Beginning of construction | ||
10 | BALEI | P01B_BALEI | TEXT25 | CHAR | 25 | 0 | Construction Site Supervisor | ||
11 | PERNR | P01B_PERNR | PERSNO | NUMC | 8 | 0 | Personnel Number | PA0003 | |
12 | GMDN1 | GMNDN | GMNDN | NUMC | 8 | 0 | Municipality Number (D) | T5D2B | |
13 | GMDP1 | P01B_GMDPR | DEC3_2 | DEC | 5 | 2 | Percentage Rate of Trade Tax for Municipality | ||
14 | GMDN2 | GMNDN | GMNDN | NUMC | 8 | 0 | Municipality Number (D) | T5D2B | |
15 | GMDP2 | P01B_GMDPR | DEC3_2 | DEC | 5 | 2 | Percentage Rate of Trade Tax for Municipality | ||
16 | GMDN3 | GMNDN | GMNDN | NUMC | 8 | 0 | Municipality Number (D) | T5D2B | |
17 | GMDP3 | P01B_GMDPR | DEC3_2 | DEC | 5 | 2 | Percentage Rate of Trade Tax for Municipality | ||
18 | BULND | BULND | REGIO | CHAR | 3 | 0 | State | T005S | |
19 | STSPA | P01B_STSPA | P013_STSPA | CHAR | 4 | 0 | Division of State Statistics Office | ||
20 | BRFGN | P015_BRFGN | P015_BRFGN | CHAR | 2 | 0 | Workers' Compensation Association | T5D3A | |
21 | GFTGE | P01B_GFTGE | P015_GFTST | CHAR | 2 | 0 | Hazard Pay Area: Industrial Workers | T5D3B | |
22 | GFTAN | P01B_GFTAN | P015_GFTST | CHAR | 2 | 0 | Hazard Pay Area Employees | T5D3B | |
23 | BRFGP | P01B_BRFGP | DEC3_2 | DEC | 5 | 2 | Workers' Compensation Association Percentage | ||
24 | STRAS | STRAS | TEXT30 | CHAR | 30 | 0 | House number and street | ||
25 | ORT01 | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
26 | ORT02 | ORT02 | TEXT25 | CHAR | 25 | 0 | District | ||
27 | PSTLZ | PSTLZ_HR | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
28 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
29 | TELNR | TELNR | TELNR | CHAR | 14 | 0 | Telephone Number | ||
30 | MOFID | HIDENT | HIDENT | CHAR | 2 | 0 | Public Holiday Calendar | THOCI | |
31 | BASCH | P01B_BASC1 | SCHKN | CHAR | 8 | 0 | Work schedule rule | T508A | |
32 | MEHKN | P01B_MEHKN | P01B_MEHKN | CHAR | 2 | 0 | Overtime Rule | ||
33 | RUEST | P01B_RUEST | DEC3_2 | DEC | 5 | 2 | Setup time | ||
34 | BSA01 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
35 | BSA02 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
36 | BSA03 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
37 | BSA04 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
38 | BSA05 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
39 | BSA06 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
40 | BSA07 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
41 | BSA08 | P01B_BSATT | P01B_BSATT | CHAR | 2 | 0 | Attributes | T5DBH | |
42 | ARGEN | P01B_ARGEN | P01B_ARGEN | NUMC | 6 | 0 | Work Cooperative | T5DB0 | |
43 | BGKAG | P01B_BGKAG | CHAR10 | CHAR | 10 | 0 | WCA Company Number: Risk Category (Salaried Employees) | ||
44 | BGKGW | P01B_BGKGW | CHAR10 | CHAR | 10 | 0 | WCA Company Number: Risk Category (Industrial Workers) | ||
45 | REIZI | P01B_REIZI | CHAR10 | CHAR | 10 | 0 | Destination / Construction Industry Expenses | T5DB_REISEZIEL |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | T5DB6 | ARGEN | T5DB0 | ARGEM | REF | 1 | CN |
2 | T5DB6 | AUFNR | AUFK | AUFNR | KEY | 1 | CN |
3 | T5DB6 | BASCH | T508A | SCHKZ | REF | C | CN |
4 | T5DB6 | BRFGN | T5D3A | BRFGN | REF | C | CN |
5 | T5DB6 | BSA01 | T5DBH | BSATT | REF | C | CN |
6 | T5DB6 | BSA02 | T5DBH | BSATT | C | CN | |
7 | T5DB6 | BSA03 | T5DBH | BSATT | REF | C | CN |
8 | T5DB6 | BSA04 | T5DBH | BSATT | REF | C | CN |
9 | T5DB6 | BSA05 | T5DBH | BSATT | REF | C | CN |
10 | T5DB6 | BSA06 | T5DBH | BSATT | REF | C | CN |
11 | T5DB6 | BSA07 | T5DBH | BSATT | REF | C | CN |
12 | T5DB6 | BSA08 | T5DBH | BSATT | REF | C | CN |
13 | T5DB6 | BULND | T005S | BLAND | REF | C | CN |
14 | T5DB6 | GFTAN | T5D3B | GFTST | REF | C | CN |
15 | T5DB6 | GFTGE | T5D3B | GFTST | REF | C | CN |
16 | T5DB6 | GMDN1 | T5D2B | GMDNR | REF | 1 | CN |
17 | T5DB6 | GMDN2 | T5D2B | GMDNR | REF | 1 | CN |
18 | T5DB6 | GMDN3 | T5D2B | GMDNR | REF | 1 | CN |
19 | T5DB6 | LAND1 | T005 | LAND1 | REF | 1 | CN |
20 | T5DB6 | MANDT | T000 | MANDT | KEY | 1 | CN |
21 | T5DB6 | MOFID | THOCI | IDENT | REF | C | CN |
22 | T5DB6 | PERNR | PA0003 | PERNR | REF | 1 | CN |
23 | T5DB6 | REIZI | T5DB_REISEZIEL | REIZI | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |