|
|
API AOA1
AOA1 - Blanket Agreement - Rows Table
Blanket Agreement AOAT SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
UoM Master Data OUOM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AgrNo KEY UNIQUE | Agreement No. | Int | 11 | AOAT Blanket Agreement | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AgrLineNum | Agreement Row Number | Int | 11 | |||||
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| ItemName | Item Description | nVarChar | 100 | |||||
| ItemGroup | Item Group | Int | 6 | OITB Item Groups | ||||
| PlanQty | Planned Quantity | Num | 20 | |||||
| UnitPrice | Unit Price | Num | 20 | |||||
| Currency | Price Currency | nVarChar | 3 | |||||
| CumQty | Cumulative Quantity | Num | 20 | |||||
| CumAmntFC | Cumulative Amount in FC | Num | 20 | |||||
| CumAmntLC | Cumulative Amount in LC | Num | 20 | |||||
| FreeTxt | Free Text | nVarChar | 100 | |||||
| InvntryUom | Inventory UoM | nVarChar | 100 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| VisOrder | Visual Order | Int | 11 | |||||
| RetPortion | Goods Return Probability | Num | 20 | |||||
| WrrtyEnd | Date When Goods Expire | Date | 8 | |||||
| LineStatus | Row Status | VarChar | O) Open C) Closed | 1 | O | |||
| PlanAmtLC | Planned Amount (LC) | Num | 20 | |||||
| PlanAmtFC | Planned Amount (FC) | Num | 20 | |||||
| Discount | Line Discount | Num | 20 | |||||
| UomEntry | UoM Entry | Int | 11 | OUOM UoM Master Data | ||||
| UomCode | UoM Code | nVarChar | 20 | |||||
| NumPerMsr | UoM Value | Num | 20 | 0 |
Table relationship map
SELECT statement
SELECT
AOA1.AgrNo AS 'Agreement No.',
AOA1.AgrLineNum AS 'Agreement Row Number',
AOA1.ItemCode AS 'Item No.',
AOA1.ItemName AS 'Item Description',
AOA1.ItemGroup AS 'Item Group',
AOA1.PlanQty AS 'Planned Quantity',
AOA1.UnitPrice AS 'Unit Price',
AOA1.Currency AS 'Price Currency',
AOA1.CumQty AS 'Cumulative Quantity',
AOA1.CumAmntFC AS 'Cumulative Amount in FC',
AOA1.CumAmntLC AS 'Cumulative Amount in LC',
AOA1.FreeTxt AS 'Free Text',
AOA1.InvntryUom AS 'Inventory UoM',
AOA1.LogInstanc AS 'Log Instance',
AOA1.VisOrder AS 'Visual Order',
AOA1.RetPortion AS 'Goods Return Probability',
AOA1.WrrtyEnd AS 'Date When Goods Expire',
AOA1.LineStatus AS 'Row Status',
AOA1.PlanAmtLC AS 'Planned Amount (LC)',
AOA1.PlanAmtFC AS 'Planned Amount (FC)',
AOA1.Discount AS 'Line Discount',
AOA1.UomEntry AS 'UoM Entry',
AOA1.UomCode AS 'UoM Code',
AOA1.NumPerMsr AS 'UoM Value'
FROM AOA1 AS AOA1
Related information
Blanket Agreement AOAT SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
UoM Master Data OUOM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
