GLO_JP_TAXOFFSET
Japan Tax Reallocation Offset Records
GLO_JP_TAXOFFSET is an SAP database table in S/4HANA. Japan Tax Reallocation Offset Records. It contains 17 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_JP_TaxReallocationOffsetBsc | view | from | BASIC | Japan Tax Reallocation Offset Baisc |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | uuid | GLO_JP_TAXOFFSETUUID | Offset UUID | |||
| puuid | GLO_JP_TAXREALOCUUID | Tx Reallocation UUID | ||||
| customerproject | /CPD/ENG_MP_ID | Engmnt Project ID | ||||
| salesorder | VBELN_VA | Sales Document | ||||
| salesorderitem | POSNR_VA | Item | ||||
| billingplan | FPLNR | Bill. Plan No. | ||||
| billingplanitem | FPLTR | Item | ||||
| accountingdocument | BELNR_D | Document Number | ||||
| companycode | BUKRS | Company Code | ||||
| fiscalyear | GJAHR | Fiscal Year | ||||
| offsetjournalentry | BELNR_D | Document Number | ||||
| postingfiscalyear | GJAHR | Fiscal Year | ||||
| created_by | USNAM | User Name | ||||
| changed_by | USNAM | User Name | ||||
| created_at | TZNTSTMPS | Time Stamp | ||||
| changed_at | TZNTSTMPS | Time Stamp |
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.
-- Japan Tax Reallocation Offset Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLO_JP_TAXOFFSET (
MANDT, -- Client [MANDT]
UUID, -- Offset UUID [GLO_JP_TAXOFFSETUUID]
PUUID, -- Tx Reallocation UUID [GLO_JP_TAXREALOCUUID]
CUSTOMERPROJECT, -- Engmnt Project ID [/CPD/ENG_MP_ID]
SALESORDER, -- Sales Document [VBELN_VA]
SALESORDERITEM, -- Item [POSNR_VA]
BILLINGPLAN, -- Bill. Plan No. [FPLNR]
BILLINGPLANITEM, -- Item [FPLTR]
ACCOUNTINGDOCUMENT, -- Document Number [BELNR_D]
COMPANYCODE, -- Company Code [BUKRS]
FISCALYEAR, -- Fiscal Year [GJAHR]
OFFSETJOURNALENTRY, -- Document Number [BELNR_D]
POSTINGFISCALYEAR, -- Fiscal Year [GJAHR]
CREATED_BY, -- User Name [USNAM]
CHANGED_BY, -- User Name [USNAM]
CREATED_AT, -- Time Stamp [TZNTSTMPS]
CHANGED_AT, -- Time Stamp [TZNTSTMPS]
PRIMARY KEY (MANDT, UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA