P_STRPBPTAXITEM1

CDS View
24 Fields 3 CDS Views

P_STRPBPTAXITEM1 is a CDS View in S/4HANA. It contains 24 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_StRpBPTaxItem14 view from COMPOSITE
P_StRpBPTaxItem4 view from COMPOSITE
P_StRpBPTaxItemX view_entity from COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 3
KEY TaxItem TaxItem 3
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionType ConditionType 3
GLAccount GLAccount 3
ReportingCountry ReportingCountry 3
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 3
TaxAmountInCountryCrcy TaxAmountInCountryCrcy 3
TaxAmountInTransCrcy TaxAmountInTransCrcy 3
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 3
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 3
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 3
TaxCalculationProcedure TaxCalculationProcedure 3
TaxCode TaxCode 3
TaxJurisdiction TaxJurisdiction 3
TaxRateValidityStartDate TaxRateValidityStartDate 3
TaxResultManualModification TaxResultManualModification 3
TaxReturnCountry TaxReturnCountry 1
TaxType TaxType 3
TransactionTypeDetermination TransactionTypeDetermination 3
VATRegistration VATRegistration 3

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 P_STRPBPTAXITEM1 (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXITEM,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    GLACCOUNT,
    REPORTINGCOUNTRY,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXJURISDICTION,
    TAXRATEVALIDITYSTARTDATE,
    TAXRESULTMANUALMODIFICATION,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    TRANSACTIONTYPEDETERMINATION,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXITEM)
);

Learn More