FAC_DART_Z3_SALES_LINEITEM
Sales Documents - Line Items
FAC_DART_Z3_SALES_LINEITEM is a CDS View that provides data about "Sales Documents - Line Items" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntryItemCube, I_LedgerCompanyCodeCrcyRoles) and exposes 236 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 5 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_JournalEntryItemCube | acc | from |
| I_LedgerCompanyCodeCrcyRoles | I_LedgerCompanyCodeCrcyRoles | inner |
Parameters (4)
| Name | Type | Default |
|---|---|---|
| P_Ledger | fins_ledger | |
| P_FiscalYear | fins_gjahr | |
| P_FromFiscalPeriod | fins_fagl_fiscper_from | |
| P_ToFiscalPeriod | fins_fagl_fiscper_to |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_SalesDocument | vbak | vbak.SalesDocument = acc.SalesDocument |
| [0..1] | I_SalesDocumentItemBasic | vbap | vbap.SalesDocument = acc.SalesDocument and vbap.SalesDocumentItem = acc.SalesDocumentItem |
| [0..1] | I_SalesOrderItem | ord | ord.SalesOrder = acc.SalesDocument and ord.SalesOrderItem = acc.SalesDocumentItem |
| [0..1] | I_FiscalPeriodForVariant | _FromFiscalPeriodForVariant | _FromFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod |
| [0..1] | I_FiscalPeriodForVariant | _ToFiscalPeriodForVariant | _ToFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | FAC_DZSALEITM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Sales Documents - Line Items | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view |
Fields (236)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SourceLedger | SourceLedger | Source Ledger | |
| KEY | CompanyCode | I_JournalEntryItemCube | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | FiscalYear | G/L Fiscal Year | |
| KEY | AccountingDocument | I_JournalEntryItemCube | AccountingDocument | Journal Entry ID |
| KEY | LedgerGLLineItem | I_JournalEntryItemCube | LedgerGLLineItem | Journal Entry Item |
| KEY | Ledger | I_JournalEntryItemCube | Ledger | Ledger |
| SalesOrder | I_JournalEntryItemCube | SalesOrder | SD Document | |
| SalesOrderItem | I_JournalEntryItemCube | SalesOrderItem | Sales Order Item | |
| SalesDocument | SalesDocument | SD Document | ||
| Customer | I_JournalEntryItemCube | Customer | Customer ID | |
| CustomerName | Customer | |||
| SDDocumentCategoryName | Sales Document Category | |||
| SalesDocumentType | vbak | SalesDocumentType | Sales Doc. Type | |
| SalesDocumentTypeName | Sales Document Type | |||
| Material | vbap | Material | Product | |
| MaterialName | Product (Text) | |||
| GLAccount | I_JournalEntryItemCube | GLAccount | G/L Account | |
| GLAccountLongName | G/L Account(Origin)(Text) | |||
| FunctionalArea | I_JournalEntryItemCube | FunctionalArea | Sendr Fctl Area | |
| FunctionalAreaName | Functional Area (Text) | |||
| BusinessTransactionType | I_JournalEntryItemCube | BusinessTransactionType | Bus.transaction | |
| BusinessTransactionTypeName | Business Transaction | |||
| PostingDate | I_JournalEntryItemCube | PostingDate | Posting Date for GR | |
| ReferenceDocumentType | I_JournalEntryItemCube | ReferenceDocumentType | Reference Document Type | |
| ReferenceDocumentTypeName | Source Document Type | |||
| ReferenceDocument | I_JournalEntryItemCube | ReferenceDocument | Source Document ID | |
| AmountInCompanyCodeCurrency | I_JournalEntryItemCube | AmountInCompanyCodeCurrency | Amount Company Currency | |
| CompanyCodeCurrency | I_JournalEntryItemCube | CompanyCodeCurrency | Amount Company Currency (Unit) | |
| Quantity | I_JournalEntryItemCube | Quantity | Actual Entry Quantity | |
| BaseUnit | I_JournalEntryItemCube | BaseUnit | Actual Entry Quantity (Unit) | |
| LedgerFiscalYear | LedgerFiscalYear | |||
| GLRecordType | GLRecordType | Record Type | ||
| ChartOfAccounts | ChartOfAccounts | Node Class | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| ControllingAreaName | ControllingAreaName | Long Text | ||
| FinancialTransactionType | FinancialTransactionType | Transact. Type | ||
| LogicalSystem | LogicalSystem | Logical System | ||
| ReferenceDocumentContext | ReferenceDocumentContext | Reference Document Context | ||
| ReferenceDocumentItem | ReferenceDocumentItem | Reference item | ||
| ReferenceDocumentItemGroup | ReferenceDocumentItemGroup | Reference Document Item Group | ||
| IsReversal | IsReversal | Reversal doc. | ||
| IsReversed | IsReversed | Reversed? | ||
| ReversalReferenceDocumentCntxt | ReversalReferenceDocumentCntxt | Reversal Reference Document Context | ||
| ReversalReferenceDocument | ReversalReferenceDocument | Reversal Reference Document | ||
| IsSettlement | IsSettlement | Is Settling | ||
| IsSettled | IsSettled | Is Settled | ||
| PredecessorReferenceDocType | PredecessorReferenceDocType | Predecessor Reference Document Type | ||
| PredecessorReferenceDocCntxt | PredecessorReferenceDocCntxt | Predecessor Reference Document Context | ||
| PredecessorReferenceDocument | PredecessorReferenceDocument | Predecessor Reference Document | ||
| PredecessorReferenceDocItem | PredecessorReferenceDocItem | Prec. Ref. Doc. Item | ||
| SourceReferenceDocumentType | SourceReferenceDocumentType | Ref. procedure | ||
| SourceLogicalSystem | SourceLogicalSystem | |||
| SourceReferenceDocumentCntxt | SourceReferenceDocumentCntxt | |||
| SourceReferenceDocument | SourceReferenceDocument | Reference Doc. | ||
| SourceReferenceDocumentItem | SourceReferenceDocumentItem | Ref. Doc. Item | ||
| SourceReferenceDocSubitem | SourceReferenceDocSubitem | |||
| IsCommitment | IsCommitment | |||
| GLAccountName | GLAccountName | Short Text | ||
| CostCenter | CostCenter | Cost Center | ||
| CostCenterName | CostCenterName | Name | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| ProfitCenterName | ProfitCenterName | Profit Center Name | ||
| BusinessArea | BusinessArea | Business Area | ||
| BusinessAreaName | BusinessAreaName | Business Area Name | ||
| Segment | Segment | Segment number | ||
| SegmentName | SegmentName | Segment Name | ||
| PartnerCostCenter | PartnerCostCenter | Sender Cost Ctr | ||
| PartnerProfitCenter | PartnerProfitCenter | Profit Center | ||
| PartnerFunctionalArea | PartnerFunctionalArea | Rec. Fntcl Area | ||
| PartnerBusinessArea | PartnerBusinessArea | Trdg Part.BA | ||
| PartnerCompany | PartnerCompany | Trading Partner | ||
| PartnerSegment | PartnerSegment | Partner Segment | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| AmountInTransactionCurrency | AmountInTransactionCurrency | Pt Crcy Amt | ||
| GlobalCurrency | GlobalCurrency | GM Billing Element: Global Currency | ||
| AmountInGlobalCurrency | AmountInGlobalCurrency | Amount in Global Currency | ||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | Freely Defined Currency 1 | ||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | ||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | Freely Defined Currency 2 | ||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | ||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | Freely Defined Currency 3 | ||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | ||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | Freely Defined Currency 4 | ||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | ||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | Freely Defined Currency 5 | ||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | ||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | Freely Defined Currency 6 | ||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | ||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | Freely Defined Currency 7 | ||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | ||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | Freely Defined Currency 8 | ||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | ||
| FixedAmountInGlobalCrcy | FixedAmountInGlobalCrcy | |||
| GrpValnFixedAmtInGlobCrcy | GrpValnFixedAmtInGlobCrcy | |||
| PrftCtrValnFxdAmtInGlobCrcy | PrftCtrValnFxdAmtInGlobCrcy | |||
| TotalPriceVarcInGlobalCrcy | TotalPriceVarcInGlobalCrcy | |||
| GrpValnTotPrcVarcInGlobCrcy | GrpValnTotPrcVarcInGlobCrcy | |||
| PrftCtrValnTotPrcVarcInGlbCrcy | PrftCtrValnTotPrcVarcInGlbCrcy | |||
| FixedPriceVarcInGlobalCrcy | FixedPriceVarcInGlobalCrcy | |||
| GrpValnFixedPrcVarcInGlobCrcy | GrpValnFixedPrcVarcInGlobCrcy | |||
| PrftCtrValnFxdPrcVarcInGlbCrcy | PrftCtrValnFxdPrcVarcInGlbCrcy | |||
| ControllingObjectCurrency | ControllingObjectCurrency | CO Object Currency | ||
| AmountInObjectCurrency | AmountInObjectCurrency | Amount in Obj Crcy | ||
| FixedQuantity | FixedQuantity | Fixed Quantity | ||
| CostSourceUnit | CostSourceUnit | |||
| ValuationQuantity | ValuationQuantity | |||
| ValuationFixedQuantity | ValuationFixedQuantity | |||
| AdditionalQuantity1Unit | AdditionalQuantity1Unit | Add Unit Meas 1 | ||
| AdditionalQuantity1 | AdditionalQuantity1 | |||
| AdditionalQuantity2Unit | AdditionalQuantity2Unit | Add Unit Meas 2 | ||
| AdditionalQuantity2 | AdditionalQuantity2 | |||
| AdditionalQuantity3Unit | AdditionalQuantity3Unit | Add Unit Meas 3 | ||
| AdditionalQuantity3 | AdditionalQuantity3 | |||
| DebitCreditCode | DebitCreditCode | Single-Character Flag | ||
| DebitCreditCodeName | DebitCreditCodeName | |||
| FiscalPeriod | FiscalPeriod | Tax period | ||
| FiscalYearVariant | I_JournalEntryItemCube | FiscalYearVariant | FY Variant | |
| FiscalYearPeriod | FiscalYearPeriod | Period/Year | ||
| DocumentDate | DocumentDate | Journal Entry Date | ||
| AccountingDocumentType | AccountingDocumentType | Journal Entry Type | ||
| AccountingDocumentTypeName | AccountingDocumentTypeName | |||
| AccountingDocumentItem | AccountingDocumentItem | Posting View Item | ||
| AssignmentReference | AssignmentReference | Assignment Reference | ||
| AccountingDocumentCategory | AccountingDocumentCategory | Journal Entry Category | ||
| PostingKey | PostingKey | Posting Key | ||
| TransactionTypeDetermination | TransactionTypeDetermination | Transaction Key | ||
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | SLALineItemType | ||
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | User which created overhead document | ||
| LastChangeDateTime | LastChangeDateTime | Timestamp | ||
| CreationDateTime | CreationDateTime | Timestamp | ||
| CreationDate | CreationDate | Time Stamp | ||
| EliminationProfitCenter | EliminationProfitCenter | |||
| OriginObjectType | OriginObjectType | Origin | ||
| GLAccountType | GLAccountType | G/L Account Type | ||
| AlternativeGLAccount | AlternativeGLAccount | Group Account | ||
| CountryChartOfAccounts | CountryChartOfAccounts | Chart of Accts | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| InvoiceItemReference | InvoiceItemReference | Item | ||
| ReferencePurchaseOrderCategory | ReferencePurchaseOrderCategory | |||
| PurchasingDocument | PurchasingDocument | Purchasing Document | ||
| PurchasingDocumentItem | PurchasingDocumentItem | Purchasing Doc. Item | ||
| AccountAssignmentNumber | AccountAssignmentNumber | Account Assgmt No. | ||
| DocumentItemText | DocumentItemText | Text | ||
| Product | Product | Product Sold | ||
| Plant | Plant | Valuation Area | ||
| Supplier | Supplier | Supplier | ||
| SupplierName | SupplierName | Supplier Name | ||
| ServicesRenderedDate | ServicesRenderedDate | Services Rendered Date | ||
| ConditionContract | ConditionContract | Condition Contract | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| SpecialGLCode | SpecialGLCode | Special G/L Ind | ||
| TaxCode | TaxCode | Tax Code | ||
| HouseBank | HouseBank | House Bank | ||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| IsOpenItemManaged | IsOpenItemManaged | Open Item Management | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingAccountingDocument | ClearingAccountingDocument | Clearing Journal Entry | ||
| ClearingDocFiscalYear | ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| IsCleared | IsCleared | Integer | ||
| AssetDepreciationArea | AssetDepreciationArea | Deprec. Area | ||
| MasterFixedAsset | MasterFixedAsset | Fixed Asset | ||
| FixedAsset | FixedAsset | Sub-number | ||
| AssetValueDate | AssetValueDate | Reference date | ||
| AssetTransactionType | AssetTransactionType | Trans.Type | ||
| AssetAcctTransClassfctn | AssetAcctTransClassfctn | Trans.Type Cat. | ||
| DepreciationFiscalPeriod | DepreciationFiscalPeriod | Deprec. Period | ||
| GroupMasterFixedAsset | GroupMasterFixedAsset | |||
| GroupFixedAsset | GroupFixedAsset | |||
| AssetClass | AssetClass | Asset Class | ||
| CostEstimate | CostEstimate | Cost EstimateNo | ||
| InventorySpecialStockValnType | InventorySpecialStockValnType | Valuation | ||
| InventorySpecialStockType | InventorySpecialStockType | Special Stock Type | ||
| InventorySpclStkSalesDocument | InventorySpclStkSalesDocument | |||
| InventorySpclStkSalesDocItm | InventorySpclStkSalesDocItm | |||
| InvtrySpclStockWBSElmntIntID | InvtrySpclStockWBSElmntIntID | |||
| InvtrySpclStockWBSElmntExtID | InvtrySpclStockWBSElmntExtID | |||
| InventorySpclStockWBSElement | InventorySpclStockWBSElement | |||
| InventorySpecialStockSupplier | InventorySpecialStockSupplier | |||
| InventoryValuationType | InventoryValuationType | Valuation Type | ||
| ValuationArea | ValuationArea | Valuation Area | ||
| SenderGLAccount | SenderGLAccount | |||
| SenderAccountAssignment | SenderAccountAssignment | |||
| SenderAccountAssignmentType | SenderAccountAssignmentType | |||
| ControllingObject | ControllingObject | Object number | ||
| CostOriginGroup | CostOriginGroup | Origin Group | ||
| OriginSenderObject | OriginSenderObject | |||
| ControllingDebitCreditCode | ControllingDebitCreditCode | Dr/Cr ind. CO | ||
| ControllingObjectDebitType | ControllingObjectDebitType | |||
| QuantityIsIncomplete | QuantityIsIncomplete | |||
| OffsettingAccount | OffsettingAccount | Offsetting Acct | ||
| OffsettingAccountName | OffsettingAccountName | |||
| OffsettingAccountType | OffsettingAccountType | Offset Acct Type | ||
| OffsettingChartOfAccounts | OffsettingChartOfAccounts | Offsetting Chart of Accounts | ||
| LineItemIsCompleted | LineItemIsCompleted | Item Completed | ||
| PersonnelNumber | PersonnelNumber | Personnel No. | ||
| BillableControl | BillableControl | Billable Control | ||
| ControllingObjectClass | ControllingObjectClass | Object Class | ||
| PartnerCompanyCode | PartnerCompanyCode | Partner Company Code | ||
| PartnerControllingObjectClass | PartnerControllingObjectClass | |||
| OriginCostCenter | OriginCostCenter | |||
| OriginProfitCenter | OriginProfitCenter | |||
| OriginCostCtrActivityType | OriginCostCtrActivityType | |||
| AccountAssignment | AccountAssignment | Sender Acct Assgmt | ||
| AccountAssignmentType | AccountAssignmentType | Sndr AcctAssgmt Type | ||
| CostCtrActivityType | CostCtrActivityType | Activity Type | ||
| OrderID | OrderID | Order ID | ||
| OrderCategory | OrderCategory | Order Category | ||
| WBSElementInternalID | WBSElementInternalID | WBS Internal ID | ||
| PartnerWBSElementInternalID | PartnerWBSElementInternalID | Partner WBS Element Internal ID | ||
| PartnerWBSElementExternalID | PartnerWBSElementExternalID | Partner WBSElmnt ext | ||
| WBSElementExternalID | WBSElementExternalID | WBS Element External ID | ||
| WBSElement | WBSElement | WBS Internal ID | ||
| ProjectInternalID | ProjectInternalID | Project Def. | ||
| PartnerProjectInternalID | PartnerProjectInternalID | |||
| ProjectExternalID | ProjectExternalID | Project def. | ||
| PartnerProjectExternalID | PartnerProjectExternalID | Partner Project External ID | ||
| WorkPackage | WorkPackage | Plan Item | ||
| Project | Project | WBS Element | ||
| OperatingConcern | OperatingConcern | Operating concern | ||
| ProjectNetwork | ProjectNetwork | Order | ||
| RelatedNetworkActivity | RelatedNetworkActivity | Netwk activity | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| CostObject | CostObject | Cost Object | ||
| CostAnalysisResource | CostAnalysisResource | |||
| CustomerServiceNotification | CustomerServiceNotification | |||
| ServiceDocumentType | ServiceDocumentType | Transaction Type | ||
| ServiceDocument | ServiceDocument | Transaction ID | ||
| ServiceDocumentItem | ServiceDocumentItem | Service Document | ||
| PartnerServiceDocumentType | PartnerServiceDocumentType | Par. Service DocType | ||
| PartnerServiceDocument | PartnerServiceDocument | Partner Service Doc. | ||
| PartnerServiceDocumentItem | PartnerServiceDocumentItem | Par. Service DocItem | ||
| ServiceContractType | ServiceContractType |
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 FAC_DART_Z3_SALES_LINEITEM.
-- 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: FAC_DZSALEITM
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to
CREATE VIEW FAC_DART_Z3_SALES_LINEITEM AS
SELECT
SourceLedger,
acc.CompanyCode AS CompanyCode,
FiscalYear,
acc.AccountingDocument AS AccountingDocument,
acc.LedgerGLLineItem AS LedgerGLLineItem,
acc.Ledger AS Ledger,
acc.SalesOrder AS SalesOrder,
acc.SalesOrderItem AS SalesOrderItem,
SalesDocument,
acc.Customer AS Customer,
acc._CustomerText.CustomerName AS CustomerName,
vbap._SalesDocumentBasic._SDDocumentCategory._Text[1: Language = $session.system_language ].SDDocumentCategoryName AS SDDocumentCategoryName,
vbak.SalesDocumentType AS SalesDocumentType,
vbak._SalesDocumentType._Text[1: Language = $session.system_language ].SalesDocumentTypeName AS SalesDocumentTypeName,
vbap.Material AS Material,
vbap._MaterialText[1: Language = $session.system_language ].MaterialName AS MaterialName,
acc.GLAccount AS GLAccount,
acc._GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
acc.FunctionalArea AS FunctionalArea,
acc._FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
acc.BusinessTransactionType AS BusinessTransactionType,
acc._BusinessTransactionType._Text[1: Language = $session.system_language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
acc.PostingDate AS PostingDate,
acc.ReferenceDocumentType AS ReferenceDocumentType,
acc._ReferenceDocumentType._Text[1: Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
acc.ReferenceDocument AS ReferenceDocument,
acc.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
acc.CompanyCodeCurrency AS CompanyCodeCurrency,
acc.Quantity AS Quantity,
acc.BaseUnit AS BaseUnit,
LedgerFiscalYear,
GLRecordType,
ChartOfAccounts,
ControllingArea,
ControllingAreaName,
FinancialTransactionType,
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
IsReversal,
IsReversed,
ReversalReferenceDocumentCntxt,
ReversalReferenceDocument,
IsSettlement,
IsSettled,
PredecessorReferenceDocType,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocument,
PredecessorReferenceDocItem,
SourceReferenceDocumentType,
SourceLogicalSystem,
SourceReferenceDocumentCntxt,
SourceReferenceDocument,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
GLAccountName,
CostCenter,
CostCenterName,
ProfitCenter,
ProfitCenterName,
BusinessArea,
BusinessAreaName,
Segment,
SegmentName,
PartnerCostCenter,
PartnerProfitCenter,
PartnerFunctionalArea,
PartnerBusinessArea,
PartnerCompany,
PartnerSegment,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
GlobalCurrency,
AmountInGlobalCurrency,
FreeDefinedCurrency1,
AmountInFreeDefinedCurrency1,
FreeDefinedCurrency2,
AmountInFreeDefinedCurrency2,
FreeDefinedCurrency3,
AmountInFreeDefinedCurrency3,
FreeDefinedCurrency4,
AmountInFreeDefinedCurrency4,
FreeDefinedCurrency5,
AmountInFreeDefinedCurrency5,
FreeDefinedCurrency6,
AmountInFreeDefinedCurrency6,
FreeDefinedCurrency7,
AmountInFreeDefinedCurrency7,
FreeDefinedCurrency8,
AmountInFreeDefinedCurrency8,
FixedAmountInGlobalCrcy,
GrpValnFixedAmtInGlobCrcy,
PrftCtrValnFxdAmtInGlobCrcy,
TotalPriceVarcInGlobalCrcy,
GrpValnTotPrcVarcInGlobCrcy,
PrftCtrValnTotPrcVarcInGlbCrcy,
FixedPriceVarcInGlobalCrcy,
GrpValnFixedPrcVarcInGlobCrcy,
PrftCtrValnFxdPrcVarcInGlbCrcy,
ControllingObjectCurrency,
AmountInObjectCurrency,
FixedQuantity,
CostSourceUnit,
ValuationQuantity,
ValuationFixedQuantity,
AdditionalQuantity1Unit,
AdditionalQuantity1,
AdditionalQuantity2Unit,
AdditionalQuantity2,
AdditionalQuantity3Unit,
AdditionalQuantity3,
DebitCreditCode,
DebitCreditCodeName,
FiscalPeriod,
acc.FiscalYearVariant AS FiscalYearVariant,
FiscalYearPeriod,
DocumentDate,
AccountingDocumentType,
AccountingDocumentTypeName,
AccountingDocumentItem,
AssignmentReference,
AccountingDocumentCategory,
PostingKey,
TransactionTypeDetermination,
SubLedgerAcctLineItemType,
AccountingDocCreatedByUser,
LastChangeDateTime,
CreationDateTime,
CreationDate,
EliminationProfitCenter,
OriginObjectType,
GLAccountType,
AlternativeGLAccount,
CountryChartOfAccounts,
InvoiceReference,
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
PurchasingDocument,
PurchasingDocumentItem,
AccountAssignmentNumber,
DocumentItemText,
Product,
Plant,
Supplier,
SupplierName,
ServicesRenderedDate,
ConditionContract,
FinancialAccountType,
SpecialGLCode,
TaxCode,
HouseBank,
HouseBankAccount,
IsOpenItemManaged,
ClearingDate,
ClearingAccountingDocument,
ClearingDocFiscalYear,
IsCleared,
AssetDepreciationArea,
MasterFixedAsset,
FixedAsset,
AssetValueDate,
AssetTransactionType,
AssetAcctTransClassfctn,
DepreciationFiscalPeriod,
GroupMasterFixedAsset,
GroupFixedAsset,
AssetClass,
CostEstimate,
InventorySpecialStockValnType,
InventorySpecialStockType,
InventorySpclStkSalesDocument,
InventorySpclStkSalesDocItm,
InvtrySpclStockWBSElmntIntID,
InvtrySpclStockWBSElmntExtID,
InventorySpclStockWBSElement,
InventorySpecialStockSupplier,
InventoryValuationType,
ValuationArea,
SenderGLAccount,
SenderAccountAssignment,
SenderAccountAssignmentType,
ControllingObject,
CostOriginGroup,
OriginSenderObject,
ControllingDebitCreditCode,
ControllingObjectDebitType,
QuantityIsIncomplete,
OffsettingAccount,
OffsettingAccountName,
OffsettingAccountType,
OffsettingChartOfAccounts,
LineItemIsCompleted,
PersonnelNumber,
BillableControl,
ControllingObjectClass,
PartnerCompanyCode,
PartnerControllingObjectClass,
OriginCostCenter,
OriginProfitCenter,
OriginCostCtrActivityType,
AccountAssignment,
AccountAssignmentType,
CostCtrActivityType,
OrderID,
OrderCategory,
WBSElementInternalID,
PartnerWBSElementInternalID,
PartnerWBSElementExternalID,
WBSElementExternalID,
WBSElement,
ProjectInternalID,
PartnerProjectInternalID,
ProjectExternalID,
PartnerProjectExternalID,
WorkPackage,
Project,
OperatingConcern,
ProjectNetwork,
RelatedNetworkActivity,
BusinessProcess,
CostObject,
CostAnalysisResource,
CustomerServiceNotification,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
PartnerServiceDocumentType,
PartnerServiceDocument,
PartnerServiceDocumentItem,
ServiceContractType
FROM I_JournalEntryItemCube AS acc
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocument AS vbak ON vbak.SalesDocument = acc.SalesDocument -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemBasic AS vbap ON vbap.SalesDocument = acc.SalesDocument AND vbap.SalesDocumentItem = acc.SalesDocumentItem -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS ord ON ord.SalesOrder = acc.SalesDocument AND ord.SalesOrderItem = acc.SalesDocumentItem -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod -- association [0..1]
;Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- 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