biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Blanket Agreement - Details
API AOA2
AOA2 - Blanket Agreement - Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AgrNo KEY UNIQUEAgreement No.Int
11AOAT
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 AOA2.AgrNo AS 'Agreement No.', AOA2.AgrLnNum AS 'Agreement Item Row Number', AOA2.AgrEfctNum AS 'Agreement Effective Row No.', AOA2.DatePeriod AS 'Frequency', AOA2.FromDate AS 'From Date', AOA2.ToDate AS 'To Date', AOA2.CallUp AS 'Release Information', AOA2.WhsCode AS 'Warehouse Code', AOA2.Quantity AS 'Item Quantity', AOA2.ConsumeFCT AS 'Consumer Sales Forecast', AOA2.FreeTxt AS 'Free Text', AOA2.LogInstanc AS 'Log Instance', AOA2.AmountLC AS 'Planned Amount (LC)', AOA2.AmountFC AS 'Planned Amount (FC)' FROM AOA2 AS AOA2

Related information


Blanket Agreement AOAT 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