P_STRPTAXRETURNITEM

52 Fields 1 CDS Views

P_STRPTAXRETURNITEM is an SAP database table in S/4HANA. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_StRpTaxReturnCube view from COMPOSITE

Fields (52)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AccountingDocumentType AccountingDocumentType 1
KEY CompanyCode CompanyCode 3
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalYear FiscalYear 3
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY SupplierAccountGroup SupplierAccountGroup 1
KEY TaxCode TaxCode 3
KEY TaxItem TaxItem 3
KEY TransactionTypeDetermination TransactionTypeDetermination 3
_AccountingDocument _AccountingDocument 1
_CompanyCodeCountry _CompanyCodeCountry 1
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem 1
_GLAccount _GLAccount 1
_JournalEntry _JournalEntry 1
_OneTimeAccountBP _OneTimeAccountBP 1
_ReceivablesPayablesItem _ReceivablesPayablesItem 1
_ReportedItemsLog _ReportedItemsLog 1
_ReportingCurrency _ReportingCurrency 1
_TaxCode _TaxCode 1
_TaxCodeText _TaxCodeText 1
_TaxJurisdiction _TaxJurisdiction 1
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem 1
_TaxTypeText _TaxTypeText 1
AdditionalTax1Rate AdditionalTax1Rate 1
BalanceAmountInTransacCurrency BalanceAmountInTransacCurrency 1
BusinessPartnerCountry BusinessPartnerCountry 1
BusinessPartnerName BusinessPartnerName 1
CAReconciliationKey CAReconciliationKey 1
ConditionAmount ConditionAmount 1
ConditionType ConditionType 1
Customer Customer 1
CustomerSupplierAddress CustomerSupplierAddress 1
DcblVATIncrdCostInRptgCrcy DcblVATIncrdCostInRptgCrcy 1
IPITaxRate IPITaxRate 1
IsNegativePosting IsNegativePosting 1
ParameterReportingCountry ParameterReportingCountry 1
StatryRptRun StatryRptRun 1
TargetTaxCode TargetTaxCode 3
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 1
TaxCalculationProcedure TaxCalculationProcedure 3
TaxCntryOrCompanyCodeCntry TaxCntryOrCompanyCodeCntry 1
TaxCountry TaxCountry 1
TaxIsNotDeductible TaxIsNotDeductible 1
TaxRate TaxRate 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxReturnCountry TaxReturnCountry 2
TaxType TaxType 1
TaxTypeName TaxTypeName 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_STRPTAXRETURNITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIERACCOUNTGROUP,
    TAXCODE,
    TAXITEM,
    TRANSACTIONTYPEDETERMINATION,
    _ACCOUNTINGDOCUMENT,
    _COMPANYCODECOUNTRY,
    _DEBTORCREDITORRBLSPYBLSITEM,
    _GLACCOUNT,
    _JOURNALENTRY,
    _ONETIMEACCOUNTBP,
    _RECEIVABLESPAYABLESITEM,
    _REPORTEDITEMSLOG,
    _REPORTINGCURRENCY,
    _TAXCODE,
    _TAXCODETEXT,
    _TAXJURISDICTION,
    _TAXRECEIVABLESPAYABLESITEM,
    _TAXTYPETEXT,
    ADDITIONALTAX1RATE,
    BALANCEAMOUNTINTRANSACCURRENCY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    CARECONCILIATIONKEY,
    CONDITIONAMOUNT,
    CONDITIONTYPE,
    CUSTOMER,
    CUSTOMERSUPPLIERADDRESS,
    DCBLVATINCRDCOSTINRPTGCRCY,
    IPITAXRATE,
    ISNEGATIVEPOSTING,
    PARAMETERREPORTINGCOUNTRY,
    STATRYRPTRUN,
    TARGETTAXCODE,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCALCULATIONPROCEDURE,
    TAXCNTRYORCOMPANYCODECNTRY,
    TAXCOUNTRY,
    TAXISNOTDEDUCTIBLE,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXRETURNCOUNTRY,
    TAXTYPE,
    TAXTYPENAME,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIERACCOUNTGROUP, TAXCODE, TAXITEM, TRANSACTIONTYPEDETERMINATION)
);

Learn More