|
|
API Blanket Agreements Items Lines / Blanket Agreements Items Line
OAT1 - Blanket Agreement - Rows Table
Blanket Agreements Items Line BlanketAgreements_ItemsLine Object· Table: OAT1
Parent: Blanket Agreements Items Lines BlanketAgreements_ItemsLines Collection
Blanket Agreement OOAT 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 | OOAT 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
OAT1.AgrNo AS 'Agreement No.',
OAT1.AgrLineNum AS 'Agreement Row Number',
OAT1.ItemCode AS 'Item No.',
OAT1.ItemName AS 'Item Description',
OAT1.ItemGroup AS 'Item Group',
OAT1.PlanQty AS 'Planned Quantity',
OAT1.UnitPrice AS 'Unit Price',
OAT1.Currency AS 'Price Currency',
OAT1.CumQty AS 'Cumulative Quantity',
OAT1.CumAmntFC AS 'Cumulative Amount in FC',
OAT1.CumAmntLC AS 'Cumulative Amount in LC',
OAT1.FreeTxt AS 'Free Text',
OAT1.InvntryUom AS 'Inventory UoM',
OAT1.LogInstanc AS 'Log Instance',
OAT1.VisOrder AS 'Visual Order',
OAT1.RetPortion AS 'Goods Return Probability',
OAT1.WrrtyEnd AS 'Date When Goods Expire',
OAT1.LineStatus AS 'Row Status',
OAT1.PlanAmtLC AS 'Planned Amount (LC)',
OAT1.PlanAmtFC AS 'Planned Amount (FC)',
OAT1.Discount AS 'Line Discount',
OAT1.UomEntry AS 'UoM Entry',
OAT1.UomCode AS 'UoM Code',
OAT1.NumPerMsr AS 'UoM Value'
FROM OAT1 AS OAT1
Related information
Blanket Agreements Items Line BlanketAgreements_ItemsLine Object· Table: OAT1
BlanketAgreements_ItemsLine is a child object of the BlanketAgreement object and represents the items that can be purchased or sold within the scope of the blanket agreement.
Source table: OAT1.
Parent: Blanket Agreements Items Lines BlanketAgreements_ItemsLines CollectionBlanket Agreement OOAT SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
UoM Master Data OUOM SQL Table
BlanketAgreements_ItemsLines
Object
BlanketAgreements_ItemsLine
Collection
Method
Property
AgreementNo
DB
FreeText
DB
InventoryUOM
DB
ItemGroup
DB
ItemNo
DB
UnitPrice
DB
Collection
Enumeration
Method
Object
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
