SAP CPVJVACCTGDTLQRY Table in S/4 HANA - Generated Table for View
CPVJVACCTGDTLQRY is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP CPVJVACCTGDTLQRY table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: CPVJVACCTGDTLQRY
CPVJVACCTGDTLQRY table structure field list
Below is the full CPVJVACCTGDTLQRY field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| JOINTVENTURELINEITEM | Joint Venture Record Number | OIU_VDM_JOINT_VENTURE_LINE_ITM | CHAR | 18(0) | OBJNR | |||||
| LEDGER | Ledger | RLDNR | CHAR | 2(0) | T881 | ALPHA | RLDNR | GLN | H_T881 | RLDNR |
| RECORDTYPE | Record Type | RRCTY | CHAR | 1(0) | RRCTY | |||||
| SPECIALLEDGERVERSION | Version | RVERS | CHAR | 3(0) | T894 | ALPHA | RVERS | GVS | ||
| FISCALYEAR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
| LEDGERFISCALPERIOD | Posting period | POPER | NUMC | 3(0) | POPER | POPR | ||||
| CURRENCY | Currency Key | RTCUR | CUKY | 5(0) | TCURC | WAERS | FWS | |||
| UNITOFMEASURE | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| DEBITCREDITCODE | Debit/Credit Code | FIS_SHKZG | CHAR | 1(0) | SHKZG | |||||
| DOCUMENTTYPE | Document Category | DOCCT | CHAR | 1(0) | DOCCT | GCT | ||||
| ACCOUNTINGDOCUMENT | Accounting Document | OIU_VDM_ACCOUNTING_DOCUMENT | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
| ACCOUNTINGDOCUMENTITEM | Line Item in Joint Venture Document | OIU_VDM_ACCOUNTING_DOC_LINE_NO | NUMC | 3(0) | BUZEI | |||||
| COMPANYCODE | Company Code | FIS_BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
| JOINTVENTURE | Joint venture | JV_NAME | CHAR | 6(0) | T8JV | ALPHA | JV_NAME | JVV | ||
| CONTROLLINGAREA | Controlling Area | KOKRS | CHAR | 4(0) | TKA01 | CACCD | CAC | |||
| COSTCENTER | Cost Center | KOSTL | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KOS | ||
| CHARTOFACCOUNTS | Chart of Accounts | KTOPL | CHAR | 4(0) | T004 | KTOPL | KPL | C_KTOPL | KTOPL | |
| GLACCOUNTTYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | CHAR | 1(0) | GLACCOUNT_TYPE | |||||
| GLACCOUNT | Account Number | RACCT | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | ACC | ||
| JOINTVENTUREEQUITYGROUP | Equity group | JV_EGROUP | CHAR | 3(0) | T8JF | ALPHA | JV_EGROUP | GJE | ||
| BUSINESSAREA | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
| ORIGINORDER | Order Number | AUFNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | ANR | ||
| PROJECTINTERNALID | Internal WBS Element | OIU_VDM_INTERNAL_WBS_ELEMENT | NUMC | 8(0) | PRPS | ABPSP | PS_POSNR | |||
| PROFITCENTER | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
| MASTERFIXEDASSET | Main Asset Number | ANLN1 | CHAR | 12(0) | ANLH | ALPHA | ANLN1 | AN1 | ||
| FIXEDASSET | Asset Subnumber | ANLN2 | CHAR | 4(0) | ANLA | ALPHA | ANLN2 | AN2 | ||
| ASSETTRANSACTIONTYPE | Asset Transaction Type | ANBWA | CHAR | 3(0) | TABW | BWASL | ||||
| JOINTVENTURERECOVERYCODE | Recovery Indicator | JV_RECIND | CHAR | 2(0) | T8JJ | ALPHA | JV_RECIND | |||
| PARTNER | Partner account number | JV_PART | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | |||
| INTERNALORDER | Internal Order | OIU_VDM_INTERNAL_ORDER | CHAR | 12(0) | AUFK | ALPHA | AUFNR | |||
| NETWORKACTIVITY | Operation/Activity Number | VORNR | CHAR | 4(0) | NUMCV | VORNR | VGN | |||
| ADDITIONALQUANTITY1UNIT | Additional unit of measure | OIU_VDM_ADDL_UNIT_OF_MEASURE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| DOCUMENTITEMTEXT | Description of Line Item | OIU_VDM_DESC_OF_LINE_ITEM | CHAR | 50(0) | TEXT50 | |||||
| ISAUTOMATICALLYPOSTED | Automatic Posting | OIU_VDM_AUTOMATIC_POSTING | CHAR | 1(0) | TEXT1 | |||||
| ACCOUNTINGDOCUMENTTYPE | Accounting Document Type | OIU_VDM_ACCOUNTING_DOC_TYPE | CHAR | 2(0) | T003 | BLART | BAR | |||
| BUSINESSTRANSACTIONTYPE | Business Transaction Type | OIU_VDM_BUSINESS_TRANS_TYPE | CHAR | 4(0) | CHAR4 | |||||
| POSTINGDATE | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
| VALDATEFORCURRENCYTRANSLATION | Value Date for Currency Translation | WSDAT | DATS | 8(0) | DATUM | WSD | ||||
| VALUEDATE | Value date | VALUT | DATS | 8(0) | DATUM | |||||
| REFACCOUNTINGDOCUMENT | Ref Accounting Document | OIU_VDM_REF_ACCTG_DOCUMENT | CHAR | 10(0) | ALPHA | BELNR | ||||
| REFERENCEDOCUMENTFISCALYEAR | Reference Doc Year | OIU_VDM_REFERENCE_DOC_YEAR | NUMC | 4(0) | GJAHR | GJAHR | ||||
| REFJNTVENTUREDOCUMENTLINEITEM | Ref JV Document Item | OIU_VDM_REF_JV_DOCUMENT_ITEM | NUMC | 5(0) | NUMC5 | |||||
| REFERENCEDOCUMENTTYPE | Reference Doc Type | OIU_VDM_REFERENCE_DOC_TYPE | CHAR | 1(0) | DOCCT | |||||
| BUSINESSTRANSACTIONDOCITEM | Business Transaction | GLVOR | CHAR | 4(0) | CHAR4 | |||||
| REFACCOUNTINGDOCUMENTITEM | Ref Accounting Document Line Item | OIU_VDM_REF_ACCTG_DOC_LINE_ITM | NUMC | 3(0) | BUZEI | |||||
| PAYROLLTYPE | Payroll Type | OIU_VDM_JV_PAYROLL_TYPE | CHAR | 2(0) | T8JA | ALPHA | JV_BILIND | |||
| ACCOUNTINGDOCCREATEDBYUSER | Created By | FCLM_BAM_CREATED_BY | CHAR | 12(0) | XUBNAME | |||||
| DOCUMENTDATE | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
| TIMEENTRY | Time of Entry | CPUTM | TIMS | 6(0) | UZEIT | |||||
| TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | T007A | MWSKZ | ||||
| BILLINGMONTH | Billing Month | JV_BILLM | DATS | 8(0) | DATUM | |||||
| PURCHASEORDER | Purchase Order Number | VDM_PURCHASEORDER | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
| PURCHASEORDERITEM | Item Number of Purchase Order | VDM_PURCHASEORDERITEM | NUMC | 5(0) | EKPO | EBELP | BSP | |||
| TRANSACTIONTYPEDETERMINATION | Transaction Key | FAC_KTOSL | CHAR | 3(0) | CHAR3 | |||||
| ACTIVITYTYPE | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
| ALLOCATIONFREQUENCY | Allocation/cycle | CYCLE | CHAR | 10(0) | CYCLE | GCY | ||||
| STARTDATE | Start Date | SDATE | DATS | 8(0) | SDATE | GAS | ||||
| MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| REFERENCEDOCUMENT | Reference Document Number | OIU_VDM_REFERENCE_DOC_NUMBER | CHAR | 10(0) | ALPHA | AWREF | ||||
| REFERENCEBILLINGDOCUMENT | Ref Billing Document | OIU_VDM_REF_BILLING_DOCUMENT | CHAR | 10(0) | ALPHA | BELNR | ||||
| CUSTOMER | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
| SUPPLIER | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
| PAYMENTTERMS | Terms of payment key | DZTERM | CHAR | 4(0) | ZTERM | |||||
| PRODUCTIONMONTH | Production Month (Date to find period and year) | JV_PRODPER | DATS | 8(0) | JV_PRODPER | |||||
| AMOUNTINTRANSACTIONCURRENCY | Amount in Transaction Currency | OIU_VDM_AMOUNT_IN_TRANS_CRCY | CURR | 17(2) | ||||||
| QUANTITYINBASEUNIT | Quantity in Base Unit | OIU_VDM_QUANTITY_IN_BASE_UNIT | QUAN | 15(3) | MENG8 | |||||
| AMOUNTINCOMPANYCODECURRENCY | Value in local currency | VLCUR9_CS | CURR | 17(2) | WERTV9 | |||||
| AMOUNTINGLOBALCURRENCY | Value in group currency | VGCUR9_CS | CURR | 17(2) | WERTV9 |
Search for further information about these or an SAP related objects