What is FAC_DART_Z3_TAX_LINEITEM_BKPF in SAP S/4HANA?

FAC_DART_Z3_TAX_LINEITEM_BKPF is a cds CDS view in SAP S/4HANA. Tax Line Item with BSTAT <> D/M It contains 60 fields.

Which tables does FAC_DART_Z3_TAX_LINEITEM_BKPF read from?

FAC_DART_Z3_TAX_LINEITEM_BKPF reads data from: konp, FAC_DART_Z3_TAX_LINEITEM_BASE, ttxd.

FAC_DART_Z3_TAX_LINEITEM_BKPF

DDL: FAC_DART_Z3_TAX_LINEITEM_BKPF SQL: FAC_DZTAXBKPF Type: view

60 Fields 3 Data Sources

Tax Line Item with BSTAT <> D/M

FAC_DART_Z3_TAX_LINEITEM_BKPF is a CDS View that provides data about "Tax Line Item with BSTAT <> D/M" in SAP S/4HANA. It reads from 3 data sources (konp, FAC_DART_Z3_TAX_LINEITEM_BASE, ttxd) and exposes 60 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem.

Data Sources (3)

Source	Alias	Join Type
konp	konp	left_outer
FAC_DART_Z3_TAX_LINEITEM_BASE	TaxItem	from
ttxd	ttxd	left_outer

Annotations (11)

Name	Value	Level
EndUserText.label	Tax Line Item with BSTAT <> D/M	view
AbapCatalog.sqlViewName	FAC_DZTAXBKPF	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	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
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	FAC_DART_Z3_TAX_LINEITEM_BASE	CompanyCode	Receiver Company Code
KEY	AccountingDocument	FAC_DART_Z3_TAX_LINEITEM_BASE	AccountingDocument	Journal Entry
KEY	FiscalYear	FAC_DART_Z3_TAX_LINEITEM_BASE	FiscalYear	G/L Fiscal Year
KEY	TaxItem	FAC_DART_Z3_TAX_LINEITEM_BASE	TaxItem	Tax Item
	FiscalPeriod	FAC_DART_Z3_TAX_LINEITEM_BASE	FiscalPeriod	Tax period
	PostingDate	FAC_DART_Z3_TAX_LINEITEM_BASE	PostingDate	Posting Date for GR
	TaxCode		TaxCode	Tax Code
	TaxCalculationProcedure	FAC_DART_Z3_TAX_LINEITEM_BASE	TaxCalculationProcedure	Tax Procedure
	ExternalTaxSystemActive	ttxd	xextn	External tax ID
	GLAccount		GLAccount	General Ledger
	TaxItemGroup		TaxItemGroup	Tax doc. item number
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
	ConditionRecord		ConditionRecord	Cond.Record No.
	VATRegistration		VATRegistration	VAT Registration No.
	DestinationCountry		DestinationCountry	Dest. Ctry/Reg
	SupplyingCountry		SupplyingCountry	Supplying Ctry/Reg.
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	ConditionType		ConditionType	Condition type
	TaxReturnDate		TaxReturnDate
	TaxReturnExecutionTime		TaxReturnExecutionTime
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	kbetrelseTaxRateendasTaxRate
	kbetrelseabsTaxRateendasABSTaxRate
	TaxReturnCountry		TaxReturnCountry	Reporting C/R
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxDeterminationDate		TaxDeterminationDate	Tx Determination Dte
	BusinessPlace		BusinessPlace	Business place
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdict. Code
	TaxJurisdictionLevel		TaxJurisdictionLevel	Jurisdiction level
	TaxItemAcctgDocItemRef		TaxItemAcctgDocItemRef	Tax doc. item number
	TaxResultManualModification		TaxResultManualModification	Tax Modified
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	DocumentCurrency		DocumentCurrency	Document Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	CountryCurrency		CountryCurrency	Currency
	TaxRateValidityStartDate		TaxRateValidityStartDate	Tax Rate Validity Start Date
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	_JournalEntry		_JournalEntry
	_AccountingDocument		_AccountingDocument
	_Currency		_Currency
	_GLAccount		_GLAccount
	_CompanyCodeCurrency		_CompanyCodeCurrency
	_CompanyCodeCountry		_CompanyCodeCountry
	_TaxJurisdiction		_TaxJurisdiction
	_DebtorCreditorRblsPyblsItem		_DebtorCreditorRblsPyblsItem
	_TaxReceivablesPayablesItem		_TaxReceivablesPayablesItem
	_ReceivablesPayablesItem		_ReceivablesPayablesItem
	_TaxCode		_TaxCode

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_TAX_LINEITEM_BKPF.
-- 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_DZTAXBKPF

CREATE VIEW FAC_DART_Z3_TAX_LINEITEM_BKPF AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.FiscalPeriod AS FiscalPeriod,
  TaxItem.PostingDate AS PostingDate,
  TaxCode,
  TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  ttxd.xextn AS ExternalTaxSystemActive,
  GLAccount,
  TaxItemGroup,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TransactionTypeDetermination,
  ConditionRecord,
  VATRegistration,
  DestinationCountry,
  SupplyingCountry,
  TaxJurisdiction,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  ConditionType,
  TaxReturnDate,
  TaxReturnExecutionTime,
  TaxReportingDate,
  case when ( TaxRate = 0 and ConditionRecord is not initial ) then konp.kbetr else TaxRate end as TaxRate AS kbetrelseTaxRateendasTaxRate,
  case when ( TaxRate = 0 and ConditionRecord is not initial ) then abs(konp.kbetr) else abs(TaxRate) end as ABSTaxRate AS kbetrelseabsTaxRateendasABSTaxRate,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  TaxDeterminationDate,
  BusinessPlace,
  LowestLevelTaxJurisdiction,
  TaxJurisdictionLevel,
  TaxItemAcctgDocItemRef,
  TaxResultManualModification,
  DebitCreditCode,
  CompanyCodeCurrency,
  CompanyCodeCountry,
  DocumentCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CountryCurrency,
  TaxRateValidityStartDate,
  TaxCountry
FROM FAC_DART_Z3_TAX_LINEITEM_BASE AS TaxItem
LEFT OUTER JOIN ttxd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN konp ON /* join condition not captured in parsed metadata */
;

Depth:

FAC_DART_Z3_TAX_LINEITEM_BKPF view

FAC_DART_Z3_TAX_LINEITEM_TX view