|
|
SQL Finance / Posting Period-Log
API AFPR
AFPR - Posting Period-Log Table
Periods Category OACP SQL Table
Period Indicator OPID SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | System Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code | Period Code | nVarChar | 20 | |||||
| Name | Period Name | nVarChar | 20 | |||||
| F_RefDate | Posting Date From | Date | 8 | |||||
| T_RefDate | Posting Date To | Date | 8 | |||||
| F_DueDate | Due Date From | Date | 8 | |||||
| T_DueDate | Due Date To | Date | 8 | |||||
| F_TaxDate | Document Date From | Date | 8 | |||||
| T_TaxDate | Document Date To | Date | 8 | |||||
| Free2 | Active for Feed | VarChar | Y) Yes N) No | 1 | Y | |||
| Free3 | Locked | VarChar | N) Unlocked S) Unlocked Except Sales C) Closing Period Y) Locked | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SubNum | No. of Sub-Period | Int | 11 | |||||
| Free | Free | VarChar | 1 | |||||
| Free1 | Free1 | VarChar | 1 | |||||
| Addition | Additional Sub-Periods | VarChar | Y) Yes N) No | 1 | N | |||
| AddNum | No. of Additional | Int | 11 | |||||
| Category | Category | nVarChar | 10 | OACP Periods Category | ||||
| Indicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| WasStatChd | Status Was Checked | VarChar | N) No Y) Yes | 1 | N | |||
| PeriodStat | Period Status | VarChar | N) Unlocked S) Unlocked Except Sales C) Closing Period Y) Locked A) Archived | 1 | N | |||
| UserSign2 | Updating User | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
AFPR.AbsEntry AS 'System Number',
AFPR.Code AS 'Period Code',
AFPR.Name AS 'Period Name',
AFPR.F_RefDate AS 'Posting Date From',
AFPR.T_RefDate AS 'Posting Date To',
AFPR.F_DueDate AS 'Due Date From',
AFPR.T_DueDate AS 'Due Date To',
AFPR.F_TaxDate AS 'Document Date From',
AFPR.T_TaxDate AS 'Document Date To',
AFPR.Free2 AS 'Active for Feed',
AFPR.Free3 AS 'Locked',
AFPR.DataSource AS 'Data Source',
AFPR.UserSign AS 'User Signature',
AFPR.SubNum AS 'No. of Sub-Period',
AFPR.Free AS 'Free',
AFPR.Free1 AS 'Free1',
AFPR.Addition AS 'Additional Sub-Periods',
AFPR.AddNum AS 'No. of Additional',
AFPR.Category AS 'Category',
AFPR.Indicator AS 'Period Indicator',
AFPR.LogInstanc AS 'Log Instance',
AFPR.UpdateDate AS 'Date of Update',
AFPR.WasStatChd AS 'Status Was Checked',
AFPR.PeriodStat AS 'Period Status',
AFPR.UserSign2 AS 'Updating User'
FROM AFPR AS AFPR
Related information
Periods Category OACP SQL Table
Period Indicator OPID SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
