BPTAXITEM

97 Fields

BPTAXITEM is an SAP database table in S/4HANA. It contains 97 fields.

Fields (97)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CO_DIANReportFormat CO_DIANReportFormat 4
KEY CO_DIANReportItemType CO_DIANReportItemType 4
KEY CompanyCode CompanyCode 4
KEY FiscalYear FiscalYear 4
KEY ReportedTaxNumber ReportedTaxNumber 1
KEY StatryRptCategory StatryRptCategory 4
KEY StatryRptgEntity StatryRptgEntity 4
KEY StatryRptRunID StatryRptRunID 4
KEY TaxItem TaxItem 4
_AccountingDocumentType _AccountingDocumentType 3
_CompanyCodeCountry _CompanyCodeCountry 3
_CompanyCodeCurrency _CompanyCodeCurrency 3
_Customer _Customer 1
_OneTimeAccountBP _OneTimeAccountBP 1
_ReportingCurrency _ReportingCurrency 3
_Supplier _Supplier 1
_TaxType _TaxType 3
AccountingDocumentItem AccountingDocumentItem 4
AccountingDocumentType AccountingDocumentType 4
AdditionalLastName AdditionalLastName 2
BusinessPartner BusinessPartner 2
BusinessPartnerCategory BusinessPartnerCategory 2
BusinessPartnerCountry BusinessPartnerCountry 2
BusinessPartnerUUID BusinessPartnerUUID 2
BusinessPlace BusinessPlace 3
CityCode CityCode 1
CityName CityName 2
CnsmpnTxAmtInCountryCurrency CnsmpnTxAmtInCountryCurrency 2
CO_DIANAmountClassification CO_DIANAmountClassification 4
CO_DIANBPTaxLongNumber CO_DIANBPTaxLongNumber 3
CO_DIANTaxNumberType CO_DIANTaxNumberType 1
CO_VATHigherThanCostAmount CO_VATHigherThanCostAmount 2
CompanyCodeCountry CompanyCodeCountry 4
CompanyCodeCurrency CompanyCodeCurrency 4
CountryCurrency CountryCurrency 4
Customer Customer 3
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 4
DocumentReferenceID DocumentReferenceID 1
FirstName FirstName 2
GLAccount GLAccount 4
GLAccountName GLAccountName 1
InptTxCrdtAmtInCntryCurrency InptTxCrdtAmtInCntryCurrency 2
InptTxDebitAmtInCntryCurrency InptTxDebitAmtInCntryCurrency 2
InvoiceReference InvoiceReference 1
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
IsNaturalPerson IsNaturalPerson 2
LastName LastName 2
MiddleName MiddleName 2
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
OrganizationBPName3 OrganizationBPName3 2
OrganizationBPName4 OrganizationBPName4 2
OriginalReferenceDocument OriginalReferenceDocument 4
OutpTxCrdtAmtInCntryCurrency OutpTxCrdtAmtInCntryCurrency 2
OutpTxDebitAmtInCntryCurrency OutpTxDebitAmtInCntryCurrency 2
PostingDate PostingDate 4
PostingFiscalPeriod PostingFiscalPeriod 1
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 3
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 3
ReferenceDocument ReferenceDocument 4
ReferenceDocumentContext ReferenceDocumentContext 4
Region Region 1
ReportingCountry ReportingCountry 4
ReportingCurrency ReportingCurrency 4
ReportingDate ReportingDate 4
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
StreetName StreetName 1
Supplier Supplier 3
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 4
TaxAmountInCountryCrcy TaxAmountInCountryCrcy 4
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 1
TaxAmountInTransCrcy TaxAmountInTransCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 4
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 4
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount 1
TaxCalculationProcedure TaxCalculationProcedure 4
TaxCode TaxCode 4
TaxCodeName TaxCodeName 1
TaxJurisdiction TaxJurisdiction 4
TaxNumber1 TaxNumber1 2
TaxNumber2 TaxNumber2 2
TaxNumber3 TaxNumber3 2
TaxNumber4 TaxNumber4 2
TaxNumber5 TaxNumber5 2
TaxNumberType TaxNumberType 2
TaxRate TaxRate 1
TaxReportingDate TaxReportingDate 4
TaxResultManualModification TaxResultManualModification 1
TaxReturnCountry TaxReturnCountry 4
TaxType TaxType 4
TransactionTypeDetermination TransactionTypeDetermination 4
VATRegistration VATRegistration 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BPTAXITEM (
    ACCOUNTINGDOCUMENT,
    CO_DIANREPORTFORMAT,
    CO_DIANREPORTITEMTYPE,
    COMPANYCODE,
    FISCALYEAR,
    REPORTEDTAXNUMBER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXITEM,
    _ACCOUNTINGDOCUMENTTYPE,
    _COMPANYCODECOUNTRY,
    _COMPANYCODECURRENCY,
    _CUSTOMER,
    _ONETIMEACCOUNTBP,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    _TAXTYPE,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALLASTNAME,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERUUID,
    BUSINESSPLACE,
    CITYCODE,
    CITYNAME,
    CNSMPNTXAMTINCOUNTRYCURRENCY,
    CO_DIANAMOUNTCLASSIFICATION,
    CO_DIANBPTAXLONGNUMBER,
    CO_DIANTAXNUMBERTYPE,
    CO_VATHIGHERTHANCOSTAMOUNT,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRYCURRENCY,
    CUSTOMER,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FIRSTNAME,
    GLACCOUNT,
    GLACCOUNTNAME,
    INPTTXCRDTAMTINCNTRYCURRENCY,
    INPTTXDEBITAMTINCNTRYCURRENCY,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISNATURALPERSON,
    LASTNAME,
    MIDDLENAME,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    ORIGINALREFERENCEDOCUMENT,
    OUTPTXCRDTAMTINCNTRYCURRENCY,
    OUTPTXDEBITAMTINCNTRYCURRENCY,
    POSTINGDATE,
    POSTINGFISCALPERIOD,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REGION,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    STREETNAME,
    SUPPLIER,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTISNETAMOUNT,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXCODENAME,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXRESULTMANUALMODIFICATION,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    TRANSACTIONTYPEDETERMINATION,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CO_DIANREPORTFORMAT, CO_DIANREPORTITEMTYPE, COMPANYCODE, FISCALYEAR, REPORTEDTAXNUMBER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, TAXITEM)
);

Learn More