DETAIL_JOA_LIST SAP (ALV display of JOA detail list) Structure details

Dictionary Type: Structure
Description: ALV display of JOA detail list




ABAP Code to SELECT data from DETAIL_JOA_LIST
Related tables to DETAIL_JOA_LIST
Access table DETAIL_JOA_LIST




Structure field list including key, data, relationships and ABAP select examples

DETAIL_JOA_LIST is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "ALV display of JOA detail list" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DETAIL_JOA_LIST TYPE DETAIL_JOA_LIST.

The DETAIL_JOA_LIST table consists of various fields, each holding specific information or linking keys about ALV display of JOA detail list data available in SAP. These include JOA (Joint Operating Agreement), JTEXT (JOA Description), ACLASS (Joint operating agreement class), CONTRACT (JV Contract Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP DETAIL_JOA_LIST structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
COUNTER 0
JOAJoint Operating Agreement JV_JOACHAR6Assigned to domainALPHAJV_JOAJVJ
JTEXTJOA Description LTEXT_8JUCHAR40TEXT40
ACLASSJoint operating agreement class JV_ACLASSCHAR2Assigned to domainJV_ACLASS
CONTRACTJV Contract Number JV_CONTRACCHAR24ALPHAJV_CONTRAC
CONRULEConstruction Overhead Rule JV_CONRULECHAR6Assigned to domainJV_STEPRUL
XSETCONSet of Accounts to Exclude from Construction Overhead Calc. JV_XSETCONCHAR24SETNAME
CATRULECatastrophe Overhead Rule JV_CATRULECHAR6Assigned to domainJV_STEPRUL
XSETCATSet of Accounts to Exclude from Catastrophe Overhead Calc. JV_XSETCATCHAR24SETNAME
SEQNUMJV Sequence Number JV_SEQCHAR2ALPHAJV_SEQ
PROJWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
STEPTYPType of Stepped Rate Overhead to Apply to Project JV_STEPTYPCHAR2JV_STEPTYP
XSETOverride Set of Accounts to Exclude from Overhead Calc. JV_XSETOVRCHAR24SETNAME
XSET2Override Set of Accounts to Exclude from Overhead Calc. JV_XSETOVRCHAR24SETNAME
OVRPEROverride Percentage for Stepped Rate Overhead JV_OVRPERDEC5(2) DEC3_2
OVRRULEOverride Stepped Rate Overhead Rule (JVA) JV_OVRRULCHAR6Assigned to domainJV_STEPRUL
PER1Percent 1 (% Producing U.S., % Regular Canada) (JVA) JV_PER1DEC5(2) DEC3_2
PER2Percent 2 (% Development U.S., % Special Canada) (JVA) JV_PER2DEC5(2) DEC3_2
XPER1Exclusion Set of Accounts - Percent 1 (JVA) JV_XPER1CHAR24SETNAME
XPER2Exclusion Set of Accounts - Percent 2 (JVA) JV_XPER2CHAR24SETNAME
PAYSETSet of Accounts to Which Payroll Burden Clearing Applies JV_PAYSETCHAR24SETNAME
RATETYPEBurden rate type JV_RATETYCHAR1JV_RATETY
RATETYPEROverhead burden rate percentage JV_RATETYPDEC5(2) DEC3_2
RATETYTEXTOverhead burden rate text LTEXT_8JRCHAR35TEXT35
DRSTATDrilling Statistical Ratio (Joint Venture Accounting) JV_DRSTATCHAR6Assigned to domainSTAGR
RATEDrilling Rate - CFR Drilling JV_DRRATECURR13(2) WERT7
CURRENCY_FOR_RATE Currency for rate0
DRILL_FRDEPTHFrom Depth (JVA) JV_FRDEPTHDEC9(4) DEC5_4
DRILL_TODEPTHTo Depth, CFR Overhead (JVA) JV_TODEPTHDEC9(4) DEC5_4
PRSTATProducing Statistical Ratio (JVA) JV_PRSTATCHAR6Assigned to domainSTAGR
PRO_FRDEPTHFrom Depth (JVA) JV_FRDEPTHDEC9(4) DEC5_4
PRO_TODEPTHTo Depth, CFR Overhead (JVA) JV_TODEPTHDEC9(4) DEC5_4
SEQNUM2JV Sequence Number JV_SEQNUMNUMC2JV_SEQNUM
THRESHOLDThreshold Number of Wells JV_THRESHWNUMC5JV_NUM05
CURRENCY_THCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
RATE2Rate per Producing Well (JVA) JV_PRRATECURR13(2) WERT7
CURRENCY_RATECurrency Key WAERSCUKY5Assigned to domainWAERSFWS

Key field Non-key field



How do I retrieve data from SAP structure DETAIL_JOA_LIST using ABAP code?

As DETAIL_JOA_LIST is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DETAIL_JOA_LIST as there is no data to select.

How to access SAP table DETAIL_JOA_LIST

Within an ECC or HANA version of SAP you can also view further information about DETAIL_JOA_LIST and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!