I_STRPBPTAXITEM

CDS View
45 Fields 11 CDS Views

Business Partner Tax Item

I_STRPBPTAXITEM is a CDS View in S/4HANA. Business Partner Tax Item. It contains 45 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_CA_StRpTaxItemCube view from CONSUMPTION Consumption view for Canada GST Return
P_HU_AuditReport view from COMPOSITE
P_Hu_FIInvItem view from COMPOSITE
P_HU_MMInvItem view from COMPOSITE
P_Hu_SDInvItem view from COMPOSITE
P_KR_BPAdditionalInformation view from COMPOSITE
P_KR_BPAdditionalInformation view union COMPOSITE
P_PH_SalesPurchasesSummaryItem view left_outer COMPOSITE
P_PH_SuplrCustJrnlTaxAmount view from COMPOSITE
P_TH_StRpTaxItems view left_outer COMPOSITE
P_VE_StRpBPTaxItem view_entity inner COMPOSITE

Fields (45)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY CompanyCode CompanyCode 6
KEY FiscalYear FiscalYear 5
KEY TaxCode TaxCode 5
KEY TaxItem AccountingDocumentItem,TaxItem 3
KEY TransactionTypeDetermination TransactionTypeDetermination 1
_AccountingDocument _AccountingDocument 2
_BillingDocument _BillingDocument 1
_BusinessPartner _BusinessPartner 1
_CompanyCodeCurrency _CompanyCodeCurrency 2
_OneTimeAccountBP _OneTimeAccountBP 1
_ReceivablesPayablesItem _ReceivablesPayablesItem 1
_SupplierInvoice _SupplierInvoice 1
_TaxType _TaxType 1
AccountingDocumentItem AccountingDocumentItem 4
AccountingDocumentType AccountingDocumentType 1
AuthorizationGroup AuthorizationGroup 4
BusinessPartnerUUID BusinessPartnerUUID 1
CompanyCodeCurrency CompanyCodeCurrency 5
Customer Customer 5
DocumentCurrency DocumentCurrency 2
DocumentDate DocumentDate 5
DocumentReferenceID DocumentReferenceID 5
FinancialAccountType FinancialAccountType 6
InvoiceReference InvoiceReference 5
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 5
OriginalReferenceDocument OriginalReferenceDocument 4
PostingDate PostingDate 6
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 5
ReportingDate ReportingDate 1
SenderAccountingDocument SenderAccountingDocument 1
SenderCompanyCode SenderCompanyCode 1
SenderFiscalYear SenderFiscalYear 1
SenderLogicalSystem SenderLogicalSystem 1
Supplier Supplier,vencustnum 5
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 5
TaxAmountInTransCrcy TaxAmountInTransCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 5
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCalculationProcedure TaxCalculationProcedure 1
TaxRate TaxRate 5
TaxReportingDate TaxReportingDate 1
TaxType TaxType 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.

-- Business Partner Tax Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPBPTAXITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXCODE,
    TAXITEM,
    TRANSACTIONTYPEDETERMINATION,
    _ACCOUNTINGDOCUMENT,
    _BILLINGDOCUMENT,
    _BUSINESSPARTNER,
    _COMPANYCODECURRENCY,
    _ONETIMEACCOUNTBP,
    _RECEIVABLESPAYABLESITEM,
    _SUPPLIERINVOICE,
    _TAXTYPE,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERUUID,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FINANCIALACCOUNTTYPE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ORIGINALREFERENCEDOCUMENT,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REPORTINGDATE,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    SUPPLIER,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXRATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXCODE, TAXITEM, TRANSACTIONTYPEDETERMINATION)
);

Learn More