biuan SAP® BUSINESS ONE SDK
API OACP
OACP - Periods Category Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
0PRIMARYYes
PeriodCat KEY UNIQUEPeriod CategorynVarChar
10
CATEGORYYes
FinancYearBeginning of Financial YearDate
8
YearFinancial YearInt
6
PeriodNamePeriod NamenVarChar
20
SubTypeSub-Period TypeVarChar
Y) Year
Q) Quarters
M) Months
D) Days
1
Y
PeriodNumNumber of PeriodsInt
11
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
LogInstancLog InstanceInt
11
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6OUSR
Users
LinkAct_1Domestic Accounts ReceivablenVarChar
15OACT
G/L Accounts
LinkAct_2Checks ReceivednVarChar
15OACT
G/L Accounts
LinkAct_3Cash on HandnVarChar
15OACT
G/L Accounts
LinkAct_4AccountnVarChar
15OACT
G/L Accounts
LinkAct_5Sales Tax AccountnVarChar
15OACT
G/L Accounts
LinkAct_6Customer's Deduction at SourcenVarChar
15OACT
G/L Accounts
ComissActCredit Card Deposit FeenVarChar
15OACT
G/L Accounts
LinkAct_8Purchase TaxnVarChar
15OACT
G/L Accounts
LinkAct_9Foreign Accounts ReceivablenVarChar
15OACT
G/L Accounts
LinkAct_10Domestic Accounts PayablenVarChar
15OACT
G/L Accounts
LinkAct_11Foreign Accounts PayablenVarChar
15OACT
G/L Accounts
LinkAct_12Bank TransfernVarChar
15OACT
G/L Accounts
LinkAct_13Tax PayablenVarChar
15OACT
G/L Accounts
LinkAct_14Tax DefinitionnVarChar
15OACT
G/L Accounts
LinkAct_15Equipment and AssetsnVarChar
15OACT
G/L Accounts
LinkAct_16Withholding TaxnVarChar
15OACT
G/L Accounts
LinkAct_17Advances on Corp. Income TaxnVarChar
15OACT
G/L Accounts
LinkAct_18Opening Balance AccountnVarChar
15OACT
G/L Accounts
DfltIncomRevenue AccountnVarChar
15OACT
G/L Accounts
ExmptIncomTax Exempt Revenue AccountnVarChar
15OACT
G/L Accounts
DfltExpnExpense AccountnVarChar
15OACT
G/L Accounts
ForgnIncmRevenue Account - ForeignnVarChar
15OACT
G/L Accounts
ECIncomeRevenue Account - EUnVarChar
15OACT
G/L Accounts
ForgnExpnExpense Account - ForeignnVarChar
15OACT
G/L Accounts
DfltRateDiEx. Rate Diff. in All Curr. BPnVarChar
15OACT
G/L Accounts
DecresGlAcG/L Decrease AccountnVarChar
15OACT
G/L Accounts
LinkAct_27Automatic Reconciliation Diff.nVarChar
15OACT
G/L Accounts
DftStockOBAcct. for Opening Whse BalancenVarChar
15OACT
G/L Accounts
LinkAct_19Cash DiscountnVarChar
15OACT
G/L Accounts
LinkAct_20Cash Discount ClearingnVarChar
15OACT
G/L Accounts
LinkAct_21Realized Exchange Diff. LossnVarChar
15OACT
G/L Accounts
LinkAct_22Cash DiscountnVarChar
15OACT
G/L Accounts
LinkAct_23Realized Exchange Diff. LossnVarChar
15OACT
G/L Accounts
LinkAct_24Rounding AccountnVarChar
15OACT
G/L Accounts
LinkAct_25Realized Exchange Diff. GainnVarChar
15OACT
G/L Accounts
LinkAct_26Realized Exchange Diff. GainnVarChar
15OACT
G/L Accounts
IncresGlAcG/L Increase AccountnVarChar
15OACT
G/L Accounts
RturnngActSales Returns AccountnVarChar
15OACT
G/L Accounts
COGM_ActCost of Goods Sold AccountnVarChar
15OACT
G/L Accounts
AlocCstActAllocation AccountnVarChar
15OACT
G/L Accounts
VariancActVariance AccountnVarChar
15OACT
G/L Accounts
PricDifActPrice Difference AccountnVarChar
15OACT
G/L Accounts
CDownPymntCustomer Down Payment AccountnVarChar
15OACT
G/L Accounts
VDownPymntVendor Down Payments AccountnVarChar
15OACT
G/L Accounts
CBoERcvbleBoE Accounts ReceivablenVarChar
15OACT
G/L Accounts
CBoEOnClctBill of Exchange on CollectionnVarChar
15OACT
G/L Accounts
CBoEPresntBill of Exchange PresentationnVarChar
15OACT
G/L Accounts
CBoEDiscntBill of Exchange DiscountednVarChar
15OACT
G/L Accounts
CUnpaidBoEUnpaid Bill of ExchangenVarChar
15OACT
G/L Accounts
VBoEPaybleBoE Accounts PayablenVarChar
15OACT
G/L Accounts
VAsstBoEPyBoE Accounts PayablenVarChar
15OACT
G/L Accounts
COpenDebtsCustomer Doubtful Debts AcctnVarChar
15OACT
G/L Accounts
VOpenDebtsVendor Doubtful Debts AccountnVarChar
15OACT
G/L Accounts
PurchseActPurchase AccountnVarChar
15OACT
G/L Accounts
PaReturnAcPurchase Return AccountnVarChar
15OACT
G/L Accounts
PaOffsetAcPurchase Offset AccountnVarChar
15OACT
G/L Accounts
LinkAct_28Period-End Closing AccountnVarChar
15OACT
G/L Accounts
ExDiffActExchange Rate Differences AccountnVarChar
15OACT
G/L Accounts
BalanceActGoods Clearing AccountnVarChar
15OACT
G/L Accounts
BnkChgActBank Charges AccountnVarChar
15OACT
G/L Accounts
LinkAct_29Other ReceivablenVarChar
15OACT
G/L Accounts
LinkAct_30Other PayablenVarChar
15OACT
G/L Accounts
IncmAcctDefault Inv Reval. RevenuenVarChar
15OACT
G/L Accounts
ExpnAcctDef. Inv. Reval. Revenue AcctnVarChar
15OACT
G/L Accounts
VatRevActVAT in Revenue AccountnVarChar
15OACT
G/L Accounts
ExpClrActExpense Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offset AccountnVarChar
15OACT
G/L Accounts
CostRevActCOGS Revaluation AcctnVarChar
15OACT
G/L Accounts
RepomoActREPOMO Revaluation AccountnVarChar
15OACT
G/L Accounts
WipVarAcctWIP Inventory Variance AccountnVarChar
15OACT
G/L Accounts
SaleVatOffDown Payment Tax Offset AcctnVarChar
15OACT
G/L Accounts
PurcVatOffDown Payment Tax Offset AcctnVarChar
15OACT
G/L Accounts
DpmSalActPayment AdvancesnVarChar
15OACT
G/L Accounts
DpmPurActPayment AdvancesnVarChar
15OACT
G/L Accounts
ExpVarActExpense and Inventory AccountnVarChar
15OACT
G/L Accounts
CostOffActCOGS Revaluation Offset AcctnVarChar
15OACT
G/L Accounts
ECExepnsesExpense Account - EUnVarChar
15OACT
G/L Accounts
StockActInventory AccountnVarChar
15OACT
G/L Accounts
DflInPrcssDefault for Stk Itm in ProcessnVarChar
15OACT
G/L Accounts
DfltInCstmDefault for Stk Itm in CustomsnVarChar
15OACT
G/L Accounts
DfltProfitInventory Offset - Incr. AcctnVarChar
15OACT
G/L Accounts
DfltLossInventory Offset - Decr. AcctnVarChar
15OACT
G/L Accounts
VAssetsVendor Assets AccountnVarChar
15OACT
G/L Accounts
StockRvActInventory Revaluation AccountnVarChar
15OACT
G/L Accounts
StkRvOfActInventory Reval. Offset AcctnVarChar
15OACT
G/L Accounts
WipAcctWIP Inventory AccountnVarChar
15OACT
G/L Accounts
DfltCardInvoice and Payment BPnVarChar
15OCRD
Business Partner
ShpdGdsActShipped Goods AccountnVarChar
15OACT
G/L Accounts
GlRvOffActG/L Revaluation Offset AccountnVarChar
15OACT
G/L Accounts
OverpayAPOverpayment A/P AccountnVarChar
15OACT
G/L Accounts
UndrpayAPUnderpayment A/P AccountnVarChar
15OACT
G/L Accounts
OverpayAROverpayment A/R AccountnVarChar
15OACT
G/L Accounts
UndrpayARUnderpayment A/R AccountnVarChar
15OACT
G/L Accounts
ARCMActSales Credit AccountnVarChar
15OACT
G/L Accounts
ARCMExpActTax Exempt Credit AccountnVarChar
15OACT
G/L Accounts
ARCMFrnActSales Credit Account - ForeignnVarChar
15OACT
G/L Accounts
ARCMEUActSales Credit Account - EUnVarChar
15OACT
G/L Accounts
APCMActPurchase Credit AccountnVarChar
15OACT
G/L Accounts
APCMFrnActPurchase Credit Acct - ForeignnVarChar
15OACT
G/L Accounts
APCMEUActPurchase Credit Account - EUnVarChar
15OACT
G/L Accounts
NegStckActNegative Inventory Adj. AcctnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AccountnVarChar
15OACT
G/L Accounts
GLGainXdifRealized Exchange Diff. GainnVarChar
15OACT
G/L Accounts
GLLossXdifRealized Exchange Diff. LossnVarChar
15OACT
G/L Accounts
AmountDiffAmount DifferencesnVarChar
15OACT
G/L Accounts
SlfInvIncmSelf Invoice Revenue AccountnVarChar
15OACT
G/L Accounts
SlfInvExpnSelf Invoice Expense AccountnVarChar
15OACT
G/L Accounts
OnHoldActCapital Goods On Hold AccountnVarChar
15OACT
G/L Accounts
PlaActPLAnVarChar
15OACT
G/L Accounts
ICClrActIncoming CENVAT Clearing AcctnVarChar
15OACT
G/L Accounts
OCClrActOutgoing CENVAT Clearing AcctnVarChar
15OACT
G/L Accounts
PurBalActPurchase Balance AccountnVarChar
15OACT
G/L Accounts
WhICenActIncoming CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WhOCenActOutgoing CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
SalDpmIntA/R DP InterimnVarChar
15OACT
G/L Accounts
PurDpmIntA/P DP InterimnVarChar
15OACT
G/L Accounts
ExrateOnDtEx Rate on Def Tax AccountnVarChar
15OACT
G/L Accounts
UserSign2Updating UserInt
6OUSR
Users
EURecvActEU Accounts ReceivablenVarChar
15OACT
G/L Accounts
EUPayActEU Accounts PayablenVarChar
15OACT
G/L Accounts
WipOffsetWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
StockOffstInventory Offset P&L AccountnVarChar
15OACT
G/L Accounts
DunIntrstDunning InterestnVarChar
15OACT
G/L Accounts
DunFeeDunning FeenVarChar
15OACT
G/L Accounts
SnapShotIdSnapshot IDInt
11
0
TDSInterstTDS Interest AcctnVarChar
15OACT
G/L Accounts
TDSChargesTDS Other Charges AcctnVarChar
15OACT
G/L Accounts
SrvTaxClrService Tax Clearing AccountnVarChar
15OACT
G/L Accounts
ARConDiffGRealized Conversion Diff. GainnVarChar
15OACT
G/L Accounts
ARConDiffLRealized Conversion Diff. LossnVarChar
15OACT
G/L Accounts
APConDiffGRealized Conversion Diff. GainnVarChar
15OACT
G/L Accounts
APConDiffLRealized Conversion Diff. LossnVarChar
15OACT
G/L Accounts
GLConDiffGRealized Conversion Diff. GainnVarChar
15OACT
G/L Accounts
GLConDiffLRealized Conversion Diff. LossnVarChar
15OACT
G/L Accounts
FreeChrgSAFree of Charge Sales AccountnVarChar
15
FreeChrgPUFree of Charge Purchase AccountnVarChar
15
TDSFeeTDS Fee AcctnVarChar
15OACT
G/L Accounts
ResRevenueRevenue AccountnVarChar
15OACT
G/L Accounts
ResExpenseExpense AccountnVarChar
15OACT
G/L Accounts
ResSalesCrSales Credit AccountnVarChar
15OACT
G/L Accounts
ResPurchCrPurchase Credit AccountnVarChar
15OACT
G/L Accounts
ResNotInvRes. Received Not Inv. AccountnVarChar
15OACT
G/L Accounts
ResStdExp1Std Cost Expense 1nVarChar
15OACT
G/L Accounts
ResStdExp2Std Cost Expense 2nVarChar
15OACT
G/L Accounts
ResStdExp3Std Cost Expense 3nVarChar
15OACT
G/L Accounts
ResStdExp4Std Cost Expense 4nVarChar
15OACT
G/L Accounts
ResStdExp5Std Cost Expense 5nVarChar
15OACT
G/L Accounts
ResStdExp6Std Cost Expense 6nVarChar
15OACT
G/L Accounts
ResStdExp7Std Cost Expense 7nVarChar
15OACT
G/L Accounts
ResStdExp8Std Cost Expense 8nVarChar
15OACT
G/L Accounts
ResStdExp9Std Cost Expense 9nVarChar
15OACT
G/L Accounts
ResStdEx10Std Cost Expense 10nVarChar
15OACT
G/L Accounts
ResWipActResource WIP AccountnVarChar
15OACT
G/L Accounts
ResScrapAcScrap AccountnVarChar
15OACT
G/L Accounts
WipOffPlAcWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
ResOffPlAcResource Offset P&L AccountnVarChar
15OACT
G/L Accounts
ERDInARActExchange Rate Interim Sales AccountnVarChar
15OACT
G/L Accounts
ERDInAPActExchange Rate Interim Purchase AccountnVarChar
15OACT
G/L Accounts
CSDInARActCash Discount Interim Sales AccountnVarChar
15OACT
G/L Accounts
CSDInAPActCash Discount Interim Purchase AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT OACP.AbsEntry AS 'Internal Number', OACP.PeriodCat AS 'Period Category', OACP.FinancYear AS 'Beginning of Financial Year', OACP.Year AS 'Financial Year', OACP.PeriodName AS 'Period Name', OACP.SubType AS 'Sub-Period Type', OACP.PeriodNum AS 'Number of Periods', OACP.F_RefDate AS 'Posting Date From', OACP.T_RefDate AS 'Posting Date To', OACP.F_DueDate AS 'Due Date From', OACP.T_DueDate AS 'Due Date To', OACP.F_TaxDate AS 'Document Date From', OACP.T_TaxDate AS 'Document Date To', OACP.LogInstanc AS 'Log Instance', OACP.UpdateDate AS 'Date of Update', OACP.UserSign AS 'User Signature', OACP.LinkAct_1 AS 'Domestic Accounts Receivable', OACP.LinkAct_2 AS 'Checks Received', OACP.LinkAct_3 AS 'Cash on Hand', OACP.LinkAct_4 AS 'Account', OACP.LinkAct_5 AS 'Sales Tax Account', OACP.LinkAct_6 AS 'Customer's Deduction at Source', OACP.ComissAct AS 'Credit Card Deposit Fee', OACP.LinkAct_8 AS 'Purchase Tax', OACP.LinkAct_9 AS 'Foreign Accounts Receivable', OACP.LinkAct_10 AS 'Domestic Accounts Payable', OACP.LinkAct_11 AS 'Foreign Accounts Payable', OACP.LinkAct_12 AS 'Bank Transfer', OACP.LinkAct_13 AS 'Tax Payable', OACP.LinkAct_14 AS 'Tax Definition', OACP.LinkAct_15 AS 'Equipment and Assets', OACP.LinkAct_16 AS 'Withholding Tax', OACP.LinkAct_17 AS 'Advances on Corp. Income Tax', OACP.LinkAct_18 AS 'Opening Balance Account', OACP.DfltIncom AS 'Revenue Account', OACP.ExmptIncom AS 'Tax Exempt Revenue Account', OACP.DfltExpn AS 'Expense Account', OACP.ForgnIncm AS 'Revenue Account - Foreign', OACP.ECIncome AS 'Revenue Account - EU', OACP.ForgnExpn AS 'Expense Account - Foreign', OACP.DfltRateDi AS 'Ex. Rate Diff. in All Curr. BP', OACP.DecresGlAc AS 'G/L Decrease Account', OACP.LinkAct_27 AS 'Automatic Reconciliation Diff.', OACP.DftStockOB AS 'Acct. for Opening Whse Balance', OACP.LinkAct_19 AS 'Cash Discount', OACP.LinkAct_20 AS 'Cash Discount Clearing', OACP.LinkAct_21 AS 'Realized Exchange Diff. Loss', OACP.LinkAct_22 AS 'Cash Discount', OACP.LinkAct_23 AS 'Realized Exchange Diff. Loss', OACP.LinkAct_24 AS 'Rounding Account', OACP.LinkAct_25 AS 'Realized Exchange Diff. Gain', OACP.LinkAct_26 AS 'Realized Exchange Diff. Gain', OACP.IncresGlAc AS 'G/L Increase Account', OACP.RturnngAct AS 'Sales Returns Account', OACP.COGM_Act AS 'Cost of Goods Sold Account', OACP.AlocCstAct AS 'Allocation Account', OACP.VariancAct AS 'Variance Account', OACP.PricDifAct AS 'Price Difference Account', OACP.CDownPymnt AS 'Customer Down Payment Account', OACP.VDownPymnt AS 'Vendor Down Payments Account', OACP.CBoERcvble AS 'BoE Accounts Receivable', OACP.CBoEOnClct AS 'Bill of Exchange on Collection', OACP.CBoEPresnt AS 'Bill of Exchange Presentation', OACP.CBoEDiscnt AS 'Bill of Exchange Discounted', OACP.CUnpaidBoE AS 'Unpaid Bill of Exchange', OACP.VBoEPayble AS 'BoE Accounts Payable', OACP.VAsstBoEPy AS 'BoE Accounts Payable', OACP.COpenDebts AS 'Customer Doubtful Debts Acct', OACP.VOpenDebts AS 'Vendor Doubtful Debts Account', OACP.PurchseAct AS 'Purchase Account', OACP.PaReturnAc AS 'Purchase Return Account', OACP.PaOffsetAc AS 'Purchase Offset Account', OACP.LinkAct_28 AS 'Period-End Closing Account', OACP.ExDiffAct AS 'Exchange Rate Differences Account', OACP.BalanceAct AS 'Goods Clearing Account', OACP.BnkChgAct AS 'Bank Charges Account', OACP.LinkAct_29 AS 'Other Receivable', OACP.LinkAct_30 AS 'Other Payable', OACP.IncmAcct AS 'Default Inv Reval. Revenue', OACP.ExpnAcct AS 'Def. Inv. Reval. Revenue Acct', OACP.VatRevAct AS 'VAT in Revenue Account', OACP.ExpClrAct AS 'Expense Clearing Account', OACP.ExpOfstAct AS 'Expense Offset Account', OACP.CostRevAct AS 'COGS Revaluation Acct', OACP.RepomoAct AS 'REPOMO Revaluation Account', OACP.WipVarAcct AS 'WIP Inventory Variance Account', OACP.SaleVatOff AS 'Down Payment Tax Offset Acct', OACP.PurcVatOff AS 'Down Payment Tax Offset Acct', OACP.DpmSalAct AS 'Payment Advances', OACP.DpmPurAct AS 'Payment Advances', OACP.ExpVarAct AS 'Expense and Inventory Account', OACP.CostOffAct AS 'COGS Revaluation Offset Acct', OACP.ECExepnses AS 'Expense Account - EU', OACP.StockAct AS 'Inventory Account', OACP.DflInPrcss AS 'Default for Stk Itm in Process', OACP.DfltInCstm AS 'Default for Stk Itm in Customs', OACP.DfltProfit AS 'Inventory Offset - Incr. Acct', OACP.DfltLoss AS 'Inventory Offset - Decr. Acct', OACP.VAssets AS 'Vendor Assets Account', OACP.StockRvAct AS 'Inventory Revaluation Account', OACP.StkRvOfAct AS 'Inventory Reval. Offset Acct', OACP.WipAcct AS 'WIP Inventory Account', OACP.DfltCard AS 'Invoice and Payment BP', OACP.ShpdGdsAct AS 'Shipped Goods Account', OACP.GlRvOffAct AS 'G/L Revaluation Offset Account', OACP.OverpayAP AS 'Overpayment A/P Account', OACP.UndrpayAP AS 'Underpayment A/P Account', OACP.OverpayAR AS 'Overpayment A/R Account', OACP.UndrpayAR AS 'Underpayment A/R Account', OACP.ARCMAct AS 'Sales Credit Account', OACP.ARCMExpAct AS 'Tax Exempt Credit Account', OACP.ARCMFrnAct AS 'Sales Credit Account - Foreign', OACP.ARCMEUAct AS 'Sales Credit Account - EU', OACP.APCMAct AS 'Purchase Credit Account', OACP.APCMFrnAct AS 'Purchase Credit Acct - Foreign', OACP.APCMEUAct AS 'Purchase Credit Account - EU', OACP.NegStckAct AS 'Negative Inventory Adj. Acct', OACP.StkInTnAct AS 'Stock In Transit Account', OACP.GLGainXdif AS 'Realized Exchange Diff. Gain', OACP.GLLossXdif AS 'Realized Exchange Diff. Loss', OACP.AmountDiff AS 'Amount Differences', OACP.SlfInvIncm AS 'Self Invoice Revenue Account', OACP.SlfInvExpn AS 'Self Invoice Expense Account', OACP.OnHoldAct AS 'Capital Goods On Hold Account', OACP.PlaAct AS 'PLA', OACP.ICClrAct AS 'Incoming CENVAT Clearing Acct', OACP.OCClrAct AS 'Outgoing CENVAT Clearing Acct', OACP.PurBalAct AS 'Purchase Balance Account', OACP.WhICenAct AS 'Incoming CENVAT Account (WH)', OACP.WhOCenAct AS 'Outgoing CENVAT Account (WH)', OACP.SalDpmInt AS 'A/R DP Interim', OACP.PurDpmInt AS 'A/P DP Interim', OACP.ExrateOnDt AS 'Ex Rate on Def Tax Account', OACP.UserSign2 AS 'Updating User', OACP.EURecvAct AS 'EU Accounts Receivable', OACP.EUPayAct AS 'EU Accounts Payable', OACP.WipOffset AS 'WIP Offset P&L Account', OACP.StockOffst AS 'Inventory Offset P&L Account', OACP.DunIntrst AS 'Dunning Interest', OACP.DunFee AS 'Dunning Fee', OACP.SnapShotId AS 'Snapshot ID', OACP.TDSInterst AS 'TDS Interest Acct', OACP.TDSCharges AS 'TDS Other Charges Acct', OACP.SrvTaxClr AS 'Service Tax Clearing Account', OACP.ARConDiffG AS 'Realized Conversion Diff. Gain', OACP.ARConDiffL AS 'Realized Conversion Diff. Loss', OACP.APConDiffG AS 'Realized Conversion Diff. Gain', OACP.APConDiffL AS 'Realized Conversion Diff. Loss', OACP.GLConDiffG AS 'Realized Conversion Diff. Gain', OACP.GLConDiffL AS 'Realized Conversion Diff. Loss', OACP.FreeChrgSA AS 'Free of Charge Sales Account', OACP.FreeChrgPU AS 'Free of Charge Purchase Account', OACP.TDSFee AS 'TDS Fee Acct', OACP.ResRevenue AS 'Revenue Account', OACP.ResExpense AS 'Expense Account', OACP.ResSalesCr AS 'Sales Credit Account', OACP.ResPurchCr AS 'Purchase Credit Account', OACP.ResNotInv AS 'Res. Received Not Inv. Account', OACP.ResStdExp1 AS 'Std Cost Expense 1', OACP.ResStdExp2 AS 'Std Cost Expense 2', OACP.ResStdExp3 AS 'Std Cost Expense 3', OACP.ResStdExp4 AS 'Std Cost Expense 4', OACP.ResStdExp5 AS 'Std Cost Expense 5', OACP.ResStdExp6 AS 'Std Cost Expense 6', OACP.ResStdExp7 AS 'Std Cost Expense 7', OACP.ResStdExp8 AS 'Std Cost Expense 8', OACP.ResStdExp9 AS 'Std Cost Expense 9', OACP.ResStdEx10 AS 'Std Cost Expense 10', OACP.ResWipAct AS 'Resource WIP Account', OACP.ResScrapAc AS 'Scrap Account', OACP.WipOffPlAc AS 'WIP Offset P&L Account', OACP.ResOffPlAc AS 'Resource Offset P&L Account', OACP.ERDInARAct AS 'Exchange Rate Interim Sales Account', OACP.ERDInAPAct AS 'Exchange Rate Interim Purchase Account', OACP.CSDInARAct AS 'Cash Discount Interim Sales Account', OACP.CSDInAPAct AS 'Cash Discount Interim Purchase Account' FROM OACP AS OACP

Related information


OACP SQL Table

G/L Accounts OACT SQL Table

Business Partner OCRD 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates