I_JNTOPGAGRMT

CDS View

Joint Operating Agreement

I_JNTOPGAGRMT is a CDS View in S/4HANA. Joint Operating Agreement. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_JntOpgAgrmtDetail view from COMPOSITE Object Page for Joint Operating Agrmt
I_JVAJointOperatingAgrmtDetail view from COMPOSITE JVA and cost object MD information
R_JntOpgAgrmtTP view_entity from TRANSACTIONAL Joint Operating Agreement - TP

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY JntOpgAgrmt JntOpgAgrmt 1
JntOpgAgrmtClass JntOpgAgrmtClass 1
JntOpgAgrmtDrillingPayRate JntOpgAgrmtDrillingPayRate 1
JntOpgAgrmtNonDrillingPayRate JntOpgAgrmtNonDrillingPayRate 1
JntOpgAgrmtProdgWellThld JntOpgAgrmtProdgWellThld 1
JntVntrCapitalExclsnSet JntVntrCapitalExclsnSet 1
JntVntrCatastropheExclsnSet JntVntrCatastropheExclsnSet 1
JntVntrCatastropheOvhdRule JntVntrCatastropheOvhdRule 1
JntVntrConstructionExclsnSet JntVntrConstructionExclsnSet 1
JntVntrConstructionOvhdRule JntVntrConstructionOvhdRule 1
JntVntrContractNmbr JntVntrContractNmbr 1
JntVntrDrillingOvhdRule JntVntrDrillingOvhdRule 1
JntVntrExplorationOvhdRule JntVntrExplorationOvhdRule 1
JntVntrExpnIsEscalated JntVntrExpnIsEscalated 1
JntVntrOvhdFlatRateAmt JntVntrOvhdFlatRateAmt 1
JntVntrOvhdOffsetCostCtr JntVntrOvhdOffsetCostCtr 1
JntVntrOvhdRecurringDoc JntVntrOvhdRecurringDoc 1
JntVntrPayrollClearingSet JntVntrPayrollClearingSet 1
JVAExclsnAcctSetPercentDev JVAExclsnAcctSetPercentDev 1
JVAExclsnAcctSetPercentProdg JVAExclsnAcctSetPercentProdg 1
JVAOvhdPercentDev JVAOvhdPercentDev 1
JVAOvhdPercentProdg JVAOvhdPercentProdg 1

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.

-- Joint Operating Agreement
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JNTOPGAGRMT (
    COMPANYCODE,
    JNTOPGAGRMT,
    JNTOPGAGRMTCLASS,
    JNTOPGAGRMTDRILLINGPAYRATE,
    JNTOPGAGRMTNONDRILLINGPAYRATE,
    JNTOPGAGRMTPRODGWELLTHLD,
    JNTVNTRCAPITALEXCLSNSET,
    JNTVNTRCATASTROPHEEXCLSNSET,
    JNTVNTRCATASTROPHEOVHDRULE,
    JNTVNTRCONSTRUCTIONEXCLSNSET,
    JNTVNTRCONSTRUCTIONOVHDRULE,
    JNTVNTRCONTRACTNMBR,
    JNTVNTRDRILLINGOVHDRULE,
    JNTVNTREXPLORATIONOVHDRULE,
    JNTVNTREXPNISESCALATED,
    JNTVNTROVHDFLATRATEAMT,
    JNTVNTROVHDOFFSETCOSTCTR,
    JNTVNTROVHDRECURRINGDOC,
    JNTVNTRPAYROLLCLEARINGSET,
    JVAEXCLSNACCTSETPERCENTDEV,
    JVAEXCLSNACCTSETPERCENTPRODG,
    JVAOVHDPERCENTDEV,
    JVAOVHDPERCENTPRODG,
    PRIMARY KEY (COMPANYCODE, JNTOPGAGRMT)
);