C_ID_StRpVATOutQuery

DDL: C_ID_STRPVATOUTQUERY SQL: CIDVATOUTQ Type: view CONSUMPTION
66 Fields 1 Data Sources

Indonesia VAT OUT CoreTax Query

C_ID_StRpVATOutQuery is a Consumption CDS View that provides data about "Indonesia VAT OUT CoreTax Query" in SAP S/4HANA. It reads from 1 data source (I_ID_StRpVATOutCube) and exposes 66 fields with key fields CompanyCode, BusinessPlace, FiscalYear, BillingDocument, BillingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_ID_StRpVATOutCube I_ID_StRpVATOutCube from

Parameters (12)

NameTypeDefault
P_CompanyCode fis_bukrs
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_TaxBoxConfiguration figen_tdt_taxbox_config
P_FromReportingDate vatdate
P_ToReportingDate vatdate
P_FromFiscalYear gjahr
P_ToFiscalYear gjahr
P_ConditionType kscha
P_BusinessPartner char10

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CIDVATOUTQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Analytics.query true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Indonesia VAT OUT CoreTax Query view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY BusinessPlace BusinessPlace Business place
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY BillingDocument BillingDocument Document Number
KEY BillingDocumentItem BillingDocumentItem Document Line Item Number
KEY AccountingDocument AccountingDocument Journal Entry
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate
KEY TaxBoxStructureType TaxBoxStructureType
KEY UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType Unified Tax Box Structure Type
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY TransactionTypeDetermination TransactionTypeDetermination Transaction Key
KEY TaxCode TaxCode Tax Code
TaxType TaxType Tax Type
TaxBox TaxBox Tax.Bs.Gp.No.
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate
DocumentCurrency DocumentCurrency Document Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxReportingDate TaxReportingDate Tax Reporting Date
PostingDate PostingDate Posting Date for GR
BusinessPartner BusinessPartner Issuing Authority
Customer Customer Sold-to Party
Supplier Supplier Supplier
ActiveCountry ActiveCountry Supply C/R
Material Material Vehicle Model
MaterialType MaterialType Material Type
GLAccount GLAccount General Ledger
CompanyCodeParameterValue CompanyCodeParameterValue Company Code
DocumentDate DocumentDate Journal Entry Date
TaxBoxCondition TaxBoxCondition
ID_ODNTypeTransactionCode ID_ODNTypeTransactionCode
ID_ODNTypeAddlInformationText ID_ODNTypeAddlInformationText
ID_ODNTypeCstmDocumentText ID_ODNTypeCstmDocumentText
ID_ODNTypeCstmDocMonthYearText ID_ODNTypeCstmDocMonthYearText
ID_ODNTypeFacilityStampText ID_ODNTypeFacilityStampText
SoldToPartyTaxNumber SoldToPartyTaxNumber Additional Tax Number
TaxNumber1 TaxNumber1 VAT Reg. No.
ContractOptionsBuyerSellerName ContractOptionsBuyerSellerName
CountryThreeLetterISOCode CountryThreeLetterISOCode
TaxNumber3 TaxNumber3
BusinessPartnerName BusinessPartnerName Extracted Customer Name
AddressLine1 AddressLine1
EmailAddress EmailAddress E-Mail Address
TaxNumber5 TaxNumber5
BOMHasHeaderInfoRecord BOMHasHeaderInfoRecord
ItemGroup ItemGroup
GLAccountName GLAccountName Short Text
UnitedStatesTaxCategoryName UnitedStatesTaxCategoryName
CostPricePerUnit CostPricePerUnit Unit Price in Transaction Currency
PerInvoicePrcUnitAmount PerInvoicePrcUnitAmount Unit Price in Company Code Currency
BillingQuantityUnit BillingQuantityUnit Sales Unit
BillingQuantity BillingQuantity Quantity
EligibleAmountForCashDiscount EligibleAmountForCashDiscount Total Discount
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy Total Discount in Company Code Currency
OriginalTaxBaseAmount OriginalTaxBaseAmount Tax Base in Transaction Currency
OriglTaxBaseAmountInCoCodeCrcy OriglTaxBaseAmountInCoCodeCrcy Tax Base in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Other Tax Base in Transaction Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy Other Tax Base in Company Code Currency
TaxRate TaxRate VAT Rate
TaxAmountInTransCrcy TaxAmountInTransCrcy VAT in Transaction Currency
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy VAT in Company Code Currency
LuxuryTaxRate LuxuryTaxRate Luxury Tax Rate
LuxuryTaxAmt LuxuryTaxAmt Luxury Tax in Transaction Currency
ID_LuxuryTaxAmtInCoCodeCrcy ID_LuxuryTaxAmtInCoCodeCrcy Luxury Tax in Company Code Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ID_StRpVATOutQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CIDVATOUTQ
-- Parameters: P_CompanyCode : fis_bukrs, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config, P_FromReportingDate : vatdate, P_ToReportingDate : vatdate, P_FromFiscalYear : gjahr, P_ToFiscalYear : gjahr, P_ConditionType : kscha, P_BusinessPartner : char10

CREATE VIEW C_ID_StRpVATOutQuery AS
SELECT
  CompanyCode,
  BusinessPlace,
  FiscalYear,
  BillingDocument,
  BillingDocumentItem,
  AccountingDocument,
  TaxBoxStrucValidityStartDate,
  TaxBoxStructureType,
  UnifiedTaxBoxStructureType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TransactionTypeDetermination,
  TaxCode,
  TaxType,
  TaxBox,
  TaxRateValidityStartDate,
  TaxBoxStrucValidityEndDate,
  DocumentCurrency,
  CompanyCodeCurrency,
  TaxReportingDate,
  PostingDate,
  BusinessPartner,
  Customer,
  Supplier,
  ActiveCountry,
  Material,
  MaterialType,
  GLAccount,
  CompanyCodeParameterValue,
  DocumentDate,
  TaxBoxCondition,
  ID_ODNTypeTransactionCode,
  ID_ODNTypeAddlInformationText,
  ID_ODNTypeCstmDocumentText,
  ID_ODNTypeCstmDocMonthYearText,
  ID_ODNTypeFacilityStampText,
  SoldToPartyTaxNumber,
  TaxNumber1,
  ContractOptionsBuyerSellerName,
  CountryThreeLetterISOCode,
  TaxNumber3,
  BusinessPartnerName,
  AddressLine1,
  EmailAddress,
  TaxNumber5,
  BOMHasHeaderInfoRecord,
  ItemGroup,
  GLAccountName,
  UnitedStatesTaxCategoryName,
  CostPricePerUnit,
  PerInvoicePrcUnitAmount,
  BillingQuantityUnit,
  BillingQuantity,
  EligibleAmountForCashDiscount,
  CashDiscountAmtInCoCodeCrcy,
  OriginalTaxBaseAmount,
  OriglTaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxRate,
  TaxAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  LuxuryTaxRate,
  LuxuryTaxAmt,
  ID_LuxuryTaxAmtInCoCodeCrcy
FROM I_ID_StRpVATOutCube
;

Learn More