SAP ABAP Table MMPUR_SPPR_ACCOUNT_STY (SPPR Account Assignment Data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ MM-PUR (Application Component) Purchasing
⤷ MEREQ (Package) Purchasing: Purchase Requisition
⤷ MM-PUR (Application Component) Purchasing
⤷ MEREQ (Package) Purchasing: Purchase Requisition
Basic Data
Table Category | INTTAB | Structure |
Structure | MMPUR_SPPR_ACCOUNT_STY | Table Relationship Diagram |
Short Description | SPPR Account Assignment Data |
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 | key structrue for account assignment | |||||
2 | DOC_NUMBER | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
3 | DOC_ITEM | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
4 | DOC_ZEKKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
5 | .INCLUDE | 0 | 0 | Account Assignment Fields for Purchase Order | |||||
6 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
7 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
8 | .INCLUDE | 0 | 0 | Acct Assgt Structure for Ext. Purch. Docs (and Requisitions) | |||||
9 | ZEXKN | DZEKKN | NUM02 | NUMC | 2 | 0 | Sequential Number of Account Assignment | ||
10 | LOEKZ | KLOEK | XFELD | CHAR | 1 | 0 | Deletion Indicator: Purchasing Document Account Assignment | ||
11 | AEDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
12 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
13 | VPROZ | VPROZ | VPROZ | DEC | 3 | 1 | Distribution percentage in the case of multiple acct assgt | ||
14 | NETWR | BWERT | WERT7 | CURR | 13 | 2 | Net Order Value in PO Currency | ||
15 | SAKTO | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKA1 | |
16 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
17 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
18 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
19 | VBELP | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
20 | VETEN | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
21 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
22 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
23 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
24 | WEMPF | WEMPF | WEMPF | CHAR | 12 | 0 | Goods recipient | ||
25 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
26 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
27 | KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
28 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
29 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
30 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
31 | NPLNR | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
32 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
33 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
34 | APLZL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
35 | VPTNR | JV_PART | KUNNR | CHAR | 10 | 0 | Partner account number | * | |
36 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
37 | RECID | JV_RECIND | JV_RECIND | CHAR | 2 | 0 | Recovery Indicator | * | |
38 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
39 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
40 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
41 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
42 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
43 | AUFPL_ORD | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
44 | APLZL_ORD | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
45 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
46 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
47 | NAVNW | NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
48 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
49 | PRZNR | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | * | |
50 | .INCLUDE | 0 | 0 | Include for the Reduction of Funds Reservations (FM) | |||||
51 | KBLNR | KBLNR | KBLNR | CHAR | 10 | 0 | Document Number for Earmarked Funds | * | |
52 | KBLPOS | KBLPOS | KBLPOS | NUMC | 3 | 0 | Earmarked Funds: Document Item | * | |
53 | .INCLUDE | 0 | 0 | ||||||
54 | .INCLUDE | 0 | 0 | Include RE Accounting Fields (External,without IMKEY, DABRZ) | |||||
55 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | * | |
56 | SGENR | SGENR | SGENR | CHAR | 8 | 0 | Building Number | * | |
57 | SGRNR | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | * | |
58 | SMENR | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
59 | SMIVE | SMIVE | VVSMIVE | CHAR | 13 | 0 | Lease-Out Number | ||
60 | SNKSL | SNKSL | SNKSL | CHAR | 4 | 0 | Service Charge Key | * | |
61 | SEMPSL | SEMPSL | SEMPSL | CHAR | 5 | 0 | Settlement Unit | * | |
62 | SVWNR | VVSVWNR | VVSVWNR | CHAR | 13 | 0 | Management Contract Number | * | |
63 | RECNNR | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
64 | SBERI | SBERI | SBERI | CHAR | 10 | 0 | Correction item number | * | |
65 | TCNO | VVREITTCNO | VVREITTCNO | CHAR | 16 | 0 | RE-FX: Number of Correction Object | ||
66 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
67 | PSP_PNR | PSP_PNR | CHAR24 | CHAR | 24 | 0 | Work breakdown structure element (WBS element) | ||
68 | SRV_UPDKZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) | ||
69 | .INCLUDE | 0 | 0 | PSM Fields used in multiple account splitting | |||||
70 | FM_SPLIT_BATCH | FMSP_SPLIT_BATCH | NUMC3 | NUMC | 3 | 0 | Batch to group results from an PSM assignment distribution | ||
71 | FM_SPLIT_BEGRU | FMSP_SPLIT_AUTG | FMSP_SPLIT_AUTG | CHAR | 4 | 0 | Authorization group for PSM account assignment distribution | * | |
72 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
73 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * | |
74 | .INCLUDE | 0 | 0 | MAA - Final Account Assignment Indicator | |||||
75 | AA_FINAL_IND | AA_FINAL_IND | XFELD | CHAR | 1 | 0 | Final Account Assignment Indicator | ||
76 | AA_FINAL_REASON | AA_FINAL_REASON | CHAR02 | CHAR | 2 | 0 | Final Account Assignment Reason Code | T163RC | |
77 | AA_FINAL_QTY | AA_FINAL_QTY | MENG13 | QUAN | 13 | 3 | Final Account Assignment Quantity | ||
78 | AA_FINAL_QTY_F | AA_FINAL_QTY_F | FLTP | 16 | 16 | Final Account Assignment Quantity (Floating Point Number) | |||
79 | MENGE_F | MENGE_F | FLTP | 16 | 16 | Quantity (Floating Point Number - Internal Field) | |||
80 | .INCLU--AP | 0 | 0 | Joint venture data | |||||
81 | EGRUP | JV_EGROUP | JV_EGROUP | CHAR | 3 | 0 | Equity group | * | |
82 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
83 | .INCLU--AP | 0 | 0 | Vorsteuerkorrektur | |||||
84 | .INCLUDE | 0 | 0 | VstBerichtigung: Zusatzfelder | |||||
85 | TCOBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
86 | DATEOFSERVICE | VVBEACTDATE | DATUM | DATS | 8 | 0 | Date of Service | ||
87 | NOTAXCORR | VVREITNOTAXCORR | BOOLE | CHAR | 1 | 0 | Do Not Consider Item in Input Tax Correction | ||
88 | DIFFOPTRATE | POPTSATZ | POPTSATZ | DEC | 9 | 6 | Real Estate Option Rate | ||
89 | HASDIFFOPTRATE | VVREITUSEDIFFOPTRATE | BOOLE | CHAR | 1 | 0 | Use Different Option Rate | ||
90 | .INCLUDE | 0 | 0 | Field Catalog for IS2ERP of MEPOACCOUNTING | |||||
91 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
92 | ID | INT4 | INT4 | INT4 | 10 | 0 | Natural number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MMPUR_SPPR_ACCOUNT_STY | AA_FINAL_REASON | T163RC | AA_FINAL_REASON | REF | 1 | N |
2 | MMPUR_SPPR_ACCOUNT_STY | SAKTO | SKA1 | SAKNR |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 605 |