I_JP_TaxReallocationOffsetBsc

DDL: I_JP_TAXREALLOCATIONOFFSETBSC Type: view BASIC
16 Fields 1 Data Sources

Japan Tax Reallocation Offset Baisc

I_JP_TaxReallocationOffsetBsc is a Basic CDS View that provides data about "Japan Tax Reallocation Offset Baisc" in SAP S/4HANA. It reads from 1 data source (glo_jp_taxoffset) and exposes 16 fields with key field JP_TaxOffsetUUID.

Data Sources (1)

SourceAliasJoin Type
glo_jp_taxoffset glo_jp_taxoffset from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IJPTAXOFFSETBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey JP_TaxOffsetUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Japan Tax Reallocation Offset Baisc view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY JP_TaxOffsetUUID uuid Waste Partner UUID
JP_TaxReallocateUUID puuid Tx Reallocation UUID
CustomerProject customerproject Engmnt Project ID
SalesOrder salesorder SD Document
SalesOrderItem salesorderitem Sales Order Item
BillingPlan billingplan Bill. Plan No.
BillingPlanItem billingplanitem Item
AccountingDocument accountingdocument Journal Entry
CompanyCode companycode Receiver Company Code
FiscalYear fiscalyear G/L Fiscal Year
JP_TaxOffSetJournalEntry offsetjournalentry Document Number
PostingFiscalYear postingfiscalyear Fiscal Year
CreatedByUser created_by Version Created By
CreationDateTime created_at Uploaded On
LastChangedByUser changed_by User Name
ChangedDateTime changed_at Timestamp

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 I_JP_TaxReallocationOffsetBsc.
-- 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.

CREATE VIEW I_JP_TaxReallocationOffsetBsc AS
SELECT
  uuid AS JP_TaxOffsetUUID,
  puuid AS JP_TaxReallocateUUID,
  CustomerProject,
  SalesOrder,
  SalesOrderItem,
  BillingPlan,
  BillingPlanItem,
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  offsetjournalentry AS JP_TaxOffSetJournalEntry,
  PostingFiscalYear,
  created_by AS CreatedByUser,
  created_at AS CreationDateTime,
  changed_by AS LastChangedByUser,
  changed_at AS ChangedDateTime
FROM glo_jp_taxoffset
;

Learn More