J3RF_VATCRQ8

Transparent Table Application Table
35 Fields 1 CDS Views

Section 8 (Purchase book)

J3RF_VATCRQ8 is an SAP database table in S/4HANA. Section 8 (Purchase book). It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_VATCRQSEC8 view from BASIC

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY n1 J_3RF_VATCRQ_N1 Request ID
KEY gjahr GJAHR Fiscal Year
KEY period J_3RVATDQMPERIOD Tax Period
KEY corr_num J_3RVATDCORRNUM Corr.VAT Ret.Number
KEY num_line J_3RF_VATCRQ_NUMLINE Line Item Number
KEY flag_add FLAG Indicator
bukrs BUKRS Company Code
gjahr_inv GJAHR Fiscal Year
belnr_inv BELNR_D Document Number
gjahr_trn GJAHR Fiscal Year
belnr_trn BELNR_D Document Number
gjahr_pay GJAHR Fiscal Year
belnr_pay BELNR_D Document Number
ext_number J_3RF_EXT_NUMBER Ext.Doc.Number
bldat_orig_inv J_3RFINV_ORIGD Orig. VAT Inv. Date
bldat_corr_inv J_3RFINV_CORRD Corr. VAT Inv. Date
ext_number_corr J_3RFINV_CORRE Corr. VAT Inv. Ext.
belnr_orig_rev J_3RFINV_REVNO Revision Number
bldat_orig_rev J_3RFINV_REVD Revision Date
number_corr_rev J_3RFINV_REVNO_CORR Revision of Corr. No
bldat_corr_rev J_3RFINV_CORR_REVD Rev. Date of Corr.
waers WAERS Currency
wrbtr_wrs_pay J_3RF_VATCRQ_CURRKEY Currency Key (OKV)
wrbtr_pay J_3RF_VATCRQ_WRBTR Amount Including VAT
hwste_pay J_3RF_VATCRQ_HWSTE Tax Amount
hwste_wrs_pay J_3RF_VATCRQ_CURRKEY Currency Key (OKV)
err_code J_3RF_VATCRQ_ERR_CODE VAT Return Error
pay_ext_number J_3RF_BK_PAYMENT Payment Num and Date
pay_ext_bldat BLDAT Document Date
mm_inv_budat J_3RF_DE_RDAT GR Date
vendor LIFNR Supplier
vendor_name AD_NAME1 Name
tech_mm_inv_vornu INT4 INT4
mm_inv_vornu CHAR0256 Charact.string (256)

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.

-- Section 8 (Purchase book)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J3RF_VATCRQ8 (
    MANDT,              -- Client [MANDT]
    N1,                 -- Request ID [J_3RF_VATCRQ_N1]
    GJAHR,              -- Fiscal Year [GJAHR]
    PERIOD,             -- Tax Period [J_3RVATDQMPERIOD]
    CORR_NUM,           -- Corr.VAT Ret.Number [J_3RVATDCORRNUM]
    NUM_LINE,           -- Line Item Number [J_3RF_VATCRQ_NUMLINE]
    FLAG_ADD,           -- Indicator [FLAG]
    BUKRS,              -- Company Code [BUKRS]
    GJAHR_INV,          -- Fiscal Year [GJAHR]
    BELNR_INV,          -- Document Number [BELNR_D]
    GJAHR_TRN,          -- Fiscal Year [GJAHR]
    BELNR_TRN,          -- Document Number [BELNR_D]
    GJAHR_PAY,          -- Fiscal Year [GJAHR]
    BELNR_PAY,          -- Document Number [BELNR_D]
    EXT_NUMBER,         -- Ext.Doc.Number [J_3RF_EXT_NUMBER]
    BLDAT_ORIG_INV,     -- Orig. VAT Inv. Date [J_3RFINV_ORIGD]
    BLDAT_CORR_INV,     -- Corr. VAT Inv. Date [J_3RFINV_CORRD]
    EXT_NUMBER_CORR,    -- Corr. VAT Inv. Ext. [J_3RFINV_CORRE]
    BELNR_ORIG_REV,     -- Revision Number [J_3RFINV_REVNO]
    BLDAT_ORIG_REV,     -- Revision Date [J_3RFINV_REVD]
    NUMBER_CORR_REV,    -- Revision of Corr. No [J_3RFINV_REVNO_CORR]
    BLDAT_CORR_REV,     -- Rev. Date of Corr. [J_3RFINV_CORR_REVD]
    WAERS,              -- Currency [WAERS]
    WRBTR_WRS_PAY,      -- Currency Key (OKV) [J_3RF_VATCRQ_CURRKEY]
    WRBTR_PAY,          -- Amount Including VAT [J_3RF_VATCRQ_WRBTR]
    HWSTE_PAY,          -- Tax Amount [J_3RF_VATCRQ_HWSTE]
    HWSTE_WRS_PAY,      -- Currency Key (OKV) [J_3RF_VATCRQ_CURRKEY]
    ERR_CODE,           -- VAT Return Error [J_3RF_VATCRQ_ERR_CODE]
    PAY_EXT_NUMBER,     -- Payment Num and Date [J_3RF_BK_PAYMENT]
    PAY_EXT_BLDAT,      -- Document Date [BLDAT]
    MM_INV_BUDAT,       -- GR Date [J_3RF_DE_RDAT]
    VENDOR,             -- Supplier [LIFNR]
    VENDOR_NAME,        -- Name [AD_NAME1]
    TECH_MM_INV_VORNU,  -- INT4 [INT4]
    MM_INV_VORNU,       -- Charact.string (256) [CHAR0256]
    PRIMARY KEY (MANDT, N1, GJAHR, PERIOD, CORR_NUM, NUM_LINE, FLAG_ADD)
);

Learn More