SAP ABAP Table MEREP_OUTTAB_EBANACC (Output Table: Purchase Requisition with Account Assignment)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
Basic Data
Table Category | INTTAB | Structure |
Structure | MEREP_OUTTAB_EBANACC | Table Relationship Diagram |
Short Description | Output Table: Purchase Requisition with Account Assignment |
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 | BANFN | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
2 | BNFPO | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
3 | LOEKZ_M | ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
4 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
5 | TXZ01 | TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
6 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
7 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
8 | PACKNO | PACKNO | PACKNO | NUMC | 10 | 0 | Package number | * | |
9 | MENGE_M | BAMNG | MENG13 | QUAN | 13 | 3 | Purchase requisition quantity | ||
10 | MEINS | BAMEI | MEINS | UNIT | 3 | 0 | Purchase requisition unit of measure | T006 | |
11 | EINDT | LPEIN | PRGBZ | CHAR | 1 | 0 | Category of delivery date | * | |
12 | EEIND | EEIND | CHAR10 | CHAR | 10 | 0 | Delivery Date | ||
13 | LFDAT | LFDAT | DATUM | DATS | 8 | 0 | Delivery date | ||
14 | AFNAM | AFNAM | AFNAM | CHAR | 12 | 0 | Name of requisitioner/requester | ||
15 | WERKS | EWERK | WERKS | CHAR | 4 | 0 | Plant | * | |
16 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
17 | STATU | BANST | BANST | CHAR | 1 | 0 | Processing status of purchase requisition | ||
18 | ESTKZ | ESTKZ | ESTKZ | CHAR | 1 | 0 | Creation indicator (purchase requisition/schedule lines) | ||
19 | FRGKZ | FRGKZ | FRGKZ | CHAR | 1 | 0 | Release Indicator | T161S | |
20 | BSART | BBSRT | BSART | CHAR | 4 | 0 | Purchase Requisition Document Type | T161 | |
21 | EPSTP | EPSTP | EPSTP | CHAR | 1 | 0 | Item category in purchasing document | ||
22 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
23 | FRGDT | FRGDT | DATUM | DATS | 8 | 0 | Purchase Requisition Release Date | ||
24 | BEDNR | BEDNR | CHAR10 | CHAR | 10 | 0 | Requirement Tracking Number | ||
25 | RESWK | RESWK | WERKS | CHAR | 4 | 0 | Supplying (issuing) plant in case of stock transport order | * | |
26 | DISPO | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | T024D | |
27 | FLIEF | FLIEF | LIFNR | CHAR | 10 | 0 | Fixed vendor | LFA1 | |
28 | FNAME1 | MEREP_VENDOR_NAME | NAME | CHAR | 35 | 0 | Name of Vendor | ||
29 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
30 | VRTYP | BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
31 | KONNR | KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | EKKO | |
32 | KTPNR | KTPNR | EBELP | NUMC | 5 | 0 | Item number of principal purchase agreement | EKPO | |
33 | INFNR | INFNR | INFNR | CHAR | 10 | 0 | Number of purchasing info record | EINA | |
34 | QUNUM | QUNUM | QUNUM | CHAR | 10 | 0 | Number of quota arrangement | ||
35 | QUPOS | QUPOS | NUM03 | NUMC | 3 | 0 | Quota arrangement item | ||
36 | LIFNR | WLIEF | LIFNR | CHAR | 10 | 0 | Desired vendor | LFA1 | |
37 | LNAME1 | MEREP_DES_VENDOR_NAME | NAME | CHAR | 35 | 0 | Name of Desired Vendor | ||
38 | BUMNG | BUMNG | MENG13 | QUAN | 13 | 3 | Shortage (stock undercoverage) quantity | ||
39 | EBELN | BSTNR | EBELN | CHAR | 10 | 0 | Purchase order number | * | |
40 | EBELP | BSTPO | EBELP | NUMC | 5 | 0 | Purchase order item number | * | |
41 | BEDAT | BEDAT | DATUM | DATS | 8 | 0 | Purchase Order Date | ||
42 | BSMNG | BSMNG | MENG13 | QUAN | 13 | 3 | Quantity ordered against this purchase requisition | ||
43 | EMATN | EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
44 | BANPR | BANPR | BANPR | CHAR | 2 | 0 | Requisition Processing State | ||
45 | BESWK | BESWK | WERKS | CHAR | 4 | 0 | Procuring Plant | * | |
46 | SOURCE_EXT | MMPUR_CONCAT_SOSUPPLY_EXT | CHAR | 80 | 0 | Supply source in external format | |||
47 | N_REQS | ME59REQS | INT4 | 10 | 0 | Number of Purchase Requisitions | |||
48 | BADAT | BADAT | DATUM | DATS | 8 | 0 | Requisition (request) date | ||
49 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
50 | MEMORYTYPE | MEMORYTYPE | MM_MEMORYTYPE | CHAR | 1 | 0 | Category of Incompleteness | ||
51 | .INCLUDE | 0 | 0 | Acct Assgt Structure for Ext. Purch. Docs (and Requisitions) | |||||
52 | ZEXKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
53 | LOEKZ | KLOEK | XFELD | CHAR | 1 | 0 | Deletion Indicator: Purchasing Document Account Assignment | ||
54 | AEDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
55 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
56 | VPROZ | VPROZ | VPROZ | DEC | 3 | 1 | Distribution percentage in the case of multiple acct assgt | ||
57 | NETWR | BWERT | WERT7 | CURR | 13 | 2 | Net Order Value in PO Currency | ||
58 | SAKTO | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
59 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
60 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
61 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
62 | VBELP | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
63 | VETEN | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
64 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
65 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
66 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
67 | WEMPF | WEMPF | WEMPF | CHAR | 12 | 0 | Goods recipient | ||
68 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
69 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
70 | KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
71 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
72 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
73 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
74 | NPLNR | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
75 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
76 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
77 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
78 | VPTNR | JV_PART | KUNNR | CHAR | 10 | 0 | Partner account number | * | |
79 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
80 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
81 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
82 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
83 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
84 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
85 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
86 | AUFPL_ORD | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
87 | APLZL_ORD | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
88 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
89 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
90 | NAVNW | NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
91 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
92 | PRZNR | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
93 | .INCLUDE | 0 | 0 | Include for the Reduction of Funds Reservations (FM) | |||||
94 | KBLNR | KBLNR | KBLNR | CHAR | 10 | 0 | Document Number for Earmarked Funds | * | |
95 | KBLPOS | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
96 | .INCLUDE | 0 | 0 | ||||||
97 | .INCLUDE | 0 | 0 | Include RE Accounting Fields (External,without IMKEY, DABRZ) | |||||
98 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | * | |
99 | SGENR | SGENR | SGENR | CHAR | 8 | 0 | Building Number | * | |
100 | SGRNR | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | * | |
101 | SMENR | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
102 | SMIVE | SMIVE | VVSMIVE | CHAR | 13 | 0 | Lease-Out Number | ||
103 | SNKSL | SNKSL | SNKSL | CHAR | 4 | 0 | Service Charge Key | * | |
104 | SEMPSL | SEMPSL | SEMPSL | CHAR | 5 | 0 | Settlement Unit | * | |
105 | SVWNR | VVSVWNR | VVSVWNR | CHAR | 13 | 0 | Management Contract Number | * | |
106 | RECNNR | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
107 | SBERI | SBERI | SBERI | CHAR | 10 | 0 | Correction item number | * | |
108 | TCNO | VVREITTCNO | VVREITTCNO | CHAR | 16 | 0 | RE-FX: Number of Correction Object | ||
109 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
110 | PSP_PNR | PSP_PNR | CHAR24 | CHAR | 24 | 0 | Work breakdown structure element (WBS element) | ||
111 | SRV_UPDKZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) | ||
112 | .INCLUDE | 0 | 0 | PSM Fields used in multiple account splitting | |||||
113 | FM_SPLIT_BATCH | FMSP_SPLIT_BATCH | NUMC3 | NUMC | 3 | 0 | Batch to group results from an PSM assignment distribution | ||
114 | FM_SPLIT_BEGRU | FMSP_SPLIT_AUTG | FMSP_SPLIT_AUTG | CHAR | 4 | 0 | Authorization group for PSM account assignment distribution | * | |
115 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
116 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
117 | .INCLUDE | 0 | 0 | MAA - Final Account Assignment Indicator | |||||
118 | AA_FINAL_IND | AA_FINAL_IND | XFELD | CHAR | 1 | 0 | Final Account Assignment Indicator | ||
119 | AA_FINAL_REASON | AA_FINAL_REASON | CHAR02 | CHAR | 2 | 0 | Final Account Assignment Reason Code | T163RC | |
120 | AA_FINAL_QTY | AA_FINAL_QTY | MENG13 | QUAN | 13 | 3 | Final Account Assignment Quantity | ||
121 | AA_FINAL_QTY_F | AA_FINAL_QTY_F | FLTP | 16 | 16 | Final Account Assignment Quantity (Floating Point Number) | |||
122 | MENGE_F | MENGE_F | FLTP | 16 | 16 | Quantity (Floating Point Number - Internal Field) | |||
123 | .INCLU--AP | 0 | 0 | Joint venture data | |||||
124 | EGRUP | JV_EGROUP | JV_EGROUP | CHAR | 3 | 0 | Equity group | * | |
125 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
126 | .INCLU--AP | 0 | 0 | Vorsteuerkorrektur | |||||
127 | .INCLUDE | 0 | 0 | VstBerichtigung: Zusatzfelder | |||||
128 | TCOBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
129 | DATEOFSERVICE | VVBEACTDATE | DATUM | DATS | 8 | 0 | Date of Service | ||
130 | NOTAXCORR | VVREITNOTAXCORR | BOOLE | CHAR | 1 | 0 | Do Not Consider Item in Input Tax Correction | ||
131 | DIFFOPTRATE | POPTSATZ | POPTSATZ | DEC | 9 | 6 | Real Estate Option Rate | ||
132 | HASDIFFOPTRATE | VVREITUSEDIFFOPTRATE | BOOLE | CHAR | 1 | 0 | Use Different Option Rate | ||
133 | .INCLU--AP | 0 | 0 | IBU PS: Append for MEREP_OUTTAB_EBANACC | |||||
134 | LONGNUM | /SAPPSPRO/LONGNUM | /SAPPSPRO/LONGNUM | CHAR | 40 | 0 | Smart Number | ||
135 | SRM_PURGRP | /SAPPSPRO/EXT_EKGRP | EKGRP | CHAR | 3 | 0 | External Purchasing Group | * | |
136 | EPROFILE | MEPROFILE | EPROFILE | CHAR | 2 | 0 | External Procurement Profile | ||
137 | GUID | /SAPPSPRO/GUID | SYSUUID | RAW | 16 | 0 | SDP DLA: Globally Unique identifier | ||
138 | OBJECT_ID | /SAPPSPRO/OBJECT_ID | /SAPPSPRO/OBJECT_ID | CHAR | 10 | 0 | SRM Document Number | ||
139 | NUMBER_INT | /SAPPSPRO/NUMBER_INT | NUMC | 10 | 0 | Item Number for Shopping Cart | |||
140 | STEXT | /SAPPSPRO/STEXT | TEXT40 | CHAR | 40 | 0 | Purchasing Group Description for SRM | ||
141 | PROC_ORG_RESP | /SAPPSPRO/RESP_PGR | CHAR | 14 | 0 | Responsible Organizational Unit (purchasing) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MEREP_OUTTAB_EBANACC | AA_FINAL_REASON | T163RC | AA_FINAL_REASON | REF | 1 | N |
2 | MEREP_OUTTAB_EBANACC | BSART | T161 | BSART | |||
3 | MEREP_OUTTAB_EBANACC | DISPO | T024D | DISPO | REF | 1 | N |
4 | MEREP_OUTTAB_EBANACC | EKGRP | T024 | EKGRP | |||
5 | MEREP_OUTTAB_EBANACC | EKORG | T024E | EKORG | REF | 1 | N |
6 | MEREP_OUTTAB_EBANACC | FLIEF | LFA1 | LIFNR | REF | 1 | N |
7 | MEREP_OUTTAB_EBANACC | FRGKZ | T161S | FRGKZ | REF | 1 | CN |
8 | MEREP_OUTTAB_EBANACC | INFNR | EINA | INFNR | REF | 1 | N |
9 | MEREP_OUTTAB_EBANACC | KNTTP | T163K | KNTTP | REF | 1 | N |
10 | MEREP_OUTTAB_EBANACC | KONNR | EKKO | EBELN | REF | 1 | N |
11 | MEREP_OUTTAB_EBANACC | KTPNR | EKPO | EBELP | REF | 1 | N |
12 | MEREP_OUTTAB_EBANACC | LIFNR | LFA1 | LIFNR | REF | 1 | N |
13 | MEREP_OUTTAB_EBANACC | MEINS | T006 | MSEHI | REF | 1 | N |
14 | MEREP_OUTTAB_EBANACC | SAKTO | SKA1 | SAKNR |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |