OIUX3_TX_LEASE

Transparent Table Application Table
8 Fields 1 CDS Views

Tax Reporting - Texas Lease

OIUX3_TX_LEASE is an SAP database table in S/4HANA. Tax Reporting - Texas Lease. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRATaxTXLease view from BASIC PRA Tax Texas Lease

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lease_number OIUX3_TX_LEASE_NUMBER Lease No.
lease_name OIUX3_TX_LEASE_NAME Lease Name
lease_type OIUX3_TX_LEASE_TYPE Lease Type
drill_permit OIUX3_TX_DRILL_PERMIT Drill Permit
change_user OIUX3_LAST_CHANGED_USER Last Changed By
change_date OIUX3_LAST_CHANGED_DATE Last Chngd On
change_time OIUX3_LAST_CHANGED_TIME Last Chngd At

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.

-- Tax Reporting - Texas Lease
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUX3_TX_LEASE (
    MANDT,         -- Client [MANDT]
    LEASE_NUMBER,  -- Lease No. [OIUX3_TX_LEASE_NUMBER]
    LEASE_NAME,    -- Lease Name [OIUX3_TX_LEASE_NAME]
    LEASE_TYPE,    -- Lease Type [OIUX3_TX_LEASE_TYPE]
    DRILL_PERMIT,  -- Drill Permit [OIUX3_TX_DRILL_PERMIT]
    CHANGE_USER,   -- Last Changed By [OIUX3_LAST_CHANGED_USER]
    CHANGE_DATE,   -- Last Chngd On [OIUX3_LAST_CHANGED_DATE]
    CHANGE_TIME,   -- Last Chngd At [OIUX3_LAST_CHANGED_TIME]
    PRIMARY KEY (MANDT, LEASE_NUMBER)
);

Learn More