biuan SAP® BUSINESS ONE SDK
API AFPR
AFPR - Posting Period-Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUESystem NumberInt
11
PRIMARYYes
CodePeriod CodenVarChar
20
NamePeriod NamenVarChar
20
F_RefDatePosting Date FromDate
8
T_RefDatePosting Date ToDate
8
F_DueDateDue Date FromDate
8
T_DueDateDue Date ToDate
8
F_TaxDateDocument Date FromDate
8
T_TaxDateDocument Date ToDate
8
Free2Active for FeedVarChar
Y) Yes
N) No
1
Y
Free3LockedVarChar
N) Unlocked
S) Unlocked Except Sales
C) Closing Period
Y) Locked
1
N
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
SubNumNo. of Sub-PeriodInt
11
FreeFreeVarChar
1
Free1Free1VarChar
1
AdditionAdditional Sub-PeriodsVarChar
Y) Yes
N) No
1
N
AddNumNo. of AdditionalInt
11
CategoryCategorynVarChar
10OACP
Periods Category
IndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
WasStatChdStatus Was CheckedVarChar
N) No
Y) Yes
1
N
PeriodStatPeriod StatusVarChar
N) Unlocked
S) Unlocked Except Sales
C) Closing Period
Y) Locked
A) Archived
1
N
UserSign2Updating UserInt
6OUSR
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates