|
|
DTW Acknowledge Number
API Financial Years Service / Delete Financial Year
OACK - Acknowledge Number Table
Delete Financial Year DeleteFinancialYear Method· Table: OACK
Parent: Financial Years Service FinancialYearsService Service· Table: OFYM
Financial Year Master OFYM SQL Table
Location OLCT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| FinYear KEY UNIQUE | Financial Year | Int | 11 | OFYM Financial Year Master | LOC_QUART | Yes | ||
| Quarter | Quarter | VarChar | 1) Quarter 1 2) Quarter 2 3) Quarter 3 4) Quarter 4 | 1 | ||||
| AckNum | Acknowledgment No. | nVarChar | 100 | |||||
| Location | Location | Int | 11 | OLCT Location |
Table relationship map
SELECT statement
SELECT
OACK.AbsId AS 'Internal Number',
OACK.FinYear AS 'Financial Year',
OACK.Quarter AS 'Quarter',
OACK.AckNum AS 'Acknowledgment No.',
OACK.Location AS 'Location'
FROM OACK AS OACK
Related information
Delete Financial Year DeleteFinancialYear Method· Table: OACK
Deletes an existing financial year.
The financial year is specified by its key (AbsId), which is contained in the FinancialYearParams object passed to the method.
Parent: Financial Years Service FinancialYearsService Service· Table: OFYM Financial Year Master OFYM SQL Table
Location OLCT SQL Table
FinancialYearsService
Method
DeleteFinancialYear
Collection
Enumeration
Method
Object
FinancialYear OFYM
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
