A_OperationalAcctgDocItemCube
Operational Accounting Document Items
A_OperationalAcctgDocItemCube is a Composite CDS View that provides data about "Operational Accounting Document Items" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocCube) and exposes 270 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_OperationalAcctgDocCube | I_OperationalAcctgDocCube | from |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | AFIOPACCTGDOCCUB | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Operational Accounting Document Items | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view |
Fields (270)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | CompanyCode | Receiver Company Code | |
| KEY | FiscalYear | FiscalYear | G/L Fiscal Year | |
| KEY | AccountingDocument | AccountingDocument | Journal Entry | |
| KEY | AccountingDocumentItem | AccountingDocumentItem | Posting View Item | |
| CompanyCodeName | CompanyCodeName | Company Name | ||
| ChartOfAccounts | ChartOfAccounts | Node Class | ||
| AccountingDocumentItemType | AccountingDocumentItemType | Line Item ID | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingCreationDate | ClearingCreationDate | Clrg Creation Date | ||
| ClearingAccountingDocument | ClearingJournalEntry | Clrng doc. | ||
| IsCleared | IsCleared | Integer | ||
| 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 | ||
| BusinessAreaName | BusinessAreaName | Business Area Name | ||
| 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 | ||
| ControllingAreaName | ControllingAreaName | Long Text | ||
| CostCenter | CostCenter | Cost Center | ||
| CostCenterName | CostCenterName | Name | ||
| Project | Project | WBS Element | ||
| OrderID | OrderID | Order ID | ||
| BillingDocument | BillingDocument | SD Document | ||
| SalesDocument | SalesDocument | SD Document | ||
| SalesDocumentItem | SalesDocumentItem | Sales Document Item | ||
| ScheduleLine | ScheduleLine | Schedule Line | ||
| 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 | ||
| GLAccountName | GLAccountName | Short Text | ||
| GLAccountLongName | GLAccountLongName | Long Text | ||
| Customer | Customer | Sold-to Party | ||
| CustomerName | CustomerName | Name of Customer | ||
| Supplier | Supplier | Supplier | ||
| SupplierName | SupplierName | Supplier Name | ||
| 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 | ||
| Material | Material | Vehicle Model | ||
| Product | Product | Product Sold | ||
| 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 | ||
| ProfitCenterName | ProfitCenterName | Profit Center Name | ||
| 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 | ||
| RealEstateObject | RealEstateObject | Real Estate Key | ||
| SettlementReferenceDate | SettlementReferenceDate | Reference date | ||
| CommitmentItem | CommitmentItem | 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_2 | Profit. segment | ||
| JointVentureBillingType | JointVentureBillingType | |||
| 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 | ||
| FundsCenter | FundsCenter | Funds Center | ||
| Fund | Fund | Sender Fund | ||
| 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 | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| GrantID | GrantID | Sender Grant | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| FunctionalAreaName | FunctionalAreaName | Long Text | ||
| CustomerIsInExecution | CustomerIsInExecution | Customer Is In Execution | ||
| FundedProgram | FundedProgram | Funded Program | ||
| ClearingDocFiscalYear | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| LedgerGLLineItem | LedgerGLLineItem | Journal Entry Item | ||
| Segment | Segment | Segment number | ||
| SegmentName | SegmentName | Segment Name | ||
| PartnerSegment | PartnerSegment | Partner Segment | ||
| PartnerFunctionalArea | PartnerFunctionalArea | Rec. Fntcl Area | ||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| CostElement | CostElement | G/L Account | ||
| 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 | ||
| AccountingDocumentCategoryName | AccountingDocumentCategoryName | |||
| PostingDate | PostingDate | Posting Date for GR | ||
| DocumentDate | DocumentDate | Journal Entry Date | ||
| AccountingDocumentType | AccountingDocumentType | Journal Entry Type | ||
| AccountingDocumentTypeName | AccountingDocumentTypeName | |||
| NetDueDate | NetDueDate | Net Due Date | ||
| CashDiscount1DueDate | CashDiscount1DueDate | Cash Discount 1 | ||
| CashDiscount2DueDate | CashDiscount2DueDate | Cash Discount 2 | ||
| OffsettingAccount | OffsettingAccount | Offsetting Acct | ||
| OffsettingAccountType | OffsettingAccountType | Offset Acct Type | ||
| PartnerFund | PartnerFund | Receiver Fund | ||
| PartnerGrant | PartnerGrant | Receiver Grant | ||
| BudgetPeriod | BudgetPeriod | Budget Period | ||
| PartnerBudgetPeriod | PartnerBudgetPeriod | Partner Budget Period | ||
| BranchCode | BranchCode | Branch Code | ||
| JointVentureProductionDate | JointVentureProductionDate | |||
| CompanyCodeCurrency | CompanyCodeCurrency | Local Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Local Crcy Amt | ||
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | Tax Amount in Company Code Currency | ||
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | TxBaseAmt CoCodeCrcy | ||
| ValuationDiffAmtInCoCodeCrcy | ValuationDiffAmtInCoCodeCrcy | |||
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | Discount Amt | ||
| InvoiceAmtInCoCodeCrcy | InvoiceAmtInCoCodeCrcy | |||
| 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 | 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 | ||
| Quantity | Quantity | Value | ||
| GoodsMovementEntryUnit | GoodsMovementEntryUnit | Unit of Entry | ||
| QuantityInEntryUnit | Quantity in Unit of Entry | |||
| PurchasingDocumentPriceUnit | PurchasingDocumentPriceUnit | Purchasing Document Price Unit | ||
| PurchaseOrderQty | Purchase Order Quantity | |||
| MaterialPriceUnitQty | MaterialPriceUnitQty | Price unit | ||
| NumberOfItems | NumberOfItems | |||
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | Journal Entry Date | ||
| CreationTime | CreationTime | Time of Change | ||
| LastChangeDate | LastChangeDate | Time Stamp | ||
| ExchangeRateDate | ExchangeRateDate | Translatn Date | ||
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | User which created overhead document | ||
| TransactionCode | TransactionCode | Transaction Code | ||
| IntercompanyTransaction | IntercompanyTransaction | Intercompany Transaction | ||
| DocumentReferenceID | DocumentReferenceID | Reference | ||
| RecurringAccountingDocument | RecurringAccountingDocument | Recurring Journal Entry | ||
| ReverseDocument | ReverseDocument | Reversed With | ||
| ReverseDocumentFiscalYear | ReverseDocumentFiscalYear | Year | ||
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | Doc.Header Text | ||
| ExchangeRate | ExchangeRate | Exchange rate | ||
| BusinessTransactionType | BusinessTransactionType | Bus.transaction | ||
| BatchInputSession | BatchInputSession | |||
| FinancialManagementArea | FinancialManagementArea | FM Area | ||
| ReversalIsPlanned | ReversalIsPlanned | |||
| PlannedReversalDate | PlannedReversalDate | Reversal Date | ||
| TaxIsCalculatedAutomatically | TaxIsCalculatedAutomatically | Tax Is Automatically Calculated | ||
| TaxBaseAmountIsNetAmount | TaxBaseAmountIsNetAmount | Tax Base Amount is Net Amount | ||
| SourceCompanyCode | SourceCompanyCode | |||
| LogicalSystem | LogicalSystem | Logical System | ||
| TaxExchangeRate | TaxExchangeRate | Rate for Taxes | ||
| ReversalReason | ReversalReason | Reversal Reason | ||
| Branch | Branch | Repository branch | ||
| Reference1InDocumentHeader | Reference1InDocumentHeader | Reference 1 | ||
| Reference2InDocumentHeader | Reference2InDocumentHeader | Reference 2 | ||
| InvoiceReceiptDate | InvoiceReceiptDate | Invoice Receipt Date | ||
| Ledger | Ledger | Ledger | ||
| LedgerGroup | LedgerGroup | Ledger Group | ||
| AlternativeReferenceDocument | AlternativeReferenceDocument | Alternative Reference Document | ||
| TaxReportingDate | TaxReportingDate | Tax Reporting Date | ||
| AccountingDocumentClass | AccountingDocumentClass | |||
| ExchangeRateType | ExchangeRateType | Exch. Rate Type | ||
| LatePaymentReason | LatePaymentReason | |||
| SalesDocumentCondition | SalesDocumentCondition | |||
| IsReversal | IsReversal | Reversal doc. | ||
| IsReversed | IsReversed | Reversed? |
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 A_OperationalAcctgDocItemCube.
-- 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: AFIOPACCTGDOCCUB
CREATE VIEW A_OperationalAcctgDocItemCube AS
SELECT
CompanyCode,
FiscalYear,
AccountingDocument,
AccountingDocumentItem,
CompanyCodeName,
ChartOfAccounts,
AccountingDocumentItemType,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntry AS ClearingAccountingDocument,
IsCleared,
PostingKey,
FinancialAccountType,
SpecialGLCode,
SpecialGLTransactionType,
DebitCreditCode,
BusinessArea,
BusinessAreaName,
PartnerBusinessArea,
TaxCode,
WithholdingTaxCode,
TaxType,
TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
PartnerCompany,
FinancialTransactionType,
CorporateGroupAccount,
PlanningLevel,
ControllingArea,
ControllingAreaName,
CostCenter,
CostCenterName,
Project,
OrderID,
BillingDocument,
SalesDocument,
SalesDocumentItem,
ScheduleLine,
MasterFixedAsset,
FixedAsset,
AssetTransactionType,
AssetValueDate,
PersonnelNumber,
IsSalesRelated,
LineItemDisplayIsEnabled,
IsOpenItemManaged,
IsNotCashDiscountLiable,
IsAutomaticallyCreated,
IsUsedInPaymentTransaction,
OperationalGLAccount,
GLAccount,
GLAccountName,
GLAccountLongName,
Customer,
CustomerName,
Supplier,
SupplierName,
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,
Material,
Product,
Plant,
PurchasingDocument,
PurchasingDocumentItem,
AccountAssignmentNumber,
IsCompletelyDelivered,
MaterialPriceControl,
ValuationArea,
InventoryValuationType,
VATRegistration,
DelivOfGoodsDestCountry,
PaymentDifferenceReason,
ProfitCenter,
ProfitCenterName,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVenturePartner,
TreasuryContractType,
AssetContract,
CashFlowType,
TaxJurisdiction,
RealEstateObject,
SettlementReferenceDate,
CommitmentItem,
CostObject,
ProjectNetwork,
OrderInternalBillOfOperations,
OrderIntBillOfOperationsItem,
cast ( WBSElementInternalID as ps_posnr1 ) AS WBSElementInternalID,
ProfitabilitySegment_2 AS ProfitabilitySegment,
JointVentureBillingType,
JointVentureEquityType,
IsEUTriangularDeal,
CostOriginGroup,
CompanyCodeCurrencyDetnMethod,
ClearingIsReversed,
PaymentMethodSupplement,
AlternativeGLAccount,
FundsCenter,
Fund,
PartnerProfitCenter,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
IsNegativePosting,
PaymentCardItem,
PaymentCardPaymentSettlement,
CreditControlArea,
Reference3IDByBusinessPartner,
DataExchangeInstruction1,
DataExchangeInstruction2,
DataExchangeInstruction3,
DataExchangeInstruction4,
Region,
HasPaymentOrder,
PaymentReference,
TaxDeterminationDate,
ClearingItem,
BusinessPlace,
TaxSection,
CostCtrActivityType,
AccountsReceivableIsPledged,
BusinessProcess,
GrantID,
FunctionalArea,
FunctionalAreaName,
CustomerIsInExecution,
FundedProgram,
ClearingJournalEntryFiscalYear AS ClearingDocFiscalYear,
LedgerGLLineItem,
Segment,
SegmentName,
PartnerSegment,
PartnerFunctionalArea,
HouseBankAccount,
CostElement,
SEPAMandate,
ReferenceDocumentType,
OriginalReferenceDocument,
ReferenceDocumentLogicalSystem,
AccountingDocumentItemRef,
FiscalPeriod,
AccountingDocumentCategory,
AccountingDocumentCategoryName,
PostingDate,
DocumentDate,
AccountingDocumentType,
AccountingDocumentTypeName,
NetDueDate,
CashDiscount1DueDate,
CashDiscount2DueDate,
OffsettingAccount,
OffsettingAccountType,
PartnerFund,
PartnerGrant,
BudgetPeriod,
PartnerBudgetPeriod,
BranchCode,
JointVentureProductionDate,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
TaxAmountInCoCodeCrcy,
TaxBaseAmountInCoCodeCrcy,
ValuationDiffAmtInCoCodeCrcy,
CashDiscountAmtInCoCodeCrcy,
InvoiceAmtInCoCodeCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
OriginalTaxBaseAmount,
TaxAmount,
TaxBaseAmountInTransCrcy,
WithholdingTaxBaseAmount,
PlannedAmtInTransactionCrcy,
CashDiscountBaseAmount,
CashDiscountAmount,
NetPaymentAmount,
WithholdingTaxAmount,
WithholdingTaxExemptionAmt,
InvoiceAmountInFrgnCurrency,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
AdditionalCurrency1,
ValuationDiffAmtInAddlCrcy1,
AmountInAdditionalCurrency1,
AdditionalCurrency2,
AmountInAdditionalCurrency2,
ValuationDiffAmtInAddlCrcy2,
PaymentCurrency,
AmountInPaymentCurrency,
CreditControlAreaCurrency,
HedgedAmount,
BaseUnit,
Quantity,
GoodsMovementEntryUnit,
cast(QuantityInEntryUnit as quantityinentryunit) AS QuantityInEntryUnit,
PurchasingDocumentPriceUnit,
cast(PurchaseOrderQty as fis_bpmng) AS PurchaseOrderQty,
MaterialPriceUnitQty,
NumberOfItems,
AccountingDocumentCreationDate,
CreationTime,
LastChangeDate,
ExchangeRateDate,
AccountingDocCreatedByUser,
TransactionCode,
IntercompanyTransaction,
DocumentReferenceID,
RecurringAccountingDocument,
ReverseDocument,
ReverseDocumentFiscalYear,
AccountingDocumentHeaderText,
ExchangeRate,
BusinessTransactionType,
BatchInputSession,
FinancialManagementArea,
ReversalIsPlanned,
PlannedReversalDate,
TaxIsCalculatedAutomatically,
TaxBaseAmountIsNetAmount,
SourceCompanyCode,
LogicalSystem,
TaxExchangeRate,
ReversalReason,
Branch,
Reference1InDocumentHeader,
Reference2InDocumentHeader,
InvoiceReceiptDate,
Ledger,
LedgerGroup,
AlternativeReferenceDocument,
TaxReportingDate,
AccountingDocumentClass,
ExchangeRateType,
LatePaymentReason,
SalesDocumentCondition,
IsReversal,
IsReversed
FROM I_OperationalAcctgDocCube
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA