JVA_JOA_CREATE - For Ecatt /SMB99/JVA_JOA_MASTER_GJAA

For Ecatt /SMB99/JVA_JOA_MASTER_GJAA information is stored in SAP table JVA_JOA_CREATE.
It is part of development package GJVA in software component CA-JVA. This development package consists of objects that can be grouped under "".

Fields for table JVA_JOA_CREATE

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
I_MANDTClientXMANDTCLNT6
I_BUKRSCompany CodeXBUKRSCHAR8
I_JOAJoint Operating AgreementXJV_JOACHAR12
I_ACLASSJoint Operating Agreement ClassJV_ACLASSCHAR4
I_CONTRACTJV Contract NumberJV_CONTRACCHAR48
I_SPRAS1JOA DescriptionLTEXT_8JUCHAR80
I_JTEXT_1User who CreatedJV_CRUSERCHAR24
I_CRUSERTime CreatedJV_CRTIMECHAR16
I_CRTIMEDate CreatedJV_CRDATEDATS16
I_CRDATEUser who Last ChangedJV_CHUSERCHAR24
I_CHUSERTime Last ChangedJV_CHTIMECHAR16
I_CHTIMEDate Last ChangedJV_CHDATEDATS16
I_CHDATELanguage KeySPRASLANG2
I_AEGROUP1Equity Group - JOA levelJV_AEGROUPCHAR6
I_AEGROUP2Equity Group - JOA levelJV_AEGROUPCHAR6
I_AEGROUP3Equity Group - JOA levelJV_AEGROUPCHAR6
I_OPSHARE1Operated ShareJV_OPSHAREDEC5
I_OPSHARE2Operated ShareJV_OPSHAREDEC5
I_OPSHARE3Operated ShareJV_OPSHAREDEC5
I_NOPSHARE1Non-Operated ShareJV_NOSHAREDEC5
I_NOPSHARE2Non-Operated ShareJV_NOSHAREDEC5
I_NOPSHARE3Non-Operated ShareJV_NOSHAREDEC5
I_EGROUPSUS1Equity Group SuspendedJV_EGPSUSCHAR2
I_EGROUPSUS2Equity Group SuspendedJV_EGPSUSCHAR2
I_EGROUPSUS3Equity Group SuspendedJV_EGPSUSCHAR2
I_GRPSUSPER1Equity Group Suspended PeriodJV_GSUSPERNUMC6
I_GRPSUSPER2Equity Group Suspended PeriodJV_GSUSPERNUMC6
I_GRPSUSPER3Equity Group Suspended PeriodJV_GSUSPERNUMC6
I_GRPSUSYEAR1JV Group Suspense YearJV_GSUSYRNUMC8
I_GRPSUSYEAR2JV Group Suspense YearJV_GSUSYRNUMC8
I_GRPSUSYEAR3JV Group Suspense YearJV_GSUSYRNUMC8
I_EGROUPUSUS1JV Equity Group UnsuspensedJV_EGPUSUSCHAR2
I_EGROUPUSUS2JV Equity Group UnsuspensedJV_EGPUSUSCHAR2
I_EGROUPUSUS3JV Equity Group UnsuspensedJV_EGPUSUSCHAR2
I_GRPUSUSPER1JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_GRPUSUSPER2JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_GRPUSUSPER3JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_GRPUSUSYER1JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_GRPUSUSYER2JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_GRPUSUSYER3JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_VTYPE1Venture TypeJV_VTYPECHAR2
I_VTYPE2Venture TypeJV_VTYPECHAR2
I_VTYPE3Venture TypeJV_VTYPECHAR2
I_EGTXT1Equity Group Description - JOA levelLTEXT_8J9ACHAR70
I_EGTXT2Equity Group Description - JOA levelLTEXT_8J9ACHAR70
I_EGTXT3Equity Group Description - JOA levelLTEXT_8J9ACHAR70
I_PARTN1_AEGROUP1JV partnerJV_PARTNCHAR20
I_PARTN2_AEGROUP1JV partnerJV_PARTNCHAR20
I_PARTN3_AEGROUP1JV partnerJV_PARTNCHAR20
I_PARTNER_NM1_AEGROUP1Name of the joint venture partnerJV_PART_NMCHAR70
I_PARTNER_NM2_AEGROUP1Name of the joint venture partnerJV_PART_NMCHAR70
I_PARTNER_NM3_AEGROUP1Name of the joint venture partnerJV_PART_NMCHAR70
I_EQSHARE1_AEGROUP1Equity ShareJV_ESHAREDEC5
I_EQSHARE2_AEGROUP1Equity ShareJV_ESHAREDEC5
I_EQSHARE3_AEGROUP1Equity ShareJV_ESHAREDEC5
I_STOPPAY1_AEGROUP1JV Stop/PayJV_STOPPAYCHAR2
I_STOPPAY2_AEGROUP1JV Stop/PayJV_STOPPAYCHAR2
I_STOPPAY3_AEGROUP1JV Stop/PayJV_STOPPAYCHAR2
I_OWNSUSP1_AEGROUP1Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSP2_AEGROUP1Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSP3_AEGROUP1Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSPER1_AEGROUP1JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSPER2_AEGROUP1JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSPER3_AEGROUP1JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSYEAR1_AEGROUP1JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNSUSYEAR2_AEGROUP1JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNSUSYEAR3_AEGROUP1JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNUNSUS1_AEGROUP1JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUNSUS2_AEGROUP1JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUNSUS3_AEGROUP1JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUSUSPER1_AEGROUP1JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSPER2_AEGROUP1JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSPER3_AEGROUP1JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSYR1_AEGROUP1JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_OWNUSUSYR2_AEGROUP1JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_OWNUSUSYR3_AEGROUP1JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_REGIO1_AEGROUP1Operator address by areaJV_REGIOCHAR8
I_REGIO2_AEGROUP1Operator address by areaJV_REGIOCHAR8
I_REGIO3_AEGROUP1Operator address by areaJV_REGIOCHAR8
I_PARTN1_AEGROUP2JV partnerJV_PARTNCHAR20
I_PARTN2_AEGROUP2JV partnerJV_PARTNCHAR20
I_PARTN3_AEGROUP2JV partnerJV_PARTNCHAR20
I_PARTNER_NM1_AEGROUP2Name of the joint venture partnerJV_PART_NMCHAR70
I_PARTNER_NM2_AEGROUP2Name of the joint venture partnerJV_PART_NMCHAR70
I_PARTNER_NM3_AEGROUP2Name of the joint venture partnerJV_PART_NMCHAR70
I_EQSHARE1_AEGROUP2Equity ShareJV_ESHAREDEC5
I_EQSHARE2_AEGROUP2Equity ShareJV_ESHAREDEC5
I_EQSHARE3_AEGROUP2Equity ShareJV_ESHAREDEC5
I_STOPPAY1_AEGROUP2JV Stop/PayJV_STOPPAYCHAR2
I_STOPPAY2_AEGROUP2JV Stop/PayJV_STOPPAYCHAR2
I_STOPPAY3_AEGROUP2JV Stop/PayJV_STOPPAYCHAR2
I_OWNSUSP1_AEGROUP2Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSP2_AEGROUP2Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSP3_AEGROUP2Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSPER1_AEGROUP2JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSPER2_AEGROUP2JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSPER3_AEGROUP2JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSYEAR1_AEGROUP2JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNSUSYEAR2_AEGROUP2JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNSUSYEAR3_AEGROUP2JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNUNSUS1_AEGROUP2JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUNSUS2_AEGROUP2JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUNSUS3_AEGROUP2JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUSUSPER1_AEGROUP2JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSPER2_AEGROUP2JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSPER3_AEGROUP2JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSYR1_AEGROUP2JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_OWNUSUSYR2_AEGROUP2JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_OWNUSUSYR3_AEGROUP2JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_REGIO1_AEGROUP2Operator address by areaJV_REGIOCHAR8
I_REGIO2_AEGROUP2Operator address by areaJV_REGIOCHAR8
I_REGIO3_AEGROUP2Operator address by areaJV_REGIOCHAR8
I_PARTN1_AEGROUP3JV partnerJV_PARTNCHAR20
I_PARTN2_AEGROUP3JV partnerJV_PARTNCHAR20
I_PARTN3_AEGROUP3JV partnerJV_PARTNCHAR20
I_PARTNER_NM1_AEGROUP3Name of the joint venture partnerJV_PART_NMCHAR70
I_PARTNER_NM2_AEGROUP3Name of the joint venture partnerJV_PART_NMCHAR70
I_PARTNER_NM3_AEGROUP3Name of the joint venture partnerJV_PART_NMCHAR70
I_EQSHARE1_AEGROUP3Equity ShareJV_ESHAREDEC5
I_EQSHARE2_AEGROUP3Equity ShareJV_ESHAREDEC5
I_EQSHARE3_AEGROUP3Equity ShareJV_ESHAREDEC5
I_STOPPAY1_AEGROUP3JV Stop/PayJV_STOPPAYCHAR2
I_STOPPAY2_AEGROUP3JV Stop/PayJV_STOPPAYCHAR2
I_STOPPAY3_AEGROUP3JV Stop/PayJV_STOPPAYCHAR2
I_OWNSUSP1_AEGROUP3Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSP2_AEGROUP3Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSP3_AEGROUP3Owner Suspensed FlagJV_OWNSUSPCHAR2
I_OWNSUSPER1_AEGROUP3JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSPER2_AEGROUP3JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSPER3_AEGROUP3JV Owner SuspensedJV_OSUSPERNUMC6
I_OWNSUSYEAR1_AEGROUP3JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNSUSYEAR2_AEGROUP3JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNSUSYEAR3_AEGROUP3JV Owner Suspensed YearJV_OSUSYRNUMC8
I_OWNUNSUS1_AEGROUP3JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUNSUS2_AEGROUP3JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUNSUS3_AEGROUP3JV Owner UnsuspensedJV_OWNUSPCHAR2
I_OWNUSUSPER1_AEGROUP3JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSPER2_AEGROUP3JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSPER3_AEGROUP3JV Group Unsuspensed PeriodJV_GUSUSPNUMC6
I_OWNUSUSYR1_AEGROUP3JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_OWNUSUSYR2_AEGROUP3JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_OWNUSUSYR3_AEGROUP3JV Group Unsuspensed YearJV_GUSUSYRNUMC8
I_REGIO1_AEGROUP3Operator address by areaJV_REGIOCHAR8
I_REGIO2_AEGROUP3Operator address by areaJV_REGIOCHAR8
I_REGIO3_AEGROUP3Operator address by areaJV_REGIOCHAR8
I_CONRULEConstruction Overhead RuleJV_CONRULECHAR12
I_XSETCONSet of Accounts to Exclude from Construction Overhead Calc.JV_XSETCONCHAR48
I_XSETCATSet of Accounts to Exclude from Catastrophe Overhead Calc.JV_XSETCATCHAR48
I_CATRULECatastrophe Overhead RuleJV_CATRULECHAR12
I_ALLWBSCalculate all WBS elements for overheadJV_ALLWBSCHAR2
I_SEQNUM1JV Sequence NumberJV_SEQCHAR4
I_SEQNUM2JV Sequence NumberJV_SEQCHAR4
I_SEQNUM3JV Sequence NumberJV_SEQCHAR4
I_PROJ1Work Breakdown Structure Element (WBS Element)PS_POSIDCHAR48
I_PROJ2Work Breakdown Structure Element (WBS Element)PS_POSIDCHAR48
I_PROJ3Work Breakdown Structure Element (WBS Element)PS_POSIDCHAR48
I_STEPTYP1Type of Stepped Rate Overhead to Apply to ProjectJV_STEPTYPCHAR4
I_STEPTYP2Type of Stepped Rate Overhead to Apply to ProjectJV_STEPTYPCHAR4
I_STEPTYP3Type of Stepped Rate Overhead to Apply to ProjectJV_STEPTYPCHAR4
I_XSET1Override Set of Accounts to Exclude from Overhead Calc.JV_XSETOVRCHAR48
I_XSET2Override Set of Accounts to Exclude from Overhead Calc.JV_XSETOVRCHAR48
I_XSET3Override Set of Accounts to Exclude from Overhead Calc.JV_XSETOVRCHAR48
I_OVRPER1Override Percentage for Stepped Rate OverheadJV_OVRPERDEC3
I_OVRPER2Override Percentage for Stepped Rate OverheadJV_OVRPERDEC3
I_OVRPER3Override Percentage for Stepped Rate OverheadJV_OVRPERDEC3
I_OVRRULE1Override Stepped Rate Overhead Rule (JVA)JV_OVRRULCHAR12
I_OVRRULE2Override Stepped Rate Overhead Rule (JVA)JV_OVRRULCHAR12
I_OVRRULE3Override Stepped Rate Overhead Rule (JVA)JV_OVRRULCHAR12
I_XWBSFLAG1A flag to exclude the specified WBS elementJV_XWBSCHAR2
I_XWBSFLAG2A flag to exclude the specified WBS elementJV_XWBSCHAR2
I_XWBSFLAG3A flag to exclude the specified WBS elementJV_XWBSCHAR2
I_PER1Percent 1 (% Producing U.S., % Regular Canada) (JVA)JV_PER1DEC3
I_XPER1Exclusion Set of Accounts - Percent 1 (JVA)JV_XPER1CHAR48
I_PER2Percent 2 (% Development U.S., % Special Canada) (JVA)JV_PER2DEC3
I_XPER2Exclusion Set of Accounts - Percent 2 (JVA)JV_XPER2CHAR48
I_JOAPRTHPerform Producing Well Threshold Calculation at JOA LevelJV_JOAPRTHCHAR2
I_PRSTAT1Producing Statistical Ratio (JVA)JV_PRSTATCHAR12
I_PRSTAT2Producing Statistical Ratio (JVA)JV_PRSTATCHAR12
I_PRSTAT3Producing Statistical Ratio (JVA)JV_PRSTATCHAR12
I_FRDEPTH1From Depth (JVA)JV_FRDEPTHDEC5
I_FRDEPTH2From Depth (JVA)JV_FRDEPTHDEC5
I_FRDEPTH3From Depth (JVA)JV_FRDEPTHDEC5
I_TODEPTH1To Depth, CFR Overhead (JVA)JV_TODEPTHDEC5
I_TODEPTH2To Depth, CFR Overhead (JVA)JV_TODEPTHDEC5
I_TODEPTH3To Depth, CFR Overhead (JVA)JV_TODEPTHDEC5
I_SNUM1_PRSTAT1JV Sequence NumberJV_SEQNUMNUMC4
I_SNUM2_PRSTAT1JV Sequence NumberJV_SEQNUMNUMC4
I_SNUM3_PRSTAT1JV Sequence NumberJV_SEQNUMNUMC4
I_THRESHOLD1_PRSTAT1Threshold Number of WellsJV_THRESHWNUMC10
I_THRESHOLD2_PRSTAT1Threshold Number of WellsJV_THRESHWNUMC10
I_THRESHOLD3_PRSTAT1Threshold Number of WellsJV_THRESHWNUMC10
I_RATE1_PRSTAT1Rate per Producing Well (JVA)JV_PRRATECURR7
I_RATE2_PRSTAT1Rate per Producing Well (JVA)JV_PRRATECURR7
I_RATE3_PRSTAT1Rate per Producing Well (JVA)JV_PRRATECURR7
I_SNUM1_PRSTAT2JV Sequence NumberJV_SEQNUMNUMC4
I_SNUM2_PRSTAT2JV Sequence NumberJV_SEQNUMNUMC4
I_SNUM3_PRSTAT2JV Sequence NumberJV_SEQNUMNUMC4
I_THRESHOLD1_PRSTAT2Threshold Number of WellsJV_THRESHWNUMC10
I_THRESHOLD2_PRSTAT2Threshold Number of WellsJV_THRESHWNUMC10
I_THRESHOLD3_PRSTAT2Threshold Number of WellsJV_THRESHWNUMC10
I_RATE1_PRSTAT2Rate per Producing Well (JVA)JV_PRRATECURR7
I_RATE2_PRSTAT2Rate per Producing Well (JVA)JV_PRRATECURR7
I_RATE3_PRSTAT2Rate per Producing Well (JVA)JV_PRRATECURR7
I_SNUM1_PRSTAT3JV Sequence NumberJV_SEQNUMNUMC4
I_SNUM2_PRSTAT3JV Sequence NumberJV_SEQNUMNUMC4
I_SNUM3_PRSTAT3JV Sequence NumberJV_SEQNUMNUMC4
I_THRESHOLD1_PRSTAT3Threshold Number of WellsJV_THRESHWNUMC10
I_THRESHOLD2_PRSTAT3Threshold Number of WellsJV_THRESHWNUMC10
I_THRESHOLD3_PRSTAT3Threshold Number of WellsJV_THRESHWNUMC10
I_RATE1_PRSTAT3Rate per Producing Well (JVA)JV_PRRATECURR7
I_RATE2_PRSTAT3Rate per Producing Well (JVA)JV_PRRATECURR7
I_RATE3_PRSTAT3Rate per Producing Well (JVA)JV_PRRATECURR7
I_DRILLPCalculate Drilling Days using prior period.JV_DRILLPCHAR2
I_DRSTAT1Drilling Statistical Ratio (Joint Venture Accounting)JV_DRSTATCHAR12
I_DRSTAT2Drilling Statistical Ratio (Joint Venture Accounting)JV_DRSTATCHAR12
I_DRSTAT3Drilling Statistical Ratio (Joint Venture Accounting)JV_DRSTATCHAR12
I_MONTHLY1Monthly Rate, CFR Drilling Overhead (JVA)JV_MONTRATCHAR2
I_MONTHLY2Monthly Rate, CFR Drilling Overhead (JVA)JV_MONTRATCHAR2
I_MONTHLY3Monthly Rate, CFR Drilling Overhead (JVA)JV_MONTRATCHAR2
I_ESCALEscalatableJV_ESCALCHAR2
I_OFFCCOverhead Offset Cost Centre - JVJV_OFFCCCHAR20
I_FLATRATEFlat Rate - JV overheadsJV_FLATRATCURR7
I_RECDOCRecurring Document Number - JV overheadsJV_RECDOCCHAR20
I_PAYSETSet of Accounts to Which Payroll Burden Clearing AppliesJV_PAYSETCHAR48
I_RATETYPE1Burden rate typeJV_RATETYCHAR2
I_RATETYPER1Overhead burden rate percentageJV_RATETYPDEC3
I_RATETYTEXT1Overhead burden rate textLTEXT_8JRCHAR70
I_RATETYPE2Burden rate typeJV_RATETYCHAR2
I_RATETYPER2Overhead burden rate percentageJV_RATETYPDEC3
I_RATETYTEXT2Overhead burden rate textLTEXT_8JRCHAR70
I_RATETYPE3Burden rate typeJV_RATETYCHAR2
I_RATETYPER3Overhead burden rate percentageJV_RATETYPDEC3
I_RATETYTEXT3Overhead burden rate textLTEXT_8JRCHAR70
I_PENCAT1Penalty CategoryJV_PENCATCHAR2
I_NOSIGRP1Non-signatory Recovery PercentageJV_NOSIGRPDEC6
I_NOCONRP1Non-consent Recovery Penalty PercentageJV_NOCONRPDEC6
I_PCTEXT1Penalty Category TextLTEXT_8JLCHAR70
I_PENCAT2Penalty CategoryJV_PENCATCHAR2
I_NOSIGRP2Non-signatory Recovery PercentageJV_NOSIGRPDEC6
I_NOCONRP2Non-consent Recovery Penalty PercentageJV_NOCONRPDEC6
I_PCTEXT2Penalty Category TextLTEXT_8JLCHAR70
I_PENCAT3Penalty CategoryJV_PENCATCHAR2
I_NOSIGRP3Non-signatory Recovery PercentageJV_NOSIGRPDEC6
I_NOCONRP3Non-consent Recovery Penalty PercentageJV_NOCONRPDEC6
I_PCTEXT3Penalty Category TextLTEXT_8JLCHAR70
Privacy Policy