SAP ABAP Table AFRUI (PSIS - Individual Overviews: Confirmations)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ PS-IS-REP-LOG (Application Component) Logistics
⤷ PSIS_SINGLE (Package) PS Logistic Overview: Single Overview'
⤷ PS-IS-REP-LOG (Application Component) Logistics
⤷ PSIS_SINGLE (Package) PS Logistic Overview: Single Overview'
Basic Data
Table Category | INTTAB | Structure |
Structure | AFRUI | Table Relationship Diagram |
Short Description | PSIS - Individual Overviews: Confirmations |
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 | .INCLUDE | 0 | 0 | Order Confirmation Structure for Project Reporting | |||||
2 | ARNUMMER | ADMI_RUN_D | ADMI_RUN | CHAR | 6 | 0 | Archiving Session Number | ||
3 | VSGRUPPE | VSGRUPPE | TEXT20 | CHAR | 20 | 0 | Group for a project version | ||
4 | VSNUMMER | VSNMR | VSNMR | CHAR | 12 | 0 | Number or description of a version | ||
5 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
6 | PRNAM | IM_PRNAM | IM_PRNAM | CHAR | 8 | 0 | Investment program name | IMTP | |
7 | PRPOS | IM_POSID | IM_POSID | CHAR | 24 | 0 | Identification for an investment program position | ||
8 | PSPID | PS_PSPID | PS_PSPID | CHAR | 24 | 0 | Project definition | ||
9 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
10 | KDAUF | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | VBUK | |
11 | KDPOS | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | VBUP | |
12 | AUFNR | AUF_NETNR | AUFNR | CHAR | 12 | 0 | Order/Network number | AUFK | |
13 | VORNR | CN_VORNR | VORNR | CHAR | 4 | 0 | Activity number in network and standard network | ||
14 | UVORN | CN_ELEMENT | VORNR | CHAR | 4 | 0 | Activity element number (work/external/general costs) | ||
15 | RUECK | CO_RUECK | CO_RUECK | NUMC | 10 | 0 | Completion confirmation number for the operation | ||
16 | RMZHL | CO_RMZHL | CIM_COUNT | NUMC | 8 | 0 | Confirmation counter | ||
17 | AUTYPTXT | AUTYPTEXT | TEXT40 | CHAR | 40 | 0 | Display field for order category description | ||
18 | ERSDA | ERSDA | DATUM | DATS | 8 | 0 | Created On | ||
19 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
20 | LAEDA | LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
21 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
22 | BUDAT | BUCHDATUM | DATUM | DATS | 8 | 0 | Posting date | ||
23 | ARBPL | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
24 | ARBTXT | PS_ARBTEXT | TEXT40 | CHAR | 40 | 0 | Short text for the CIM operating resource | ||
25 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
26 | LTXA1 | CO_RTEXT | TEXT40 | CHAR | 40 | 0 | Confirmation text | ||
27 | TXTSP | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
28 | ABARB | CO_ABARB | CO_ABARB | NUMC | 3 | 0 | Confirmation: Degree of processing | ||
29 | ISMNW | PS_IARBEI_VZ | PS_ARBEIT_VZ | QUAN | 13 | 3 | Actual work | ||
30 | ISMNE | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | T006 | |
31 | LEARR | LEARR | LSTAR | CHAR | 6 | 0 | Activity type for confirmation | CSLA | |
32 | IDAUR | PS_IDAUER_VZ | PS_DAUER_VZ | QUAN | 10 | 1 | Actual duration | ||
33 | IDAUE | IDAURE | MEINS | UNIT | 3 | 0 | Unit for actual duration | T006 | |
34 | GRUND | CO_AGRND | CO_AGRND | CHAR | 4 | 0 | Reason for Variance | TRUG | |
35 | PERNR | CO_PERNR | PERNR | NUMC | 8 | 0 | Personnel number | ||
36 | PERTXT | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
37 | ISDD | ISDD | DATUM | DATS | 8 | 0 | Actual start: Execution (date) | ||
38 | ISDZ | ISDZ | ATIME | TIMS | 6 | 0 | Actual start: Execution/setup (time) | ||
39 | IEDD | IEDD | DATUM | DATS | 8 | 0 | Actual finish: Execution (date) | ||
40 | IEDZ | IEDZ | ATIME | TIMS | 6 | 0 | Actual finish: Execution (time) | ||
41 | PEDD | CO_PEDD | DATUM | DATS | 8 | 0 | Forecast finish date of operation from confirmation | ||
42 | PEDZ | CO_PEDZ | ATIME | TIMS | 6 | 0 | Forecast finish time of operation from confirmation | ||
43 | AUERU | AUERU | AUERU_VS | CHAR | 1 | 0 | Activation of Final Confirmation | ||
44 | MANUR | MANUR | MANUR | CHAR | 1 | 0 | Indicator for type of confirmation | ||
45 | OFMNW | PS_RARBEI_VZ | PS_ARBEIT_VZ | QUAN | 13 | 3 | Remaining work | ||
46 | OFMNE | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | T006 | |
47 | LEKNW | CO_LEIKZ | XFELD | CHAR | 1 | 0 | Indicator: No remaining activity expected | ||
48 | ODAUR | PS_RDAUER_VZ | PS_DAUER_VZ | QUAN | 10 | 1 | Remaining duration | ||
49 | ODAUE | ODAUE | MEINS | UNIT | 3 | 0 | Unit for remaining duration | T006 | |
50 | STOKZ | CO_STOKZ | FLAG | CHAR | 1 | 0 | Indicator: Document Has Been Reversed | ||
51 | STZHL | CO_STZHL | CIM_COUNT | NUMC | 8 | 0 | Confirmation counter of cancelled confirmation | ||
52 | KAPNM | KAPNAME | KAPNAME | CHAR | 8 | 0 | Capacity name | ||
53 | KAPTXT | KAPTEXT | TEXT40 | CHAR | 40 | 0 | Capacity short text | ||
54 | KAPAR | KAPART | KAPART | CHAR | 3 | 0 | Capacity category | TC26 | |
55 | KAPARTXT | KAPARTTEXT | TEXT20 | CHAR | 20 | 0 | Description of the capacity category | ||
56 | SPLIT | CY_SPLIT | INT1 | INT1 | 3 | 0 | Split number | ||
57 | ZAUSW | DZAUSW | ZAUSW | NUMC | 8 | 0 | Time Recording ID Number | ||
58 | CATSBELNR | CATSBELNR | BELNR | CHAR | 10 | 0 | Document number | ||
59 | CATSPRICE | CATSPRICE | WERTV6 | CURR | 11 | 2 | Price in Transaction Currency | ||
60 | CATSTCURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | * | |
61 | CATSPEINH | PEINH | PACK3 | DEC | 5 | 0 | Price unit | ||
62 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | TBMOT | |
63 | IPRZ1 | RU_IPRZS | MENGV13 | QUAN | 13 | 3 | Current quantity to be confirmed for the business process | ||
64 | IPRE1 | RU_IPRZE | MEINS | UNIT | 3 | 0 | Unit of measurement for conf. quantity for business process | T006 | |
65 | IPRK1 | RU_IPRZK | XFELD | CHAR | 1 | 0 | No remaining quantity expected for business process | ||
66 | PRZ01 | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
67 | OPRZ1 | OPRZ1 | MENGV13 | QUAN | 13 | 3 | Remaining quantity for business process | ||
68 | OPRE1 | OPRE1 | MEINS | UNIT | 3 | 0 | Unit for remaining quantity of business process | T006 | |
69 | SKOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
70 | SKOSTL | SKOSTL | KOSTL | CHAR | 10 | 0 | Sender Cost Center | * | |
71 | ISMNU | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | * | |
72 | OFMNU | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | * | |
73 | INT_ID | OBJEKT_ID | CHAR30 | CHAR | 30 | 0 | ID/Object key | ||
74 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
75 | APLZL | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
76 | KAPID | KAPID | KAPID | NUMC | 8 | 0 | Capacity ID | * | |
77 | CANUM | CY_COUNT | CY_COUNT | NUMC | 4 | 0 | Counters for cap. rqmts. records (various caps. + indiv.caps | * | |
78 | AUTYP | AUFTYP | AUFTYP | NUMC | 2 | 0 | Order category | ||
79 | ARBID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
80 | KALID | FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | * | |
81 | LIGHT | LVC_EXLED | CHAR1 | CHAR | 1 | 0 | ALV control: Exception as LED |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | AFRUI | AUFNR | AUFK | AUFNR | REF | C | CN |
2 | AFRUI | BEMOT | TBMOT | BEMOT | |||
3 | AFRUI | GRUND | TRUG | GRUND | REF | C | CN |
4 | AFRUI | IDAUE | T006 | MSEHI | REF | 1 | CN |
5 | AFRUI | IPRE1 | T006 | MSEHI | |||
6 | AFRUI | ISMNE | T006 | MSEHI | REF | 1 | CN |
7 | AFRUI | KAPAR | TC26 | KAPAR | REF | C | CN |
8 | AFRUI | KDAUF | VBUK | VBELN | REF | C | CN |
9 | AFRUI | KDPOS | VBUP | POSNR | REF | C | CN |
10 | AFRUI | LEARR | CSLA | LSTAR | REF | C | CN |
11 | AFRUI | ODAUE | T006 | MSEHI | REF | 1 | CN |
12 | AFRUI | OFMNE | T006 | MSEHI | REF | 1 | CN |
13 | AFRUI | OPRE1 | T006 | MSEHI | |||
14 | AFRUI | PRCTR | CEPC | PRCTR | REF | C | CN |
15 | AFRUI | PRNAM | IMTP | PRNAM | CN | ||
16 | AFRUI | TXTSP | T002 | SPRAS | REF | C | CN |
17 | AFRUI | WERKS | T001W | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 50A |