P_PT_TAXRETURNBOXITEM

CDS View
66 Fields 1 CDS Views

Portugal Tax Items

P_PT_TAXRETURNBOXITEM is a CDS View in S/4HANA. Portugal Tax Items. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PT_TaxRetBoxItemWithRegn view_entity from COMPOSITE PT Tax Items with Registration detail

Fields (66)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY AccountingDocumentType AccountingDocumentType 4
KEY CADocumentNumber CADocumentNumber 3
KEY CAGLItemNumber CAGLItemNumber 3
KEY CompanyCode CompanyCode 4
KEY DebitCreditCode DebitCreditCode 4
KEY FiscalYear FiscalYear 4
KEY StatryRptCategory StatryRptCategory 4
KEY StatryRptgEntity StatryRptgEntity 4
KEY StatryRptRunID StatryRptRunID 4
KEY SupplierAccountGroup SupplierAccountGroup 4
KEY TaxBox TaxBox 4
KEY TaxCalculationProcedure TaxCalculationProcedure 4
KEY TaxCode TaxCode 4
KEY TaxDeclnAmountType TaxDeclnAmountType 4
KEY TaxGroup TaxGroup 4
KEY TaxItem TaxItem 4
KEY TaxItemGrpgAcctgDocumentType TaxItemGrpgAcctgDocumentType 4
KEY TaxItemGrpgDebitCreditCode TaxItemGrpgDebitCreditCode 4
KEY TaxItemGrpgSpecialGLCode TaxItemGrpgSpecialGLCode 4
KEY TaxItemGrpgSupplierAcctGroup TaxItemGrpgSupplierAcctGroup 4
KEY TransactionTypeDetermination TransactionTypeDetermination 4
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 4
KEY ValidityStartDate ValidityStartDate 4
_TaxTypeText _TaxTypeText 2
AccountingDocumentHeaderText AccountingDocumentHeaderText 2
AmountInReportingCurrency AmountInReportingCurrency 4
CAReconciliationKey CAReconciliationKey 4
CompanyCodeCountry CompanyCodeCountry 4
CompanyCodeCurrency CompanyCodeCurrency 4
Country Country 4
DocumentCurrency DocumentCurrency 4
DocumentDate DocumentDate 4
DocumentReferenceID DocumentReferenceID 2
FinancialAccountType FinancialAccountType 2
FiscalPeriod FiscalPeriod 4
GLAccount GLAccount 4
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 4
PostingDate PostingDate 4
ReferenceDocumentType ReferenceDocumentType 4
ReportingCountry ReportingCountry 4
ReportingCurrency ReportingCurrency 4
ReportingDate ReportingDate 4
StatryRptRun StatryRptRun 4
TargetTaxCode TargetTaxCode 4
TaxAmount TaxAmount 4
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 4
TaxAmountInRptgCrcy TaxAmountInRptgCrcy 4
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 4
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy 4
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 4
TaxBoxCondition TaxBoxCondition 4
TaxBoxName TaxBoxName 4
TaxBoxStructure TaxBoxStructure 4
TaxBoxStructureName TaxBoxStructureName 4
TaxBoxStructureType TaxBoxStructureType 4
TaxIsNotDeductible TaxIsNotDeductible 4
TaxItemGroup TaxItemGroup 4
TaxItemGroupingVersion TaxItemGroupingVersion 4
TaxRate TaxRate 4
TaxRateValidityStartDate TaxRateValidityStartDate 4
TaxReportingDate TaxReportingDate 4
TaxReturnCountry TaxReturnCountry 4
TaxType TaxType 2
TaxTypeName TaxTypeName 4
ValidityEndDate ValidityEndDate 4

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.

-- Portugal Tax Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PT_TAXRETURNBOXITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    CADOCUMENTNUMBER,
    CAGLITEMNUMBER,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIERACCOUNTGROUP,
    TAXBOX,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGRPGACCTGDOCUMENTTYPE,
    TAXITEMGRPGDEBITCREDITCODE,
    TAXITEMGRPGSPECIALGLCODE,
    TAXITEMGRPGSUPPLIERACCTGROUP,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    VALIDITYSTARTDATE,
    _TAXTYPETEXT,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    AMOUNTINREPORTINGCURRENCY,
    CARECONCILIATIONKEY,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COUNTRY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    GLACCOUNT,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    STATRYRPTRUN,
    TARGETTAXCODE,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBOXCONDITION,
    TAXBOXNAME,
    TAXBOXSTRUCTURE,
    TAXBOXSTRUCTURENAME,
    TAXBOXSTRUCTURETYPE,
    TAXISNOTDEDUCTIBLE,
    TAXITEMGROUP,
    TAXITEMGROUPINGVERSION,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    TAXTYPENAME,
    VALIDITYENDDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, CADOCUMENTNUMBER, CAGLITEMNUMBER, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIERACCOUNTGROUP, TAXBOX, TAXCALCULATIONPROCEDURE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGRPGACCTGDOCUMENTTYPE, TAXITEMGRPGDEBITCREDITCODE, TAXITEMGRPGSPECIALGLCODE, TAXITEMGRPGSUPPLIERACCTGROUP, TRANSACTIONTYPEDETERMINATION, UNIFIEDTAXBOXSTRUCTURETYPE, VALIDITYSTARTDATE)
);

Learn More