1. Home
  2. Resources
  3. SAP Tables
  4. TM07I - Table with Fields for Physical Inventory Transaction Control

SAP Table TM07I

Table with Fields for Physical Inventory Transaction Control

TM07I (Table with Fields for Physical Inventory Transaction Control) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TM07I to other SAP tables.

TM07I table fields

Field Data element Checktable Datatype Length Decimals
TRTYP Transaction type TRTYP CHAR 1 0
* Masked
A Display
B Edit
C Display from archive
E Single-item planning
H Add
V Change
X Initial transaction
S Standard parameter: normal mode
U Convert indiv. planned order
L Delete
P Planning file entry
K Copy reference
D Print
VGART Transaction/Event Type VGART CHAR 2 0
VGART_MB Transaction/Event Type VGART CHAR 2 0
XHINZ Checkbox XFELD CHAR 1 0
X Yes
NULL No
XZAEL Checkbox XFELD CHAR 1 0
X Yes
NULL No
XDIFF Checkbox XFELD CHAR 1 0
X Yes
NULL No
XNACH Checkbox XFELD CHAR 1 0
X Yes
NULL No
XLOEK Checkbox XFELD CHAR 1 0
X Yes
NULL No
BWKEY Valuation Area BWKEY T001K CHAR 4 0
BWMOD Valuation Grouping Code BWMOD CHAR 4 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1 0
X Yes
NULL No
XRUEJ Indicator: post to previous year XRUEJ CHAR 1 0
X Yes
NULL No
BUKRS Company Code BUKRS T001 CHAR 4 0
WAERS Currency Key WAERS TCURC CUKY 5 0
PZAEL Number of counted items PZAEL NUMC 3 0
PDIFF Number of items for which adjustment postings have been made PDIFF NUMC 3 0
PLOEK Number of deleted items PLOEK NUMC 3 0
POFFE Number of open items POFFE NUMC 3 0
PNACH Number of recounted items PNACH NUMC 3 0
PGESA Total number of items PGESA NUMC 3 0
SOBLO Special stock indicator: Logistics assignment SOBLO CHAR 1 0
O Material provided to vendor
V Returnable packaging at customer
W Consignment stock at customer
SOBFI Special stock ind.: Accounting/bookkeeping assignment SOBFI CHAR 1 0
B Material provided by customer
C At customer's disposal
K Consignment goods from vendor
L Returnable packaging from vendor
M Returnable transport packaging from vendor
P Pipeline material from vendor
SOBVO Special stock indicator: Transaction assignment SOBVO CHAR 1 0
E Sales order stock
Q Project stock
D BOM explosion number stock
T Stock in Transit
DUV_ACTIVE Distribution of Consumption Differences from Inventory DUV_ACTIVE CHAR 1 0
X Yes
NULL No
DUV_DEFAULT Distribution of Consumption Differences: Default Indicator DUV_DEFAULT CHAR 1 0
NULL Distribution Is Not Active
1 Distribution Active
DUV_BINDING Distribution of Consumption Diffs: Binding Proposal DUV_BINDING CHAR 1 0
X Yes
NULL No

TM07I foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TM07I BUKRS SYST MANDT T001 Company Codes MANDT
TM07I BUKRS TM07I BUKRS T001 Company Codes BUKRS
TM07I BWKEY TM07I BWKEY T001K Valuation area BWKEY
TM07I BWKEY SYST MANDT T001K Valuation area MANDT
TM07I KTOPL SYST MANDT T004 Directory of Charts of Accounts MANDT
TM07I KTOPL TM07I KTOPL T004 Directory of Charts of Accounts KTOPL
TM07I PERIV SYST MANDT T009 Fiscal Year Variants MANDT
TM07I PERIV TM07I PERIV T009 Fiscal Year Variants PERIV
TM07I WAERS SYST MANDT TCURC Currency Codes MANDT
TM07I WAERS TM07I WAERS TCURC Currency Codes WAERS