biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Blanket Agreement - Details
API Blanket Agreements Details Lines / Blanket Agreements Details Line
OAT2 - Blanket Agreement - Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AgrNo KEY UNIQUEAgreement No.Int
11OOAT
Blanket Agreement		PRIMARYYes
AgrLnNumAgreement Item Row NumberInt
11
AgrEfctNumAgreement Effective Row No.Int
11
DatePeriodFrequencyVarChar
D) Daily
W) Weekly
M) Monthly
Q) Quarterly
S) Semi-Annually
A) Annually
O) One Time
1
M
FromDateFrom DateDate
8
ToDateTo DateDate
8
CallUpRelease InformationnVarChar
100
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses		-1
QuantityItem QuantityNum
20
ConsumeFCTConsumer Sales ForecastVarChar
Y) Yes
N) No
1
FreeTxtFree TextnVarChar
100
LogInstancLog InstanceInt
11
0
AmountLCPlanned Amount (LC)Num
20
AmountFCPlanned Amount (FC)Num
20

Table relationship map

SELECT statement

SELECT OAT2.AgrNo AS 'Agreement No.', OAT2.AgrLnNum AS 'Agreement Item Row Number', OAT2.AgrEfctNum AS 'Agreement Effective Row No.', OAT2.DatePeriod AS 'Frequency', OAT2.FromDate AS 'From Date', OAT2.ToDate AS 'To Date', OAT2.CallUp AS 'Release Information', OAT2.WhsCode AS 'Warehouse Code', OAT2.Quantity AS 'Item Quantity', OAT2.ConsumeFCT AS 'Consumer Sales Forecast', OAT2.FreeTxt AS 'Free Text', OAT2.LogInstanc AS 'Log Instance', OAT2.AmountLC AS 'Planned Amount (LC)', OAT2.AmountFC AS 'Planned Amount (FC)' FROM OAT2 AS OAT2

Related information


Blanket Agreements Details Line BlanketAgreements_DetailsLine Object· Table: OAT2
BlanketAgreements_DetailsLine is a child object of the BlanketAgreements_ItemsLine object and represents the details of a delivery plan for an item. Source table: OAT2.
   Parent: Blanket Agreements Details Lines BlanketAgreements_DetailsLines Collection
Blanket Agreement OOAT 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates