SAP table TEAMI_AMS (Advanced Metering System)

SAP table TEAMI_AMS has 3 primary key fields being MANDT,AMS,FROM_DATE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AMS Advanced Metering System CHAR 4 0 E_AMI_AMS
FROM_DATE From-Date DATS 8 0 E_AMI_DATEFROM
MDUS Meter Data Unification & Synchronization CHAR 10 0 TEAMI_MDUS E_AMI_MDUS
AMS_CAP_GRP Capability Group of Advanced Metering System NUMC 4 0 TEAMI_AMSCAPGRP E_AMI_AMS_CAP_GRP

TEAMI_AMS foreign key relationships

Table Field Check Table Check Field
0 TEAMI_AMS AMS_CAP_GRP TEAMI_AMSCAPGRP Capability Group of Advanced Metering System MANDT
1 TEAMI_AMS MDUS TEAMI_MDUS Meter Data Unification & Synchronization MANDT
1 TEAMI_AMS MDUS TEAMI_MDUS Meter Data Unification & Synchronization MDUS