P_OperationalAcctgDocBrowser

DDL: P_OPERATIONALACCTGDOCBROWSER SQL: PFIOPACCTGDCBRWS Type: view COMPOSITE
1174 Fields 4 Data Sources 35 Associations

P_OperationalAcctgDocBrowser is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_AddlLedgerOplAcctgDocItem, I_OperationalAcctgDocItem, I_OperationalAcctgDocItem, I_ParkedOplAcctgDocItem) and exposes 1174 fields with key fields AccountingDocumentCatGroup, CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. It has 35 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_AddlLedgerOplAcctgDocItem I_AddlLedgerOplAcctgDocItem union_all
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from
I_OperationalAcctgDocItem I_OperationalAcctgDocItem union_all
I_ParkedOplAcctgDocItem I_ParkedOplAcctgDocItem union_all

Parameters (1)

NameTypeDefault
P_ClearingStatusSelection fis_clearingstatusselection

Associations (35)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
[0..1] I_SrvcDocByDocumentType _ServiceDocument $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
[0..1] I_CostCenter _CurrentCostCenter $projection.ControllingArea = _CurrentCostCenter.ControllingArea and $projection.CostCenter = _CurrentCostCenter.CostCenter and _CurrentCostCenter.ValidityStartDate <= $session.system_date and _CurrentCostCenter.ValidityEndDate >= $session.system_date
[0..1] I_ProfitCenter _CurrentProfitCenter $projection.ControllingArea = _CurrentProfitCenter.ControllingArea and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter and _CurrentProfitCenter.ValidityStartDate <= $session.system_date and _CurrentProfitCenter.ValidityEndDate >= $session.system_date
[0..1] I_AdditionalCurrencyRoles _AdditionalCurrencyRoles $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup and $projection.Ledger = _AdditionalCurrencyRoles.Ledger
[0..*] I_FundsCenter _FundsCenter $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.FundsCenter = _FundsCenter.FundsCenter
[0..1] I_Fund _Fund $projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund
[0..1] I_Fund _PartnerFund $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea and $projection.PartnerFund = _PartnerFund.Fund
[0..1] I_FundedProgram _FundedProgram $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea and $projection.FundedProgram = _FundedProgram.FundedProgram
[0..1] I_CompanyCode _CashLedgerCompanyCode $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
[0..1] I_GLAccountInCompanyCode _CashLedgerAccount $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
[0..1] I_CompanyCode _PubSecBudgetAccountCoCode $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
[0..1] I_PubSecBudgetAccount _PubSecBudgetAccount $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
[0..1] I_JournalEntry _JournalEntry $projection.CompanyCode = _JournalEntry.CompanyCode and $projection.FiscalYear = _JournalEntry.FiscalYear and $projection.AccountingDocument = _JournalEntry.AccountingDocument
[0..1] I_InternalOrder _InternalOrder $projection.OrderID = _InternalOrder.InternalOrder
[0..1] I_Purreqvaluationarea _ValuationArea $projection.ValuationArea = _ValuationArea.ValuationArea
[0..1] I_FinancialManagementArea _FinancialManagementArea $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea
[0..1] I_FiscalYearForCompanyCode _FiscalYear $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode
[0..1] I_TaxType _TaxType $projection.TaxType = _TaxType.TaxType
[0..1] I_Country _SupplyingCountry $projection.SupplyingCountry = _SupplyingCountry.Country
[0..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_PaymentDifferenceReason _PaymentDifferenceReason $projection.PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason and $projection.CompanyCode = _PaymentDifferenceReason.CompanyCode
[0..1] I_Order _Order $projection.OrderID = _Order.OrderID
[0..1] I_PurchasingDocument _PurchasingDocument $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_SupplierCompany _SupplierCompany $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_CustomerCompany _CustomerCompany $projection.Customer = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
[0..1] I_GLAccountInCompanyCode _GLAccountInCompanyCode $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
[0..1] I_AccountingDocumentType _AccountingDocumentType $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PFIOPACCTGDCBRWS view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (1174)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocumentCatGroup
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem
ChartOfAccounts ChartOfAccounts Node Class
ClearingDate ClearingDate Clearing Date
ClearingCreationDate ClearingCreationDate Clrg Creation Date
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
PostingKey PostingKey Posting Key
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
DebitCreditCode DebitCreditCode Single-Character Flag
BusinessArea BusinessArea Business Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
TaxType TaxType Tax Type
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ValueDate ValueDate Value Date
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
PartnerCompany PartnerCompany Trading Partner
FinancialTransactionType FinancialTransactionType Transact. Type
CorporateGroupAccount CorporateGroupAccount Group Account Number
PlanningLevel PlanningLevel Planning Level
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
BillingDocument BillingDocument SD Document
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ScheduleLine ScheduleLine Schedule Line
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
AssetValueDate AssetValueDate Reference date
PersonnelNumber PersonnelNumber Personnel No.
IsSalesRelated IsSalesRelated Is Sales Related
LineItemDisplayIsEnabled LineItemDisplayIsEnabled Line Items
IsOpenItemManaged IsOpenItemManaged Open Item Management
IsNotCashDiscountLiable IsNotCashDiscountLiable W/o CashDsc.
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction IsUsedInPaymentTransaction Is Used In Payment Transaction
OperationalGLAccount OperationalGLAccount Operational G/L Acct
GLAccount GLAccount General Ledger
Customer Customer Sold-to Party
Supplier Supplier Supplier
BranchAccount BranchAccount Branch Account No.
IsBalanceSheetAccount IsBalanceSheetAccount Is Balance Sheet Account
ProfitLossAccountType ProfitLossAccountType Profit Loss Account Type
SpecialGLAccountAssignment SpecialGLAccountAssignment Special G/L Assignmt
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PaymentMethod PaymentMethod Pymt Meth.
PaymentBlockingReason PaymentBlockingReason Pmnt block
FixedCashDiscount FixedCashDiscount Fixed Cash Discount
HouseBank HouseBank House Bank
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
TaxDistributionCode1 TaxDistributionCode1 Tax Distr. Code 1
TaxDistributionCode2 TaxDistributionCode2 Tax Distr. Code 2
TaxDistributionCode3 TaxDistributionCode3 Tax Distr. Code 3
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Item
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
StateCentralBankPaymentReason StateCentralBankPaymentReason SCB Ind.
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
InvoiceList InvoiceList Invoice List
BillOfExchangeUsage BillOfExchangeUsage BoE Usage
DunningKey DunningKey Dunning Key
DunningBlockingReason DunningBlockingReason Set Dunning Block
LastDunningDate LastDunningDate Last Dunned
DunningLevel DunningLevel Dunning Level
DunningArea DunningArea Dunning Area
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
Product Product Vehicle Model
Plant Plant Valuation Area
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
MaterialPriceControl MaterialPriceControl Price Control
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
VATRegistration VATRegistration VAT Registration No.
DelivOfGoodsDestCountry DelivOfGoodsDestCountry Dest. C/R
PaymentDifferenceReason PaymentDifferenceReason Reason Code
ProfitCenter ProfitCenter Profit Center
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVenturePartner JointVenturePartner Joint Venture Partner
TreasuryContractType TreasuryContractType Treasury Contract Type
AssetContract AssetContract Asset Contract
CashFlowType CashFlowType Flow Type
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
REInternalFinNumber REInternalFinNumber Real Estate Key
RealEstateObject RealEstateObject Real Estate Key
SettlementReferenceDate SettlementReferenceDate Reference date
CommitmentItem CommitmentItem Commitment item
CommitmentItemShortID CommitmentItemShortID Commitment item
CostObject CostObject Cost Object
ProjectNetwork ProjectNetwork Order
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
WBSElementInternalID WBS Internal ID
ProfitabilitySegment Profitability Segment
ProfitabilitySegment_2 ProfitabilitySegment_2 Profit. segment
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
CostOriginGroup CostOriginGroup Origin Group
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod Co Crcy Detn Meth
ClearingIsReversed ClearingIsReversed Clearing Is Reversed
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
AlternativeGLAccount AlternativeGLAccount Group Account
PartnerProfitCenter PartnerProfitCenter Profit Center
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
IsNegativePosting IsNegativePosting Negative Posting
PaymentCardItem PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement PaymentCardPaymentSettlement Payment Card Payment Settlement
CreditControlArea CreditControlArea Credit Control Area
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
DataExchangeInstruction1 DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 DataExchangeInstruction4 Instruction 4
Region Region Venue Region
HasPaymentOrder HasPaymentOrder Payment Sent
PaymentReference PaymentReference Payment Reference
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
ClearingItem ClearingItem Clearing Item
BusinessPlace BusinessPlace Business place
TaxSection TaxSection Tax Section
CostCtrActivityType CostCtrActivityType Activity Type
AccountsReceivableIsPledged AccountsReceivableIsPledged Accounts Receivable Is Pledged
AcctsReceivablePledgingCode AcctsReceivablePledgingCode AR Pledging Ind
BusinessProcess BusinessProcess Business Process
FunctionalArea FunctionalArea Sendr Fctl Area
CustomerIsInExecution CustomerIsInExecution Customer Is In Execution
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
Segment Segment Segment number
PartnerSegment PartnerSegment Partner Segment
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
HouseBankAccount HouseBankAccount House Bank Account
CostElement CostElement G/L Account
PaymentServiceProvider PaymentServiceProvider Payt Srvc Provider
PaymentRefByPaytSrvcProvider PaymentRefByPaytSrvcProvider Reference by PSP
SEPAMandate SEPAMandate SEPA Mandate
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
AccountingDocumentItemRef AccountingDocumentItemRef Position
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
NetDueDate NetDueDate Net Due Date
CashDiscount1DueDate CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate CashDiscount2DueDate Cash Discount 2
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts OffsettingChartOfAccounts Offsetting Chart of Accounts
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount CashLedgerAccount Cash Origin Account
FundsCenter FundsCenter Funds Center
FundedProgram FundedProgram Funded Program
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
PartnerFund PartnerFund Receiver Fund
PartnerGrant PartnerGrant Receiver Grant
PartnerBudgetPeriod PartnerBudgetPeriod Partner Budget Period
PubSecBudgetAccount PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
CashDiscountAmtInCoCodeCrcy Discount Amt
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
FunctionalCurrency FunctionalCurrency Functional Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
OriginalTaxBaseAmount OriginalTaxBaseAmount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
WithholdingTaxBaseAmount WithholdingTaxBaseAmount WTax Base Amt
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount CashDiscountAmount CD Amount
NetPaymentAmount NetPaymentAmount Net Payment Amount
WithholdingTaxAmount WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxExemptionAmt WithholdingTaxExemptionAmt WTax-Exempt
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
PaymentCurrency PaymentCurrency Payment Currency
AmountInPaymentCurrency AmountInPaymentCurrency Amount in Payment Currency
CreditControlAreaCurrency CreditControlAreaCurrency Credit Control Area Currency
HedgedAmount HedgedAmount
BaseUnit BaseUnit Unit of Measure
AbsoluteQuantity Value
GoodsMovementEntryUnit GoodsMovementEntryUnit Unit of Entry
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
PurchasingDocumentPriceUnit PurchasingDocumentPriceUnit Purchasing Document Price Unit
PurchaseOrderQty PurchaseOrderQty Purchase Order Quantity
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
NumberOfItems NumberOfItems
ClearingStatusSelection
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_PostingKey _PostingKey
_FinancialAccountType _FinancialAccountType
_DebitCreditCode _DebitCreditCode
_BusinessArea _BusinessArea
_PartnerBusinessArea _PartnerBusinessArea
_TaxType _TaxType
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_SupplyingCountry _SupplyingCountry
_Product _Product
_Plant _Plant
_BaseUnit _BaseUnit
_InventoryValuationType _InventoryValuationType
_PaymentDifferenceReason _PaymentDifferenceReason
_Segment _Segment
_PartnerSegment _PartnerSegment
_WBSElementBasicData _WBSElementBasicData
_AccountingDocumentType _AccountingDocumentType
_TransactionCurrency _TransactionCurrency
_InternalOrder _InternalOrder
_Order _Order
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetTransactionType _AssetTransactionType
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_ValuationArea _ValuationArea
_ProjectNetwork _ProjectNetwork
_CostCtrActivityType _CostCtrActivityType
_BusinessProcess _BusinessProcess
_FunctionalArea _FunctionalArea
_AdditionalCurrencyRoles _AdditionalCurrencyRoles
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Customer _Customer
_CustomerCompany _CustomerCompany
_GLAccountInCompanyCode _GLAccountInCompanyCode
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_FundsCenter _FundsCenter
_Fund _Fund
_PartnerFund _PartnerFund
_FundedProgram _FundedProgram
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_BudgetPeriod _BudgetPeriod
_PartnerBudgetPeriod _PartnerBudgetPeriod
_Grant _Grant
_PartnerGrant _PartnerGrant
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem
ChartOfAccounts ChartOfAccounts Node Class
ClearingDate ClearingDate Clearing Date
ClearingCreationDate ClearingCreationDate Clrg Creation Date
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
PostingKey PostingKey Posting Key
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
DebitCreditCode DebitCreditCode Single-Character Flag
BusinessArea BusinessArea Business Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
TaxType TaxType Tax Type
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ValueDate ValueDate Value Date
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
PartnerCompany PartnerCompany Trading Partner
FinancialTransactionType FinancialTransactionType Transact. Type
CorporateGroupAccount CorporateGroupAccount Group Account Number
PlanningLevel PlanningLevel Planning Level
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
BillingDocument BillingDocument SD Document
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ScheduleLine ScheduleLine Schedule Line
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
AssetValueDate AssetValueDate Reference date
PersonnelNumber PersonnelNumber Personnel No.
IsSalesRelated IsSalesRelated Is Sales Related
LineItemDisplayIsEnabled LineItemDisplayIsEnabled Line Items
IsOpenItemManaged IsOpenItemManaged Open Item Management
IsNotCashDiscountLiable IsNotCashDiscountLiable W/o CashDsc.
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction IsUsedInPaymentTransaction Is Used In Payment Transaction
OperationalGLAccount OperationalGLAccount Operational G/L Acct
GLAccount GLAccount General Ledger
Customer Customer Sold-to Party
Supplier Supplier Supplier
BranchAccount BranchAccount Branch Account No.
IsBalanceSheetAccount IsBalanceSheetAccount Is Balance Sheet Account
ProfitLossAccountType ProfitLossAccountType Profit Loss Account Type
SpecialGLAccountAssignment SpecialGLAccountAssignment Special G/L Assignmt
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PaymentMethod PaymentMethod Pymt Meth.
PaymentBlockingReason PaymentBlockingReason Pmnt block
FixedCashDiscount FixedCashDiscount Fixed Cash Discount
HouseBank HouseBank House Bank
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
TaxDistributionCode1 TaxDistributionCode1 Tax Distr. Code 1
TaxDistributionCode2 TaxDistributionCode2 Tax Distr. Code 2
TaxDistributionCode3 TaxDistributionCode3 Tax Distr. Code 3
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Item
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
StateCentralBankPaymentReason StateCentralBankPaymentReason SCB Ind.
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
InvoiceList InvoiceList Invoice List
BillOfExchangeUsage BillOfExchangeUsage BoE Usage
DunningKey DunningKey Dunning Key
DunningBlockingReason DunningBlockingReason Set Dunning Block
LastDunningDate LastDunningDate Last Dunned
DunningLevel DunningLevel Dunning Level
DunningArea DunningArea Dunning Area
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
Product Product Vehicle Model
Plant Plant Valuation Area
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
MaterialPriceControl MaterialPriceControl Price Control
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
VATRegistration VATRegistration VAT Registration No.
DelivOfGoodsDestCountry DelivOfGoodsDestCountry Dest. C/R
PaymentDifferenceReason PaymentDifferenceReason Reason Code
ProfitCenter ProfitCenter Profit Center
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVenturePartner JointVenturePartner Joint Venture Partner
TreasuryContractType TreasuryContractType Treasury Contract Type
AssetContract AssetContract Asset Contract
CashFlowType CashFlowType Flow Type
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
REInternalFinNumber REInternalFinNumber Real Estate Key
RealEstateObject RealEstateObject Real Estate Key
SettlementReferenceDate SettlementReferenceDate Reference date
CommitmentItem CommitmentItem Commitment item
CommitmentItemShortID CommitmentItemShortID Commitment item
CostObject CostObject Cost Object
ProjectNetwork ProjectNetwork Order
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
WBSElementInternalID WBS Internal ID
ProfitabilitySegment ProfitabilitySegment Profitability Segment
ProfitabilitySegment_2 ProfitabilitySegment_2 Profit. segment
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
CostOriginGroup CostOriginGroup Origin Group
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod Co Crcy Detn Meth
ClearingIsReversed ClearingIsReversed Clearing Is Reversed
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
AlternativeGLAccount AlternativeGLAccount Group Account
PartnerProfitCenter PartnerProfitCenter Profit Center
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
IsNegativePosting IsNegativePosting Negative Posting
PaymentCardItem PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement PaymentCardPaymentSettlement Payment Card Payment Settlement
CreditControlArea CreditControlArea Credit Control Area
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
DataExchangeInstruction1 DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 DataExchangeInstruction4 Instruction 4
Region Region Venue Region
HasPaymentOrder HasPaymentOrder Payment Sent
PaymentReference PaymentReference Payment Reference
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
ClearingItem ClearingItem Clearing Item
BusinessPlace BusinessPlace Business place
TaxSection TaxSection Tax Section
CostCtrActivityType CostCtrActivityType Activity Type
AccountsReceivableIsPledged AccountsReceivableIsPledged Accounts Receivable Is Pledged
AcctsReceivablePledgingCode AcctsReceivablePledgingCode AR Pledging Ind
BusinessProcess BusinessProcess Business Process
FunctionalArea FunctionalArea Sendr Fctl Area
CustomerIsInExecution CustomerIsInExecution Customer Is In Execution
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
Segment Segment Segment number
PartnerSegment PartnerSegment Partner Segment
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
HouseBankAccount HouseBankAccount House Bank Account
CostElement CostElement G/L Account
PaymentServiceProvider PaymentServiceProvider Payt Srvc Provider
PaymentRefByPaytSrvcProvider PaymentRefByPaytSrvcProvider Reference by PSP
SEPAMandate SEPAMandate SEPA Mandate
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
AccountingDocumentItemRef AccountingDocumentItemRef Position
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
NetDueDate NetDueDate Net Due Date
CashDiscount1DueDate CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate CashDiscount2DueDate Cash Discount 2
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts OffsettingChartOfAccounts Offsetting Chart of Accounts
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount CashLedgerAccount Cash Origin Account
FundsCenter FundsCenter Funds Center
FundedProgram FundedProgram Funded Program
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
PartnerFund PartnerFund Receiver Fund
PartnerGrant PartnerGrant Receiver Grant
PartnerBudgetPeriod PartnerBudgetPeriod Partner Budget Period
PubSecBudgetAccount PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
CashDiscountAmtInCoCodeCrcy Discount Amt
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
FunctionalCurrency FunctionalCurrency Functional Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
OriginalTaxBaseAmount OriginalTaxBaseAmount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
WithholdingTaxBaseAmount WithholdingTaxBaseAmount WTax Base Amt
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount CashDiscountAmount CD Amount
NetPaymentAmount NetPaymentAmount Net Payment Amount
WithholdingTaxAmount WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxExemptionAmt WithholdingTaxExemptionAmt WTax-Exempt
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
PaymentCurrency PaymentCurrency Payment Currency
AmountInPaymentCurrency AmountInPaymentCurrency Amount in Payment Currency
CreditControlAreaCurrency CreditControlAreaCurrency Credit Control Area Currency
HedgedAmount HedgedAmount
BaseUnit BaseUnit Unit of Measure
AbsoluteQuantity Value
GoodsMovementEntryUnit GoodsMovementEntryUnit Unit of Entry
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
PurchasingDocumentPriceUnit PurchasingDocumentPriceUnit Purchasing Document Price Unit
PurchaseOrderQty PurchaseOrderQty Purchase Order Quantity
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
NumberOfItems NumberOfItems
ClearingStatusSelection
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_PostingKey _PostingKey
_FinancialAccountType _FinancialAccountType
_DebitCreditCode _DebitCreditCode
_BusinessArea _BusinessArea
_PartnerBusinessArea _PartnerBusinessArea
_TaxType _TaxType
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_SupplyingCountry _SupplyingCountry
_Product _Product
_Plant _Plant
_BaseUnit _BaseUnit
_InventoryValuationType _InventoryValuationType
_PaymentDifferenceReason _PaymentDifferenceReason
_Segment _Segment
_PartnerSegment _PartnerSegment
_WBSElementBasicData _WBSElementBasicData
_AccountingDocumentType _AccountingDocumentType
_TransactionCurrency _TransactionCurrency
_InternalOrder _InternalOrder
_Order _Order
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetTransactionType _AssetTransactionType
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_ValuationArea _ValuationArea
_ProjectNetwork _ProjectNetwork
_CostCtrActivityType _CostCtrActivityType
_BusinessProcess _BusinessProcess
_FunctionalArea _FunctionalArea
_AdditionalCurrencyRoles _AdditionalCurrencyRoles
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Customer _Customer
_CustomerCompany _CustomerCompany
_GLAccountInCompanyCode _GLAccountInCompanyCode
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_FundsCenter _FundsCenter
_Fund _Fund
_PartnerFund _PartnerFund
_FundedProgram _FundedProgram
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_BudgetPeriod _BudgetPeriod
_PartnerBudgetPeriod _PartnerBudgetPeriod
_Grant _Grant
_PartnerGrant _PartnerGrant
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear SourceFiscalYear G/L Fiscal Year
KEY AccountingDocument SourceAccountingDocument Journal Entry
KEY AccountingDocumentItem SourceAccountingDocumentItem
ChartOfAccounts ChartOfAccounts Node Class
ClearingDate Clearing Date
ClearingCreationDate Clrg Creation Date
ClearingJournalEntry Clrng doc.
ClearingAccountingDocument Clearing Journal Entry
PostingKey PostingKey Posting Key
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
SpecialGLTransactionType SpecialGLTransactionType Transact.Type
DebitCreditCode DebitCreditCode Single-Character Flag
BusinessArea BusinessArea Business Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
TaxType TaxType Tax Type
TransactionTypeDetermination Transaction Key
ValueDate ValueDate Value Date
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
PartnerCompany PartnerCompany Trading Partner
FinancialTransactionType FinancialTransactionType Transact. Type
CorporateGroupAccount Group Account Number
PlanningLevel PlanningLevel Planning Level
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
BillingDocument SD Document
SalesDocument SD Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line
ServiceDocumentType Transaction Type
ServiceDocument Transaction ID
ServiceDocumentItem Service Document
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
AssetValueDate AssetValueDate Reference date
PersonnelNumber PersonnelNumber Personnel No.
IsSalesRelated IsSalesRelated Is Sales Related
LineItemDisplayIsEnabled Line Items
IsOpenItemManaged Open Item Management
IsNotCashDiscountLiable IsNotCashDiscountLiable W/o CashDsc.
IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction Is Used In Payment Transaction
OperationalGLAccount Operational G/L Acct
GLAccount GLAccount General Ledger
Customer Sold-to Party
Supplier Supplier
BranchAccount BranchAccount Branch Account No.
IsBalanceSheetAccount Is Balance Sheet Account
ProfitLossAccountType Profit Loss Account Type
SpecialGLAccountAssignment SpecialGLAccountAssignment Special G/L Assignmt
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent Disc. Percent 2
PaymentMethod PaymentMethod Pymt Meth.
PaymentBlockingReason Pmnt block
FixedCashDiscount FixedCashDiscount Fixed Cash Discount
HouseBank HouseBank House Bank
BPBankAccountInternalID BPBankAccountInternalID BP Bank Account
TaxDistributionCode1 Tax Distr. Code 1
TaxDistributionCode2 Tax Distr. Code 2
TaxDistributionCode3 Tax Distr. Code 3
InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Item
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
StateCentralBankPaymentReason StateCentralBankPaymentReason SCB Ind.
SupplyingCountry SupplyingCountry Supplying Ctry/Reg.
InvoiceList Invoice List
BillOfExchangeUsage BoE Usage
DunningKey DunningKey Dunning Key
DunningBlockingReason DunningBlockingReason Set Dunning Block
LastDunningDate LastDunningDate Last Dunned
DunningLevel DunningLevel Dunning Level
DunningArea DunningArea Dunning Area
WithholdingTaxCertificate WHT Certificate
Product Product Vehicle Model
Plant Plant Valuation Area
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
IsCompletelyDelivered Is completely delivered
MaterialPriceControl MaterialPriceControl Price Control
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
VATRegistration VATRegistration VAT Registration No.
DelivOfGoodsDestCountry Dest. C/R
PaymentDifferenceReason PaymentDifferenceReason Reason Code
ProfitCenter ProfitCenter Profit Center
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVenturePartner JointVenturePartner Joint Venture Partner
TreasuryContractType TreasuryContractType Treasury Contract Type
AssetContract AssetContract Asset Contract
CashFlowType CashFlowType Flow Type
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
REInternalFinNumber REInternalFinNumber Real Estate Key
RealEstateObject Real Estate Key
SettlementReferenceDate SettlementReferenceDate Reference date
CommitmentItem Commitment item
CommitmentItemShortID CommitmentItemShortID Commitment item
CostObject CostObject Cost Object
ProjectNetwork ProjectNetwork Order
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
WBSElementInternalID WBS Internal ID
ProfitabilitySegment Profitability Segment
ProfitabilitySegment_2 ProfitabilitySegment Profit. segment
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
CostOriginGroup CostOriginGroup Origin Group
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod Co Crcy Detn Meth
ClearingIsReversed Clearing Is Reversed
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
AlternativeGLAccount Group Account
PartnerProfitCenter Profit Center
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
IsNegativePosting Negative Posting
PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement PaymentCardPaymentSettlement Payment Card Payment Settlement
CreditControlArea CreditControlArea Credit Control Area
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
DataExchangeInstruction1 DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 DataExchangeInstruction4 Instruction 4
Region Region Venue Region
HasPaymentOrder Payment Sent
PaymentReference PaymentReference Payment Reference
TaxDeterminationDate Tx Determination Dte
ClearingItem Clearing Item
BusinessPlace BusinessPlace Business place
TaxSection Tax Section
CostCtrActivityType CostCtrActivityType Activity Type
AccountsReceivableIsPledged Accounts Receivable Is Pledged
AcctsReceivablePledgingCode AR Pledging Ind
BusinessProcess BusinessProcess Business Process
FunctionalArea FunctionalArea Sendr Fctl Area
CustomerIsInExecution Customer Is In Execution
ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
LedgerGLLineItem Journal Entry Item
Segment Segment Segment number
PartnerSegment PartnerSegment Partner Segment
PartnerFunctionalArea Rec. Fntcl Area
HouseBankAccount House Bank Account
CostElement G/L Account
PaymentServiceProvider Payt Srvc Provider
PaymentRefByPaytSrvcProvider Reference by PSP
SEPAMandate SEPA Mandate
ReferenceDocumentType Reference Document Type
OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
AccountingDocumentItemRef Position
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
PostingDate PostingDate Posting Date for GR
DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
NetDueDate NetDueDate Net Due Date
CashDiscount1DueDate CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate CashDiscount2DueDate Cash Discount 2
OffsettingAccount Offsetting Acct
OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts Offsetting Chart of Accounts
CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount Cash Origin Account
FinancialManagementArea FinancialManagementArea FM Area
FundsCenter FundsCenter Funds Center
FundedProgram FundedProgram Funded Program
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
PartnerFund PartnerFund Receiver Fund
PartnerGrant PartnerGrant Receiver Grant
PartnerBudgetPeriod PartnerBudgetPeriod Partner Budget Period
PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode Company Code for Budget Account
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
ValuationDiffAmtInCoCodeCrcy
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy Discount Amt
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
FunctionalCurrency Functional Currency
AmountInFunctionalCurrency Amount in Functional Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
OriginalTaxBaseAmount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
WithholdingTaxBaseAmount WithholdingTaxBaseAmount WTax Base Amt
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
CashDiscountBaseAmount CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount CD Amount
NetPaymentAmount Net Payment Amount
WithholdingTaxAmount WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxExemptionAmt WithholdingTaxExemptionAmt WTax-Exempt
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
ValuationDiffAmtInAddlCrcy2
PaymentCurrency PaymentCurrency Payment Currency
AmountInPaymentCurrency Amount in Payment Currency
CreditControlAreaCurrency Credit Control Area Currency
HedgedAmount
BaseUnit BaseUnit Unit of Measure
AbsoluteQuantity Value
GoodsMovementEntryUnit Unit of Entry
QuantityInEntryUnit Quantity in Unit of Entry
PurchasingDocumentPriceUnit Purchasing Document Price Unit
PurchaseOrderQty Purchase Order Quantity
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
Ledger Ledger
LedgerGroup LedgerGroup Ledger Group
NumberOfItems
ClearingStatusSelection
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_PostingKey _PostingKey
_FinancialAccountType _FinancialAccountType
_DebitCreditCode _DebitCreditCode
_BusinessArea _BusinessArea
_PartnerBusinessArea _PartnerBusinessArea
_TaxType _TaxType
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_SupplyingCountry _SupplyingCountry
_Product _Product
_Plant _Plant
_BaseUnit _BaseUnit
_InventoryValuationType _InventoryValuationType
_PaymentDifferenceReason _PaymentDifferenceReason
_Segment _Segment
_PartnerSegment _PartnerSegment
_WBSElementBasicData _WBSElementBasicData
_AccountingDocumentType _AccountingDocumentType
_TransactionCurrency _TransactionCurrency
_InternalOrder _InternalOrder
_Order _Order
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetTransactionType _AssetTransactionType
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_ValuationArea _ValuationArea
_ProjectNetwork _ProjectNetwork
_CostCtrActivityType _CostCtrActivityType
_BusinessProcess _BusinessProcess
_FunctionalArea _FunctionalArea
_AdditionalCurrencyRoles _AdditionalCurrencyRoles
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Customer _Customer
_CustomerCompany _CustomerCompany
_GLAccountInCompanyCode _GLAccountInCompanyCode
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_FinancialManagementArea _FinancialManagementArea
_FundsCenter _FundsCenter
_Fund _Fund
_PartnerFund _PartnerFund
_FundedProgram _FundedProgram
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_BudgetPeriod _BudgetPeriod
_PartnerBudgetPeriod _PartnerBudgetPeriod
_Grant _Grant
_PartnerGrant _PartnerGrant
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem
ChartOfAccounts ChartOfAccounts Node Class
ClearingDate ClearingDate Clearing Date
ClearingCreationDate ClearingCreationDate Clrg Creation Date
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
PostingKey PostingKey Posting Key
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode Special G/L Ind
SpecialGLTransactionType Transact.Type
DebitCreditCode DebitCreditCode Single-Character Flag
BusinessArea BusinessArea Business Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
TaxType Tax Type
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
ValueDate ValueDate Value Date
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
PartnerCompany PartnerCompany Trading Partner
FinancialTransactionType FinancialTransactionType Transact. Type
CorporateGroupAccount CorporateGroupAccount Group Account Number
PlanningLevel Planning Level
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
BillingDocument SD Document
SalesDocument SD Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line
ServiceDocumentType Transaction Type
ServiceDocument Transaction ID
ServiceDocumentItem Service Document
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetTransactionType AssetTransactionType Trans.Type
AssetValueDate Reference date
PersonnelNumber Personnel No.
IsSalesRelated Is Sales Related
LineItemDisplayIsEnabled Line Items
IsOpenItemManaged IsOpenItemManaged Open Item Management
IsNotCashDiscountLiable W/o CashDsc.
IsAutomaticallyCreated IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction Is Used In Payment Transaction
OperationalGLAccount Operational G/L Acct
GLAccount GLAccount General Ledger
Customer Sold-to Party
Supplier Supplier
BranchAccount Branch Account No.
IsBalanceSheetAccount IsBalanceSheetAccount Is Balance Sheet Account
ProfitLossAccountType ProfitLossAccountType Profit Loss Account Type
SpecialGLAccountAssignment Special G/L Assignmt
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
PaymentTerms Pyt Terms
CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent Disc. Percent 2
PaymentMethod Pymt Meth.
PaymentBlockingReason Pmnt block
FixedCashDiscount Fixed Cash Discount
HouseBank House Bank
BPBankAccountInternalID BP Bank Account
TaxDistributionCode1 Tax Distr. Code 1
TaxDistributionCode2 Tax Distr. Code 2
TaxDistributionCode3 Tax Distr. Code 3
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Item
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
StateCentralBankPaymentReason SCB Ind.
SupplyingCountry Supplying Ctry/Reg.
InvoiceList Invoice List
BillOfExchangeUsage BillOfExchangeUsage BoE Usage
DunningKey Dunning Key
DunningBlockingReason Set Dunning Block
LastDunningDate Last Dunned
DunningLevel Dunning Level
DunningArea Dunning Area
WithholdingTaxCertificate WHT Certificate
Product Material Vehicle Model
Plant Plant Valuation Area
PurchasingDocument Purchasing Document
PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber Account Assgmt No.
IsCompletelyDelivered Is completely delivered
MaterialPriceControl Price Control
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
VATRegistration VAT Registration No.
DelivOfGoodsDestCountry Dest. C/R
PaymentDifferenceReason Reason Code
ProfitCenter ProfitCenter Profit Center
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVenturePartner JointVenturePartner Joint Venture Partner
TreasuryContractType TreasuryContractType Treasury Contract Type
AssetContract AssetContract Asset Contract
CashFlowType CashFlowType Flow Type
TaxJurisdiction Tax Jurisdiction
REInternalFinNumber REInternalFinNumber Real Estate Key
RealEstateObject RealEstateObject Real Estate Key
SettlementReferenceDate SettlementReferenceDate Reference date
CommitmentItem CommitmentItem Commitment item
CommitmentItemShortID Commitment item
CostObject CostObject Cost Object
ProjectNetwork ProjectNetwork Order
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
WBSElementInternalID WBS Internal ID
ProfitabilitySegment ProfitabilitySegment Profitability Segment
ProfitabilitySegment_2 ProfitabilitySegment_2 Profit. segment
JointVentureEquityType Joint Venture Equity Type
IsEUTriangularDeal Is EU Triangular Deal
CostOriginGroup Origin Group
CompanyCodeCurrencyDetnMethod Co Crcy Detn Meth
ClearingIsReversed ClearingIsReversed Clearing Is Reversed
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
AlternativeGLAccount AlternativeGLAccount Group Account
PartnerProfitCenter PartnerProfitCenter Profit Center
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
IsNegativePosting Negative Posting
PaymentCardItem PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement PaymentCardPaymentSettlement Payment Card Payment Settlement
CreditControlArea Credit Control Area
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 Instruction 4
Region Venue Region
HasPaymentOrder Payment Sent
PaymentReference Payment Reference
TaxDeterminationDate Tx Determination Dte
ClearingItem ClearingItem Clearing Item
BusinessPlace BusinessPlace Business place
TaxSection TaxSection Tax Section
CostCtrActivityType CostCtrActivityType Activity Type
AccountsReceivableIsPledged Accounts Receivable Is Pledged
AcctsReceivablePledgingCode AR Pledging Ind
BusinessProcess BusinessProcess Business Process
FunctionalArea FunctionalArea Sendr Fctl Area
CustomerIsInExecution Customer Is In Execution
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
LedgerGLLineItem Journal Entry Item
Segment Segment Segment number
PartnerSegment PartnerSegment Partner Segment
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
HouseBankAccount House Bank Account
CostElement CostElement G/L Account
PaymentServiceProvider Payt Srvc Provider
PaymentRefByPaytSrvcProvider Reference by PSP
SEPAMandate SEPA Mandate
ReferenceDocumentType Reference Document Type
OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
AccountingDocumentItemRef Position
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
DocumentDate Journal Entry Date
NetDueDate NetDueDate Net Due Date
CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate Cash Discount 2
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts OffsettingChartOfAccounts Offsetting Chart of Accounts
CashLedgerCompanyCode CashLedgerCompanyCode Cash Origin CoCode
CashLedgerAccount CashLedgerAccount Cash Origin Account
FundsCenter FundsCenter Funds Center
FundedProgram FundedProgram Funded Program
Fund Fund Sender Fund
GrantID GrantID Sender Grant
BudgetPeriod BudgetPeriod Budget Period
PartnerFund PartnerFund Receiver Fund
PartnerGrant PartnerGrant Receiver Grant
PartnerBudgetPeriod PartnerBudgetPeriod Partner Budget Period
PubSecBudgetAccount PubSecBudgetAccount Budget Account
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode Company Code for Budget Account
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
ValuationDiffAmtInCoCodeCrcy ValuationDiffAmtInCoCodeCrcy
CashDiscountAmtInCoCodeCrcy Discount Amt
InvoiceAmtInCoCodeCrcy
FunctionalCurrency FunctionalCurrency Functional Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
OriginalTaxBaseAmount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy Value-Added Tax
WithholdingTaxBaseAmount WTax Base Amt
PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmount CD Amount
NetPaymentAmount Net Payment Amount
WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxExemptionAmt WTax-Exempt
InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
ValuationDiffAmtInAddlCrcy1 ValuationDiffAmtInAddlCrcy1
AmountInAdditionalCurrency1 AmountInAdditionalCurrency1 Amount in Additional Currency 1
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
AmountInAdditionalCurrency2 AmountInAdditionalCurrency2 LC2 Amount
ValuationDiffAmtInAddlCrcy2 ValuationDiffAmtInAddlCrcy2
PaymentCurrency Payment Currency
AmountInPaymentCurrency Amount in Payment Currency
CreditControlAreaCurrency Credit Control Area Currency
HedgedAmount
BaseUnit BaseUnit Unit of Measure
AbsoluteQuantity Value
GoodsMovementEntryUnit Unit of Entry
QuantityInEntryUnit Quantity in Unit of Entry
PurchasingDocumentPriceUnit Purchasing Document Price Unit
PurchaseOrderQty Purchase Order Quantity
MaterialPriceUnitQty Price unit
NumberOfItems NumberOfItems
ClearingStatusSelection
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_PostingKey _PostingKey
_FinancialAccountType _FinancialAccountType
_DebitCreditCode _DebitCreditCode
_BusinessArea _BusinessArea
_PartnerBusinessArea _PartnerBusinessArea
_TaxType _TaxType
_ControllingArea _ControllingArea
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_SupplyingCountry _SupplyingCountry
_Product _Product
_Plant _Plant
_BaseUnit _BaseUnit
_InventoryValuationType _InventoryValuationType
_PaymentDifferenceReason _PaymentDifferenceReason
_Segment _Segment
_PartnerSegment _PartnerSegment
_WBSElementBasicData _WBSElementBasicData
_AccountingDocumentType _AccountingDocumentType
_TransactionCurrency _TransactionCurrency
_InternalOrder _InternalOrder
_Order _Order
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetTransactionType _AssetTransactionType
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_ValuationArea _ValuationArea
_ProjectNetwork _ProjectNetwork
_CostCtrActivityType _CostCtrActivityType
_BusinessProcess _BusinessProcess
_FunctionalArea _FunctionalArea
_AdditionalCurrencyRoles _AdditionalCurrencyRoles
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Customer _Customer
_CustomerCompany _CustomerCompany
_GLAccountInCompanyCode _GLAccountInCompanyCode
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_FundsCenter _FundsCenter
_Fund _Fund
_PartnerFund _PartnerFund
_FundedProgram _FundedProgram
_CashLedgerCompanyCode _CashLedgerCompanyCode
_CashLedgerAccount _CashLedgerAccount
_BudgetPeriod _BudgetPeriod
_PartnerBudgetPeriod _PartnerBudgetPeriod
_Grant _Grant
_PartnerGrant _PartnerGrant
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode
_PubSecBudgetAccount _PubSecBudgetAccount
FinancialManagementArea _JournalEntry FinancialManagementArea FM Area
Ledger _JournalEntry Ledger Ledger
LedgerGroup _JournalEntry LedgerGroup Ledger Group
_FinancialManagementArea _JournalEntry _FinancialManagementArea
FinancialManagementArea _JournalEntry FinancialManagementArea FM Area
Ledger _JournalEntry Ledger Ledger
LedgerGroup _JournalEntry LedgerGroup Ledger Group
_FinancialManagementArea _JournalEntry _FinancialManagementArea
FiscalPeriod _JournalEntry FiscalPeriod Tax period
PostingDate _JournalEntry PostingDate Posting Date for GR
AccountingDocumentType _JournalEntry AccountingDocumentType Journal Entry Type
FinancialManagementArea _JournalEntry FinancialManagementArea FM Area
Ledger _JournalEntry Ledger Ledger
LedgerGroup _JournalEntry LedgerGroup Ledger Group
_FinancialManagementArea _JournalEntry _FinancialManagementArea

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_OperationalAcctgDocBrowser.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFIOPACCTGDCBRWS
-- Parameters: P_ClearingStatusSelection : fis_clearingstatusselection

CREATE VIEW P_OperationalAcctgDocBrowser AS
SELECT
  cast( cast( '1' as abap.char(1)) as fis_bstat_grp preserving type ) AS AccountingDocumentCatGroup,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  ChartOfAccounts,
  ClearingDate,
  ClearingCreationDate,
  ClearingJournalEntry,
  ClearingAccountingDocument,
  PostingKey,
  FinancialAccountType,
  SpecialGLCode,
  SpecialGLTransactionType,
  DebitCreditCode,
  BusinessArea,
  PartnerBusinessArea,
  TaxCode,
  WithholdingTaxCode,
  TaxType,
  TransactionTypeDetermination,
  ValueDate,
  AssignmentReference,
  DocumentItemText,
  PartnerCompany,
  FinancialTransactionType,
  CorporateGroupAccount,
  PlanningLevel,
  ControllingArea,
  CostCenter,
  OrderID,
  BillingDocument,
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetValueDate,
  PersonnelNumber,
  IsSalesRelated,
  LineItemDisplayIsEnabled,
  IsOpenItemManaged,
  IsNotCashDiscountLiable,
  IsAutomaticallyCreated,
  IsUsedInPaymentTransaction,
  OperationalGLAccount,
  GLAccount,
  Customer,
  Supplier,
  BranchAccount,
  IsBalanceSheetAccount,
  ProfitLossAccountType,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  FixedCashDiscount,
  HouseBank,
  BPBankAccountInternalID,
  TaxDistributionCode1,
  TaxDistributionCode2,
  TaxDistributionCode3,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  FollowOnDocumentType,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  InvoiceList,
  BillOfExchangeUsage,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  WithholdingTaxCertificate,
  Product,
  Plant,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  IsCompletelyDelivered,
  MaterialPriceControl,
  ValuationArea,
  InventoryValuationType,
  VATRegistration,
  DelivOfGoodsDestCountry,
  PaymentDifferenceReason,
  ProfitCenter,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityGroup,
  JointVenturePartner,
  TreasuryContractType,
  AssetContract,
  CashFlowType,
  TaxJurisdiction,
  REInternalFinNumber,
  RealEstateObject,
  SettlementReferenceDate,
  CommitmentItem,
  CommitmentItemShortID,
  CostObject,
  ProjectNetwork,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  cast( WBSElementInternalID as fis_wbsint_no_conv ) AS WBSElementInternalID,
  cast( case when ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
  ProfitabilitySegment_2,
  JointVentureEquityType,
  IsEUTriangularDeal,
  CostOriginGroup,
  CompanyCodeCurrencyDetnMethod,
  ClearingIsReversed,
  PaymentMethodSupplement,
  AlternativeGLAccount,
  PartnerProfitCenter,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  IsNegativePosting,
  PaymentCardItem,
  PaymentCardPaymentSettlement,
  CreditControlArea,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  ClearingItem,
  BusinessPlace,
  TaxSection,
  CostCtrActivityType,
  AccountsReceivableIsPledged,
  AcctsReceivablePledgingCode,
  BusinessProcess,
  FunctionalArea,
  CustomerIsInExecution,
  ClearingJournalEntryFiscalYear,
  ClearingDocFiscalYear,
  LedgerGLLineItem,
  Segment,
  PartnerSegment,
  PartnerFunctionalArea,
  HouseBankAccount,
  CostElement,
  PaymentServiceProvider,
  PaymentRefByPaytSrvcProvider,
  SEPAMandate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  ReferenceDocumentLogicalSystem,
  AccountingDocumentItemRef,
  FiscalPeriod,
  AccountingDocumentCategory,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  NetDueDate,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInCoCodeCrcy,
  ValuationDiffAmtInCoCodeCrcy,
  cast( CashDiscountAmtInCoCodeCrcy as fis_sknto preserving type ) AS CashDiscountAmtInCoCodeCrcy,
  InvoiceAmtInCoCodeCrcy,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  OriginalTaxBaseAmount,
  TaxAmount,
  TaxBaseAmountInTransCrcy,
  WithholdingTaxBaseAmount,
  PlannedAmtInTransactionCrcy,
  cast( CashDiscountBaseAmount as fis_skfbt preserving type ) AS CashDiscountBaseAmount,
  CashDiscountAmount,
  NetPaymentAmount,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  InvoiceAmountInFrgnCurrency,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  AdditionalCurrency1,
  ValuationDiffAmtInAddlCrcy1,
  AmountInAdditionalCurrency1,
  AdditionalCurrency2,
  AmountInAdditionalCurrency2,
  ValuationDiffAmtInAddlCrcy2,
  PaymentCurrency,
  AmountInPaymentCurrency,
  CreditControlAreaCurrency,
  HedgedAmount,
  BaseUnit,
  cast( Quantity as fis_absolute_quantity ) AS AbsoluteQuantity,
  GoodsMovementEntryUnit,
  QuantityInEntryUnit,
  PurchasingDocumentPriceUnit,
  PurchaseOrderQty,
  MaterialPriceUnitQty,
  NumberOfItems,
  cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) AS ClearingStatusSelection,
  FinancialManagementArea,
  cast( '' as abap.char(2)) AS Ledger,
  LedgerGroup,
  _JournalEntry._FinancialManagementArea AS _FinancialManagementArea
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCurrencyRoles AS _AdditionalCurrencyRoles ON CompanyCode = _AdditionalCurrencyRoles.CompanyCode AND LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup AND Ledger = _AdditionalCurrencyRoles.Ledger  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _CashLedgerAccount ON CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode AND CashLedgerAccount = _CashLedgerAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PubSecBudgetAccountCoCode ON PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Purreqvaluationarea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TaxType AS _TaxType ON TaxType = _TaxType.TaxType  -- association [0..1]
LEFT OUTER JOIN I_Country AS _SupplyingCountry ON SupplyingCountry = _SupplyingCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PaymentDifferenceReason AS _PaymentDifferenceReason ON PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason AND CompanyCode = _PaymentDifferenceReason.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_OperationalAcctgDocItem, I_ParkedOplAcctgDocItem, I_AddlLedgerOplAcctgDocItem
;

Learn More