biuan SAP® BUSINESS ONE SDK
API MDP3
MDP3 - Manual Depreciation - Item Areas Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OACQ
Capitalization
PRIMARYYes
ItemLineItem Row NumberInt
11
ItemCodeItem CodenVarChar
20OITM
Items
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
TotalTotalNum
20
TotalFrgnTotal (FC)Num
20
TotalSysTotal (SC)Num
20
ObjTypeObject TypenVarChar
20
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT MDP3.DocEntry AS 'Document Internal ID', MDP3.ItemLine AS 'Item Row Number', MDP3.ItemCode AS 'Item Code', MDP3.DprArea AS 'Depreciation Area', MDP3.Total AS 'Total', MDP3.TotalFrgn AS 'Total (FC)', MDP3.TotalSys AS 'Total (SC)', MDP3.ObjType AS 'Object Type', MDP3.LogInstanc AS 'Log Instance' FROM MDP3 AS MDP3

Related information


Capitalization OACQ SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Items OITM SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates