SAP ABAP Table U_15170 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure U_15170   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client  
2 PLNUM PLNUM PLNUM CHAR 10   0   Planned order number  
3 MATNR PLMAT MATNR CHAR 18   0   Planning material MARA
4 PLWRK PLWRK WERKS CHAR 4   0   Planning Plant T001W
5 PWWRK PWWRK WERKS CHAR 4   0   Production plant in planned order T001W
6 PAART PAART PAART CHAR 4   0   Order type  
7 BESKZ BESKZ BESKZ CHAR 1   0   Procurement Type  
8 SOBES SOBES SOBES CHAR 1   0   Special procurement type  
9 GSMNG GSMNG MENG13 QUAN 13   3   Total planned order quantity  
10 TLMNG TLMNG MENG13 QUAN 13   3   Partial lot quantity  
11 AVMNG AVMNG MENG13 QUAN 13   3   Fixed quantity of scrap from production  
12 BDMNG BDMNG MENG13 QUAN 13   3   Requirement Quantity  
13 PSTTR PSTTR DATUM DATS 8   0   Order start date in planned order  
14 PEDTR PEDTR DATUM DATS 8   0   Order finish date in the planned order  
15 PERTR PERTR DATUM DATS 8   0   Planned opening date in planned order  
16 WEBAZ PLWEZ DEC3 DEC 3   0   Goods receipt processing time in days  
17 DISPO DISPO DISPO CHAR 3   0   MRP controller T024D
18 UMSKZ PLUMS XFELD CHAR 1   0   Conversion indicator for planned order  
19 AUFFX PLAFX XFELD CHAR 1   0   Firming indicator for planned order data  
20 STLFX PLSFX XFELD CHAR 1   0   Fixing indicator for BOM explosion  
21 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category T163K
22 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
23 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
24 KDEIN KDEIN NUM04 NUMC 4   0   Delivery schedule for sales order  
25 PROJN PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
26 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements  
27 QUNUM QUNUM QUNUM CHAR 10   0   Number of quota arrangement  
28 QUPOS QUPOS NUM03 NUMC 3   0   Quota arrangement item  
29 FLIEF FLIEF LIFNR CHAR 10   0   Fixed vendor LFA1
30 KONNR KONNR EBELN CHAR 10   0   Number of principal purchase agreement EKKO
31 KTPNR KTPNR EBELP NUMC 5   0   Item number of principal purchase agreement EKPO
32 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
33 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
34 NUMVR NUMVR NUMVR NUMC 2   0   Version number  
35 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
36 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
37 PSPEL PS_POSNR PS_POSNR NUMC 8   0   WBS Element  
38 SERNR SERNR SERNR CHAR 8   0   BOM explosion number SNUM
39 PALTR PALTR DATUM DATS 8   0   Explosion date  
40 TECHS TECHS TECHS CHAR 12   0   Parameter Variant/Standard Variant  
41 STLAN STLAN STLAN CHAR 1   0   BOM Usage  
42 STALT STALT ALTNR CHAR 2   0   Alternative BOM  
43 STSTA STLST STLST NUMC 2   0   BOM Statuses T415S
44 AENNR AENNR AENNR CHAR 12   0   Change Number  
45 ARSNR ARSNR MDNUM NUMC 10   0   Settlement reservation number  
46 ARSPS ARSPS RSPOS NUMC 4   0   Item number of the settlement reservation  
47 VERTO SA_VERTO SA_VERTL CHAR 4   0   Distribution key for quantity produced T437V
48 VERID VERID VERID CHAR 4   0   Production Version MKAL
49 AUFNR SA_AUFNR SA_AUFNR CHAR 12   0   Run schedule header number SAFK
50 TRART TRART CHAR1 CHAR 1   0   Scheduling type of the planned order  
51 PLGRP FEVOR FEVOR CHAR 3   0   Production Supervisor T024F
52 TERST TERST DATUM DATS 8   0   Start date for production  
53 TERED TERED DATUM DATS 8   0   Finish date for production  
54 BEDID BEDID BEDID NUMC 12   0   ID of the capacity requirements record  
55 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
56 TRMKZ TRMFL XFELD CHAR 1   0   Scheduling indicator  
57 TRMER TRMER TRMER CHAR 2   0   Scheduling error  
58 REDKZ REDKZ REDKZ CHAR 1   0   Reduction indicator for scheduling  
59 TRMHK TRMHK TRMHK CHAR 1   0   Scheduling source  
60 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
61 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
62 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type  
63 FRTHW FRTHW FRTHW CHAR 1   0   Production note in the planned order  
64 RGEKZ CO_RGEKZ CO_RGEKZ CHAR 1   0   Indicator: Backflushing for order  
65 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
66 CUOBJ CUOBJ CUOBJ NUMC 18   0   Configuration (internal object number)  
67 REVLV REVLV REVLV CHAR 2   0   Revision level  
68 ABMNG ABMNG MENGE QUAN 13   3   Reduced quantity in the planned order  
69 RATID RATID BEDID NUMC 12   0   Index for the results of scheduling production rates  
70 GROID GROID BEDID NUMC 12   0   Index for rough scheduling results  
71 RATER RATER TRMER CHAR 2   0   Scheduling error in scheduling production rates  
72 GROER GROER TRMER CHAR 2   0   Scheduling error in rough scheduling  
73 OBART OBART OBART CHAR 1   0   Object type  
74 PLSCN PLSCN PLSCN NUMC 3   0   Planning Scenario of Long-Term Planning PLSC
75 SBNUM SBNUM SBNUM NUMC 10   0   Simulation requirements number  
76 KBNKZ KBNKZ KBNKZ CHAR 1   0   Kanban Indicator  
77 KAPFX KAPFX XFELD CHAR 1   0   Indicator: capacity for planned order dispatched  
78 SEQNR CY_SEQNR CY_SEQNR NUMC 14   0   Seq. number order  
79 PSTTI PSTTI UZEIT TIMS 6   0   Start Time of Planned Order  
80 PEDTI PEDTI UZEIT TIMS 6   0   End Time of Planned Order  
81 MONKZ MONKZ XFELD CHAR 1   0   Indicator: for assembly order procedures  
82 PRNKZ PRNKZ KREUZ CHAR 1   0   Ind.: Leading order in collective order is planned ordre  
83 MDPBV MDPBV MDPBV CHAR 1   0   Planned order: confirmation of availability  
84 VFMNG VFMNG MENG13 QUAN 13   3   Planned order: committed quantity  
85 MDACH MDACH MDACH CHAR 2   0   Action control: planned order processing T46AC
86 MDACC MDACC MDACC CHAR 4   0   Action: planned order processing T46AS
87 MDACD MDACD DATUM DATS 8   0   Date of action: planned order  
88 MDACT MDACT UZEIT TIMS 6   0   Time of action: Planned order processing  
89 GSBTR GSBTR_PLAF DATUM DATS 8   0   Total commitment date of plnd ord. after ATP check f.comps.  
90 PLETX PLETX XFELD CHAR 1   0   Planned order shift quantities exist  
91 PRSCH MD_PRSCHED XFELD CHAR 1   0   Planned order: scheduling using production dates  
92 LVSCH MD_LVSCHED SCHED_TYPE CHAR 1   0   Planned order: leading scheduling level (determines dates)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 U_15170 AUFNR SAFK AUFNR REF C CN
2 U_15170 DISPO T024D DISPO KEY 1 CN
3 U_15170 EKORG T024E EKORG REF C CN
4 U_15170 FLIEF LFA1 LIFNR REF C CN
5 U_15170 KDAUF VBUK VBELN KEY 1 CN
6 U_15170 KNTTP T163K KNTTP KEY 1 CN
7 U_15170 KONNR EKKO EBELN REF C CN
8 U_15170 KTPNR EKPO EBELP REF C CN
9 U_15170 LGORT T001L LGORT KEY 1 CN
10 U_15170 MATNR MARA MATNR KEY 1 CN
11 U_15170 MDACC T46AS MDACC 1 CN
12 U_15170 MDACH T46AC MDACH REF 1 CN
13 U_15170 MEINS T006 MSEHI REF 1 CN
14 U_15170 PLGRP T024F FEVOR KEY 1 CN
15 U_15170 PLSCN PLSC PLSCN    
16 U_15170 PLWRK T001W WERKS KEY 1 CN
17 U_15170 PWWRK T001W WERKS KEY 1 CN
18 U_15170 SERNR SNUM SERNR REF C C
19 U_15170 SOBKZ T148 SOBKZ    
20 U_15170 STSTA T415S STLST REF C CN
21 U_15170 VERID MKAL VERID REF C CN
22 U_15170 VERTO T437V VERTL KEY 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in