biuan SAP® BUSINESS ONE SDK
API ORCM
ORCM - Recommendation Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ObjAbsDocument Internal NumberInt
11
ObjTypeDocument NumberInt
11
ItemCodeItem No.nVarChar
20OITM
Items
DueDateOrder Due DateDate
8
OrderTypeOrder TypeVarChar
P) Purchase Order
W) Production Order
T) Inventory Transfer Request
Q) Purchase Quotation
R) Purchase Request
1
P
QuantityQuantityNum
20
UOMBuy or Inventory UoMnVarChar
100
CardCodePreferred VendornVarChar
15OCRD
Business Partner
WarehouseWarehousenVarChar
8OWHS
Warehouses
PricePrice After DiscountNum
20
CurrencyPrice CurrencynVarChar
3
OriginOrder OriginVarChar
M) MRP
1
M
StatusOrder StatusVarChar
O) Opened
A) Accepted
P) Processed
D) Deleted
1
O
UserSignUser SignatureInt
6OUSR
Users
DocDateGeneration DateDate
8
DocTimeGeneration TimeInt
6
BPLidBusiness Place IDInt
11
-1
PriceBefDiUnit PriceNum
20
DiscPrcntDiscount % Per RowNum
20
ReleasDateRelease DateDate
8
PriceAftVPrice after VATNum
20
FromWhseFrom WarehousenVarChar
8
FstReqDateFirst Request DateDate
8
UomEntryUoM EntryInt
11
NumPerMsrUoM ValueNum
20
AgrNoAgreement No.Int
11OOAT
Blanket Agreement
AgrLnNumAgreement Row NumberInt
11
UseDiscntUse BP Special PriceVarChar
Y) Yes
N) No
1
Y

Table relationship map

SELECT statement

SELECT ORCM.DocEntry AS 'Internal Number', ORCM.ObjAbs AS 'Document Internal Number', ORCM.ObjType AS 'Document Number', ORCM.ItemCode AS 'Item No.', ORCM.DueDate AS 'Order Due Date', ORCM.OrderType AS 'Order Type', ORCM.Quantity AS 'Quantity', ORCM.UOM AS 'Buy or Inventory UoM', ORCM.CardCode AS 'Preferred Vendor', ORCM.Warehouse AS 'Warehouse', ORCM.Price AS 'Price After Discount', ORCM.Currency AS 'Price Currency', ORCM.Origin AS 'Order Origin', ORCM.Status AS 'Order Status', ORCM.UserSign AS 'User Signature', ORCM.DocDate AS 'Generation Date', ORCM.DocTime AS 'Generation Time', ORCM.BPLid AS 'Business Place ID', ORCM.PriceBefDi AS 'Unit Price', ORCM.DiscPrcnt AS 'Discount % Per Row', ORCM.ReleasDate AS 'Release Date', ORCM.PriceAftV AS 'Price after VAT', ORCM.FromWhse AS 'From Warehouse', ORCM.FstReqDate AS 'First Request Date', ORCM.UomEntry AS 'UoM Entry', ORCM.NumPerMsr AS 'UoM Value', ORCM.AgrNo AS 'Agreement No.', ORCM.AgrLnNum AS 'Agreement Row Number', ORCM.UseDiscnt AS 'Use BP Special Price' FROM ORCM AS ORCM

Related information


Blanket Agreement OOAT SQL Table

Business Partner OCRD SQL Table

Items OITM SQL Table

Users OUSR SQL Table

Warehouses OWHS SQL Table



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