|
|
SQL Finance / Posting Period
API Company Service / Finance Period
OFPR - Posting Period Table
Finance Period FinancePeriod Object· Table: OFPR
Parent: Company Service CompanyService Service
OFPR SQL 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 KEY UNIQUE | Period Code | nVarChar | 20 | CODE | Yes | |||
| Name KEY UNIQUE | Period Name | nVarChar | 20 | NAME | Yes | |||
| 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 | Free | VarChar | Y) Yes N) No | 1 | Y | |||
| Free3 | Free | 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
OFPR.AbsEntry AS 'System Number',
OFPR.Code AS 'Period Code',
OFPR.Name AS 'Period Name',
OFPR.F_RefDate AS 'Posting Date From',
OFPR.T_RefDate AS 'Posting Date To',
OFPR.F_DueDate AS 'Due Date From',
OFPR.T_DueDate AS 'Due Date To',
OFPR.F_TaxDate AS 'Document Date From',
OFPR.T_TaxDate AS 'Document Date To',
OFPR.Free2 AS 'Free',
OFPR.Free3 AS 'Free',
OFPR.DataSource AS 'Data Source',
OFPR.UserSign AS 'User Signature',
OFPR.SubNum AS 'No. of Sub-Period',
OFPR.Free AS 'Free',
OFPR.Free1 AS 'Free1',
OFPR.Addition AS 'Additional Sub-Periods',
OFPR.AddNum AS 'No. of Additional',
OFPR.Category AS 'Category',
OFPR.Indicator AS 'Period Indicator',
OFPR.LogInstanc AS 'Log Instance',
OFPR.UpdateDate AS 'Date of Update',
OFPR.WasStatChd AS 'Status Was Checked',
OFPR.PeriodStat AS 'Period Status',
OFPR.UserSign2 AS 'Updating User'
FROM OFPR AS OFPR
Related information
Finance Period FinancePeriod Object· Table: OFPR
The FinancePeriod object is a data structure related to the CompanyService.
The object is used to identify and define a new Finance Period.
Source table: OFPR.
Parent: Company Service CompanyService ServiceOFPR SQL Table
Periods Category OACP SQL Table
Period Indicator OPID SQL Table
Users OUSR SQL Table
CompanyService
Object
FinancePeriod
Enumeration
Method
Property
Locked
DB
PeriodCode
DB
PeriodName
DB
PeriodStatus
DB
SubNum
DB
TaxDateFrom
DB
TaxDateTo
DB
ValueDateTo
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
