Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
  - Joint Venture Accounting (CA-JVA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
  - Joint Venture Accounting (CA-JVA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

C_GrossBillByVntrQ

Venture Expenses | view: CGRSSBILLJVQ | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting

Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, KNA1, SKA1, T8JS, T8JV, FINSC_LEDGER, PROJ, LFA1, PRPS, SKAT, T8JZ, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE

🔑 Keys
💰 Amounts (36)
∑ Quantities
📅 Dates
☰ Categorical (3)
Other (4)
🔗 Relations (29)

Column Name	Description

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
CurPerdAmtInTC	Current period amount in Transaction Currency
YrToDteAmtInTransacCrcy	Current period amount in Transaction Currency
ITDAmtInTC	ITD amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
CurPerdAmtInCCrcy	Current period amount in Transaction Currency
YearToDateAmountInCoCodeCrcy	Current period amount in Transaction Currency
ITDAmtInCCrcy	ITD amount in Company Currency
💲 Global Currency (GlobalCurrency):
CurPerdAmtInGCrcy	Current period amount in Transaction Currency
YearToDateAmountInGlobalCrcy	Current period amount in Transaction Currency
ITDAmtInGCrcy	ITD amount in Global Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
CurPerdAmtInBlTCrcy	Current period amount in Transaction Currency
YearToDateAmountInBalTransCrcy	Current period amount in Transaction Currency
ITDAmtInBlTCrcy	ITD amount in Balance Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
CurPerdAmtInFDCrcy1	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy1	Current period amount in Transaction Currency
ITDAmtInFDCrcy1	ITD amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
CurPerdAmtInFDCrcy2	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy2	Current period amount in Transaction Currency
ITDAmtInFDCrcy2	ITD amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
CurPerdAmtInFDCrcy3	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy3	Current period amount in Transaction Currency
ITDAmtInFDCrcy3	ITD amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
CurPerdAmtInFDCrcy4	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy4	Current period amount in Transaction Currency
ITDAmtInFDCrcy4	ITD amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
CurPerdAmtInFDCrcy5	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy5	Current period amount in Transaction Currency
ITDAmtInFDCrcy5	ITD amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
CurPerdAmtInFDCrcy6	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy6	Current period amount in Transaction Currency
ITDAmtInFDCrcy6	ITD amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
CurPerdAmtInFDCrcy7	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy7	Current period amount in Transaction Currency
ITDAmtInFDCrcy7	ITD amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
CurPerdAmtInFDCrcy8	Current period amount in Transaction Currency
YearToDateAmountInFDCrcy8	Current period amount in Transaction Currency
ITDAmtInFDCrcy8	ITD amount in Free Defined Currency 8

Column Name	Description

Column Name	Description

Column Name	Description
JointVentureType	Venture Type	Show values
GLRecordType	Record Type	Show values
DebitCreditCode	Debit/Credit Code	Show values

Column Name	Description	Domain name
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
JointVenturePartner	Joint Venture Partner
AccountingDocument	Journal Entry	BELNR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6

Master Data Relations	Join Conditions
Asset Transaction Type Client Asset Transaction Type	`C_GROSSBILLBYVNTRQ.MANDT == TABW.MANDT` `C_GROSSBILLBYVNTRQ.ASSETTRANSACTIONTYPE == TABW.BWASL`
Balance Transaction Currency Client Balance Transaction Currency	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.BALANCETRANSACTIONCURRENCY == TCURC.WAERS`
Base Unit of Measure Client Base Unit of Measure	`C_GROSSBILLBYVNTRQ.MANDT == T006.MANDT` `C_GROSSBILLBYVNTRQ.BASEUNIT == T006.MSEHI`
Business Area Client Business Area	`C_GROSSBILLBYVNTRQ.MANDT == TGSB.MANDT` `C_GROSSBILLBYVNTRQ.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`C_GROSSBILLBYVNTRQ.COMPANYCODE == T001.BUKRS` `C_GROSSBILLBYVNTRQ.MANDT == T001.MANDT`
Company Code Currency Client Company Code Currency	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.COMPANYCODECURRENCY == TCURC.WAERS`
Controlling Area Controlling Area Client	`C_GROSSBILLBYVNTRQ.CONTROLLINGAREA == TKA01.KOKRS` `C_GROSSBILLBYVNTRQ.MANDT == TKA01.MANDT`
Cost Center Cost Center ? Controlling Area Client	`C_GROSSBILLBYVNTRQ.COSTCENTER == CSKS.KOSTL` `C_GROSSBILLBYVNTRQ.[column in domain "DATBI"] == CSKS.DATBI` `C_GROSSBILLBYVNTRQ.CONTROLLINGAREA == CSKS.KOKRS` `C_GROSSBILLBYVNTRQ.MANDT == CSKS.MANDT`
Asset Subnumber Asset Subnumber Client Fixed Asset ?	`C_GROSSBILLBYVNTRQ.FIXEDASSET == ANLA.ANLN2` `C_GROSSBILLBYVNTRQ.MANDT == ANLA.MANDT` `C_GROSSBILLBYVNTRQ.MASTERFIXEDASSET == ANLA.ANLN1` `C_GROSSBILLBYVNTRQ.[column in domain "BUKRS"] == ANLA.BUKRS`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY1 == TCURC.WAERS` `C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT`
Freely Defined Currency 2 Client Freely Defined Currency 2	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY2 == TCURC.WAERS`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Client Freely Defined Currency 5	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY5 == TCURC.WAERS`
Freely Defined Currency 6 Client Freely Defined Currency 6	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY6 == TCURC.WAERS`
Freely Defined Currency 7 Client Freely Defined Currency 7	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Client Freely Defined Currency 8	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.FREEDEFINEDCURRENCY8 == TCURC.WAERS`
G/L Account Company Code G/L Account Client	`C_GROSSBILLBYVNTRQ.COMPANYCODE == SKB1.BUKRS` `C_GROSSBILLBYVNTRQ.GLACCOUNT == SKB1.SAKNR` `C_GROSSBILLBYVNTRQ.MANDT == SKB1.MANDT`
Global Currency Client Global Currency	`C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT` `C_GROSSBILLBYVNTRQ.GLOBALCURRENCY == TCURC.WAERS`
Joint venture Client Joint venture ?	`C_GROSSBILLBYVNTRQ.MANDT == T8JV.MANDT` `C_GROSSBILLBYVNTRQ.JOINTVENTURE == T8JV.VNAME` `C_GROSSBILLBYVNTRQ.[column in domain "BUKRS"] == T8JV.BUKRS`
Joint Venture Billing Type Joint Venture Billing Type Client	`C_GROSSBILLBYVNTRQ.JOINTVENTUREBILLINGTYPE == T8JA.BILIND` `C_GROSSBILLBYVNTRQ.MANDT == T8JA.MANDT`
Joint Venture Cost Recovery Code Client Joint Venture Cost Recovery Code ?	`C_GROSSBILLBYVNTRQ.MANDT == T8JJ.MANDT` `C_GROSSBILLBYVNTRQ.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID` `C_GROSSBILLBYVNTRQ.[column in domain "BUKRS"] == T8JJ.BUKRS`
Joint Venture Equity Group Joint Venture Equity Group Client Joint venture ?	`C_GROSSBILLBYVNTRQ.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP` `C_GROSSBILLBYVNTRQ.MANDT == T8JF.MANDT` `C_GROSSBILLBYVNTRQ.JOINTVENTURE == T8JF.VNAME` `C_GROSSBILLBYVNTRQ.[column in domain "BUKRS"] == T8JF.BUKRS`
Joint Venture Equity Type Joint Venture Equity Type Client ?	`C_GROSSBILLBYVNTRQ.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE` `C_GROSSBILLBYVNTRQ.MANDT == T8JE.MANDT` `C_GROSSBILLBYVNTRQ.[column in domain "BUKRS"] == T8JE.BUKRS`
Order ID Order ID Client	`C_GROSSBILLBYVNTRQ.ORDERID == AUFK.AUFNR` `C_GROSSBILLBYVNTRQ.MANDT == AUFK.MANDT`
Profit Center ? Controlling Area Profit Center Client	`C_GROSSBILLBYVNTRQ.[column in domain "DATBI"] == CEPC.DATBI` `C_GROSSBILLBYVNTRQ.CONTROLLINGAREA == CEPC.KOKRS` `C_GROSSBILLBYVNTRQ.PROFITCENTER == CEPC.PRCTR` `C_GROSSBILLBYVNTRQ.MANDT == CEPC.MANDT`
Network Number for Account Assignment Network Number for Account Assignment Client	`C_GROSSBILLBYVNTRQ.PROJECTNETWORK == AUFK.AUFNR` `C_GROSSBILLBYVNTRQ.MANDT == AUFK.MANDT`
Transaction Currency Transaction Currency Client	`C_GROSSBILLBYVNTRQ.TRANSACTIONCURRENCY == TCURC.WAERS` `C_GROSSBILLBYVNTRQ.MANDT == TCURC.MANDT`