P_STRPCALTAXRETURNBOX

CDS View
36 Fields 1 CDS Views

P_STRPCALTAXRETURNBOX is a CDS View in S/4HANA. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StRpTaxReturnBoxCube view from COMPOSITE Cube View to Return Tax Details with TaxBox configuration

Fields (36)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AccountingDocumentType AccountingDocumentType 2
KEY CompanyCode CompanyCode 2
KEY DebitCreditCode DebitCreditCode 2
KEY FiscalYear FiscalYear 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY SupplierAccountGroup SupplierAccountGroup 1
KEY TaxBox TaxBox 2
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 2
KEY TaxDeclnAmountType TaxDeclnAmountType 2
KEY TaxGroup TaxGroup 2
KEY TaxItem TaxItem 2
KEY TaxItemGrpgDebitCreditCode TaxItemGrpgDebitCreditCode 2
KEY TaxItemGrpgSpecialGLCode TaxItemGrpgSpecialGLCode 2
KEY TransactionTypeDetermination TransactionTypeDetermination 2
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 2
CAReconciliationKey CAReconciliationKey 1
Country Country 1
StatryRptRun StatryRptRun 1
TaxBoxAggregationOperation TaxBoxAggregationOperation 1
TaxBoxCondition TaxBoxCondition 1
TaxBoxName TaxBoxName 1
TaxBoxStructure TaxBoxStructure 1
TaxBoxStructureType TaxBoxStructureType 2
TaxCode TaxCode 2
TaxCountry TaxCountry 1
TaxGroupOperation TaxGroupOperation 1
TaxIsNotDeductible TaxIsNotDeductible 1
TaxItemGroupingAccountNumber TaxItemGroupingAccountNumber 1
TaxItemGroupingVersion TaxItemGroupingVersion 2
TaxJurisdiction TaxJurisdiction 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
ValidFrom ValidFrom 2
ValidTo ValidTo 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_STRPCALTAXRETURNBOX (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIERACCOUNTGROUP,
    TAXBOX,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGRPGDEBITCREDITCODE,
    TAXITEMGRPGSPECIALGLCODE,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    CARECONCILIATIONKEY,
    COUNTRY,
    STATRYRPTRUN,
    TAXBOXAGGREGATIONOPERATION,
    TAXBOXCONDITION,
    TAXBOXNAME,
    TAXBOXSTRUCTURE,
    TAXBOXSTRUCTURETYPE,
    TAXCODE,
    TAXCOUNTRY,
    TAXGROUPOPERATION,
    TAXISNOTDEDUCTIBLE,
    TAXITEMGROUPINGACCOUNTNUMBER,
    TAXITEMGROUPINGVERSION,
    TAXJURISDICTION,
    TAXRATEVALIDITYSTARTDATE,
    VALIDFROM,
    VALIDTO,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIERACCOUNTGROUP, TAXBOX, TAXBOXSTRUCVALIDITYSTARTDATE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGRPGDEBITCREDITCODE, TAXITEMGRPGSPECIALGLCODE, TRANSACTIONTYPEDETERMINATION, UNIFIEDTAXBOXSTRUCTURETYPE)
);

Learn More