GLO_JP_TAXOFFSET

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
I_JP_TaxReallocationOffsetBsc view from BASIC Japan Tax Reallocation Offset Baisc

Fields (17)

KeyField Data ElementDescription DomainTypeLength
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)
);