FAC_DART_Z3_AR_LINEITEM_BASE

CDS View
29 Fields 1 CDS Views

Account Receivable - Line Items Base

FAC_DART_Z3_AR_LINEITEM_BASE is a CDS View in S/4HANA. Account Receivable - Line Items Base. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAC_DART_Z3_AR_LINEITEM view from Account Receivable - Line Items

Fields (29)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
_ChartOfAccounts _ChartOfAccounts 1
_ChartOfAccountsText _ChartOfAccountsText 1
_CompanyCode _CompanyCode 1
_ControllingArea _ControllingArea 1
_ControllingAreaText _ControllingAreaText 1
AdditionalCurrency1 AdditionalCurrency1 1
AdditionalCurrency2 AdditionalCurrency2 1
BusinessPlace BusinessPlace 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency,CreditCompanyCodeCurrency,DebitCompanyCodeCurrency 1
ControllingArea ControllingArea 1
CreditControlArea CreditControlArea 1
DebitCreditCode DebitCreditCode 1
GLAccount GLAccount 1
SupplyingCountry SupplyingCountry 1
TaxAmount TaxAmount 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCode TaxCode 1
TaxCountry TaxCountry 1
TaxDeterminationDate TaxDeterminationDate 1
TaxItemGroup TaxItemGroup 1
TaxJurisdiction TaxJurisdiction 1
TransactionTypeDetermination TransactionTypeDetermination 1
VATRegistration VATRegistration 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Account Receivable - Line Items Base
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAC_DART_Z3_AR_LINEITEM_BASE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    _CHARTOFACCOUNTS,
    _CHARTOFACCOUNTSTEXT,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _CONTROLLINGAREATEXT,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    BUSINESSPLACE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CREDITCONTROLAREA,
    DEBITCREDITCODE,
    GLACCOUNT,
    SUPPLYINGCOUNTRY,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TRANSACTIONTYPEDETERMINATION,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More