IJVAPARTNDSTTAB
Document Table for CDS View:I_JVAPARTNERBILLINGENTYCUBE
IJVAPARTNDSTTAB is an SAP database table in S/4HANA. Document Table for CDS View:I_JVAPARTNERBILLINGENTYCUBE. It contains 182 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_JVAPartnerBillingEntyDSt | view_entity | from | BASIC | DS for IJVAPARTNERBILLINGENTYCUBE |
Fields (182)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | abap.clnt | |
| KEY | docid | abap.numc | |
| KEY | version | abap.numc | |
| doctag | abap.char | ||
| docqprov | abap.char | ||
| tra_00001 | abap.char | ||
| sva_00001 | abap.char | ||
| tra_supplier | abap.char | ||
| sva_supplier | abap.char | ||
| tra_projectnetwork | abap.char | ||
| sva_projectnetwork | abap.char | ||
| tra_00002 | abap.char | ||
| sva_00002 | abap.char | ||
| tra_00003 | abap.char | ||
| sva_00003 | abap.char | ||
| tra_00004 | abap.char | ||
| sva_00004 | abap.char | ||
| tra_00005 | abap.numc | ||
| sva_00005 | abap.char | ||
| svh_00005 | abap.char | ||
| hnm_00005 | abap.char | ||
| hno_00005 | abap.char | ||
| hio_00005 | abap.char | ||
| tra_00006 | abap.char | ||
| sva_00006 | abap.char | ||
| tra_00007 | abap.cuky | ||
| sva_00007 | abap.char | ||
| tra_customer | abap.char | ||
| sva_customer | abap.char | ||
| tra_postingdate | abap.dats | ||
| sva_postingdate | abap.char | ||
| svh_postingdate | abap.char | ||
| hnm_postingdate | abap.char | ||
| hno_postingdate | abap.char | ||
| hio_postingdate | abap.char | ||
| tra_00008 | abap.char | ||
| sva_00008 | abap.char | ||
| tra_00009 | abap.char | ||
| sva_00009 | abap.char | ||
| tra_costcenter | abap.char | ||
| sva_costcenter | abap.char | ||
| svh_costcenter | abap.char | ||
| hnm_costcenter | abap.char | ||
| hno_costcenter | abap.char | ||
| hio_costcenter | abap.char | ||
| tra_globalcurrency | abap.cuky | ||
| sva_globalcurrency | abap.char | ||
| tra_00010 | abap.numc | ||
| sva_00010 | abap.char | ||
| tra_00011 | abap.cuky | ||
| sva_00011 | abap.char | ||
| tra_00012 | abap.cuky | ||
| sva_00012 | abap.char | ||
| tra_00013 | abap.char | ||
| sva_00013 | abap.char | ||
| tra_00014 | abap.char | ||
| sva_00014 | abap.char | ||
| svh_00014 | abap.char | ||
| hnm_00014 | abap.char | ||
| hno_00014 | abap.char | ||
| hio_00014 | abap.char | ||
| tra_00015 | abap.char | ||
| sva_00015 | abap.char | ||
| tra_assetclass | abap.char | ||
| sva_assetclass | abap.char | ||
| tra_00016 | abap.char | ||
| sva_00016 | abap.char | ||
| tra_fiscalyear | abap.numc | ||
| sva_fiscalyear | abap.char | ||
| tra_businessarea | abap.char | ||
| sva_businessarea | abap.char | ||
| svh_businessarea | abap.char | ||
| hnm_businessarea | abap.char | ||
| hno_businessarea | abap.char | ||
| hio_businessarea | abap.char | ||
| tra_glaccount | abap.char | ||
| sva_glaccount | abap.char | ||
| svh_glaccount | abap.char | ||
| hnm_glaccount | abap.char | ||
| hno_glaccount | abap.char | ||
| hio_glaccount | abap.char | ||
| tra_segment | abap.char | ||
| sva_segment | abap.char | ||
| tra_00017 | abap.char | ||
| sva_00017 | abap.char | ||
| tra_00018 | abap.char | ||
| sva_00018 | abap.char | ||
| tra_00019 | abap.char | ||
| sva_00019 | abap.char | ||
| tra_00020 | abap.cuky | ||
| sva_00020 | abap.char | ||
| tra_00021 | abap.cuky | ||
| sva_00021 | abap.char | ||
| tra_00022 | abap.char | ||
| sva_00022 | abap.char | ||
| tra_00023 | abap.char | ||
| sva_00023 | abap.char | ||
| tra_00024 | abap.cuky | ||
| sva_00024 | abap.char | ||
| tra_00025 | abap.numc | ||
| sva_00025 | abap.char | ||
| tra_p_fiscalperiod | abap.numc | ||
| sva_p_fiscalperiod | abap.char | ||
| tra_00026 | abap.cuky | ||
| sva_00026 | abap.char | ||
| tra_00027 | abap.char | ||
| sva_00027 | abap.char | ||
| tra_00028 | abap.char | ||
| sva_00028 | abap.char | ||
| tra_jointventure | abap.char | ||
| sva_jointventure | abap.char | ||
| tra_baseunit | abap.unit | ||
| sva_baseunit | abap.char | ||
| tra_00029 | abap.char | ||
| sva_00029 | abap.char | ||
| tra_profitcenter | abap.char | ||
| sva_profitcenter | abap.char | ||
| svh_profitcenter | abap.char | ||
| hnm_profitcenter | abap.char | ||
| hno_profitcenter | abap.char | ||
| hio_profitcenter | abap.char | ||
| tra_fixedasset | abap.char | ||
| sva_fixedasset | abap.char | ||
| tra_00030 | abap.cuky | ||
| sva_00030 | abap.char | ||
| tra_00031 | abap.cuky | ||
| sva_00031 | abap.char | ||
| tra_00032 | abap.char | ||
| sva_00032 | abap.char | ||
| tra_fiscalperiod | abap.numc | ||
| sva_fiscalperiod | abap.char | ||
| tra_glrecordtype | abap.char | ||
| sva_glrecordtype | abap.char | ||
| tra_orderid | abap.char | ||
| sva_orderid | abap.char | ||
| svh_orderid | abap.char | ||
| hnm_orderid | abap.char | ||
| hno_orderid | abap.char | ||
| hio_orderid | abap.char | ||
| tra_00033 | abap.char | ||
| sva_00033 | abap.char | ||
| tra_00034 | abap.char | ||
| sva_00034 | abap.char | ||
| tra_valuationarea | abap.char | ||
| sva_valuationarea | abap.char | ||
| tra_salesdocument | abap.char | ||
| sva_salesdocument | abap.char | ||
| tra_plant | abap.char | ||
| sva_plant | abap.char | ||
| tra_00035 | abap.cuky | ||
| sva_00035 | abap.char | ||
| tra_companycode | abap.char | ||
| sva_companycode | abap.char | ||
| svh_companycode | abap.char | ||
| hnm_companycode | abap.char | ||
| hno_companycode | abap.char | ||
| hio_companycode | abap.char | ||
| tra_ledger | abap.char | ||
| sva_ledger | abap.char | ||
| tra_00036 | abap.cuky | ||
| sva_00036 | abap.char | ||
| tra_00037 | abap.char | ||
| sva_00037 | abap.char | ||
| tra_00038 | abap.char | ||
| sva_00038 | abap.char | ||
| tra_00039 | abap.char | ||
| sva_00039 | abap.char | ||
| tra_00040 | abap.cuky | ||
| sva_00040 | abap.char | ||
| tra_functionalarea | abap.char | ||
| sva_functionalarea | abap.char | ||
| doctype | abap.char | ||
| owner | abap.char | ||
| infoprov | abap.char | ||
| sva_infoprov | abap.char | ||
| kyfnm | abap.char | ||
| docstat | abap.char | ||
| session_id | abap.char | ||
| timestamp | abap.dec | ||
| document | abap.rawstring | ||
| seldr | abap.rawstring | ||
| docprop | abap.rawstring |
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.
-- Document Table for CDS View:I_JVAPARTNERBILLINGENTYCUBE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IJVAPARTNDSTTAB (
CLIENT, -- abap.clnt
DOCID, -- abap.numc
VERSION, -- abap.numc
DOCTAG, -- abap.char
DOCQPROV, -- abap.char
TRA_00001, -- abap.char
SVA_00001, -- abap.char
TRA_SUPPLIER, -- abap.char
SVA_SUPPLIER, -- abap.char
TRA_PROJECTNETWORK, -- abap.char
SVA_PROJECTNETWORK, -- abap.char
TRA_00002, -- abap.char
SVA_00002, -- abap.char
TRA_00003, -- abap.char
SVA_00003, -- abap.char
TRA_00004, -- abap.char
SVA_00004, -- abap.char
TRA_00005, -- abap.numc
SVA_00005, -- abap.char
SVH_00005, -- abap.char
HNM_00005, -- abap.char
HNO_00005, -- abap.char
HIO_00005, -- abap.char
TRA_00006, -- abap.char
SVA_00006, -- abap.char
TRA_00007, -- abap.cuky
SVA_00007, -- abap.char
TRA_CUSTOMER, -- abap.char
SVA_CUSTOMER, -- abap.char
TRA_POSTINGDATE, -- abap.dats
SVA_POSTINGDATE, -- abap.char
SVH_POSTINGDATE, -- abap.char
HNM_POSTINGDATE, -- abap.char
HNO_POSTINGDATE, -- abap.char
HIO_POSTINGDATE, -- abap.char
TRA_00008, -- abap.char
SVA_00008, -- abap.char
TRA_00009, -- abap.char
SVA_00009, -- abap.char
TRA_COSTCENTER, -- abap.char
SVA_COSTCENTER, -- abap.char
SVH_COSTCENTER, -- abap.char
HNM_COSTCENTER, -- abap.char
HNO_COSTCENTER, -- abap.char
HIO_COSTCENTER, -- abap.char
TRA_GLOBALCURRENCY, -- abap.cuky
SVA_GLOBALCURRENCY, -- abap.char
TRA_00010, -- abap.numc
SVA_00010, -- abap.char
TRA_00011, -- abap.cuky
SVA_00011, -- abap.char
TRA_00012, -- abap.cuky
SVA_00012, -- abap.char
TRA_00013, -- abap.char
SVA_00013, -- abap.char
TRA_00014, -- abap.char
SVA_00014, -- abap.char
SVH_00014, -- abap.char
HNM_00014, -- abap.char
HNO_00014, -- abap.char
HIO_00014, -- abap.char
TRA_00015, -- abap.char
SVA_00015, -- abap.char
TRA_ASSETCLASS, -- abap.char
SVA_ASSETCLASS, -- abap.char
TRA_00016, -- abap.char
SVA_00016, -- abap.char
TRA_FISCALYEAR, -- abap.numc
SVA_FISCALYEAR, -- abap.char
TRA_BUSINESSAREA, -- abap.char
SVA_BUSINESSAREA, -- abap.char
SVH_BUSINESSAREA, -- abap.char
HNM_BUSINESSAREA, -- abap.char
HNO_BUSINESSAREA, -- abap.char
HIO_BUSINESSAREA, -- abap.char
TRA_GLACCOUNT, -- abap.char
SVA_GLACCOUNT, -- abap.char
SVH_GLACCOUNT, -- abap.char
HNM_GLACCOUNT, -- abap.char
HNO_GLACCOUNT, -- abap.char
HIO_GLACCOUNT, -- abap.char
TRA_SEGMENT, -- abap.char
SVA_SEGMENT, -- abap.char
TRA_00017, -- abap.char
SVA_00017, -- abap.char
TRA_00018, -- abap.char
SVA_00018, -- abap.char
TRA_00019, -- abap.char
SVA_00019, -- abap.char
TRA_00020, -- abap.cuky
SVA_00020, -- abap.char
TRA_00021, -- abap.cuky
SVA_00021, -- abap.char
TRA_00022, -- abap.char
SVA_00022, -- abap.char
TRA_00023, -- abap.char
SVA_00023, -- abap.char
TRA_00024, -- abap.cuky
SVA_00024, -- abap.char
TRA_00025, -- abap.numc
SVA_00025, -- abap.char
TRA_P_FISCALPERIOD, -- abap.numc
SVA_P_FISCALPERIOD, -- abap.char
TRA_00026, -- abap.cuky
SVA_00026, -- abap.char
TRA_00027, -- abap.char
SVA_00027, -- abap.char
TRA_00028, -- abap.char
SVA_00028, -- abap.char
TRA_JOINTVENTURE, -- abap.char
SVA_JOINTVENTURE, -- abap.char
TRA_BASEUNIT, -- abap.unit
SVA_BASEUNIT, -- abap.char
TRA_00029, -- abap.char
SVA_00029, -- abap.char
TRA_PROFITCENTER, -- abap.char
SVA_PROFITCENTER, -- abap.char
SVH_PROFITCENTER, -- abap.char
HNM_PROFITCENTER, -- abap.char
HNO_PROFITCENTER, -- abap.char
HIO_PROFITCENTER, -- abap.char
TRA_FIXEDASSET, -- abap.char
SVA_FIXEDASSET, -- abap.char
TRA_00030, -- abap.cuky
SVA_00030, -- abap.char
TRA_00031, -- abap.cuky
SVA_00031, -- abap.char
TRA_00032, -- abap.char
SVA_00032, -- abap.char
TRA_FISCALPERIOD, -- abap.numc
SVA_FISCALPERIOD, -- abap.char
TRA_GLRECORDTYPE, -- abap.char
SVA_GLRECORDTYPE, -- abap.char
TRA_ORDERID, -- abap.char
SVA_ORDERID, -- abap.char
SVH_ORDERID, -- abap.char
HNM_ORDERID, -- abap.char
HNO_ORDERID, -- abap.char
HIO_ORDERID, -- abap.char
TRA_00033, -- abap.char
SVA_00033, -- abap.char
TRA_00034, -- abap.char
SVA_00034, -- abap.char
TRA_VALUATIONAREA, -- abap.char
SVA_VALUATIONAREA, -- abap.char
TRA_SALESDOCUMENT, -- abap.char
SVA_SALESDOCUMENT, -- abap.char
TRA_PLANT, -- abap.char
SVA_PLANT, -- abap.char
TRA_00035, -- abap.cuky
SVA_00035, -- abap.char
TRA_COMPANYCODE, -- abap.char
SVA_COMPANYCODE, -- abap.char
SVH_COMPANYCODE, -- abap.char
HNM_COMPANYCODE, -- abap.char
HNO_COMPANYCODE, -- abap.char
HIO_COMPANYCODE, -- abap.char
TRA_LEDGER, -- abap.char
SVA_LEDGER, -- abap.char
TRA_00036, -- abap.cuky
SVA_00036, -- abap.char
TRA_00037, -- abap.char
SVA_00037, -- abap.char
TRA_00038, -- abap.char
SVA_00038, -- abap.char
TRA_00039, -- abap.char
SVA_00039, -- abap.char
TRA_00040, -- abap.cuky
SVA_00040, -- abap.char
TRA_FUNCTIONALAREA, -- abap.char
SVA_FUNCTIONALAREA, -- abap.char
DOCTYPE, -- abap.char
OWNER, -- abap.char
INFOPROV, -- abap.char
SVA_INFOPROV, -- abap.char
KYFNM, -- abap.char
DOCSTAT, -- abap.char
SESSION_ID, -- abap.char
TIMESTAMP, -- abap.dec
DOCUMENT, -- abap.rawstring
SELDR, -- abap.rawstring
DOCPROP, -- abap.rawstring
PRIMARY KEY (CLIENT, DOCID, VERSION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA