J_3GVBRP

CEM Additional Data for VBRP | #transactional | Component: Construction Equipment Management

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (13)
Other (20)
🔗 Relations (29)

Column Name	Description
MANDT FK	Client
VBELN	Billing Document
POSNR	Billing Item

Column Name	Description

Column Name	Description

Column Name	Description
J_3GDATVO	From Date
J_3GDATBI	To Date

Column Name	Description
J_3GKZMENG	Item/Multipart Indicator	Show values
J_3GKZLAD	Indicator: Loading/Unloading Costs Apply	Show values
J_3GKZBERG	Indicator for Provision Fees	Show values
J_3GEIFR	Indicator for Own/External Equipment	Show values
J_3GBLTYP	CEM Document Category	Show values
J_3GPACHT	Leasing Type	Show values
J_3GREFTAB	Reference Type Partner Function - Sender	Show values
J_3GREFTWE	Reference Type Partner Function Ship-To Int./Sold-To Ext.	Show values
J_3GBEWEG	Internal Indicator for Transaction Type	Show values
J_3GABRART	Settlement Type	Show values
J_3GVMONAT	Indicator for Complete Month	Show values
J_3GKINP	Indicator: Item Created in Input	Show values
J_3GZUFRIS	Surcharge from Relevancy to Deadlines	Show values

Column Name	Description	Domain name
J_3GKATGR1	Catalog Group 1	J_3GKATGR1
J_3GKATGR2	Catalog Group 2	J_3GKATGR2
J_3GCOOBJA	CO Object - Sender	TEXT14
J_3GCOOBJE	CO Object - Recipient	TEXT14
J_3GLPCGR1	Providing Profit Center - Group 1	SETNAM_INT
J_3GLPCGR2	Providing Profit Center - Group 2	SETNAM_INT
J_3GLPCGR3	Providing Profit Center - Group 3	SETNAM_INT
J_3GLPCGR4	Providing Profit Center - Group 4	SETNAM_INT
J_3GBPCGR1	Debited Profit Center - Group 1	SETNAM_INT
J_3GBPCGR2	Debited Profit Center - Group 2	SETNAM_INT
J_3GBPCGR3	Debited Profit Center - Group 3	SETNAM_INT
J_3GBPCGR4	Debited Profit Center - Group 4	SETNAM_INT
J_3GTAGMON	Number of Days/Month	DEC3_2
J_3GABTAGM	Indicator - Retirement Date Counts in Settlement	CHAR1
J_3GSTDTAG	Hours per Day	DEC03_2
J_3GSTDMON	Hours per Month	DEC03_2
J_3GASTLNR	Number of Active BOM for Equipment (Internal No. Assignment)	NUMC4
J_3GEQSERNR	Serial Number	GERNR
J_3GABSVORNR	Operation/Activity Number	VORNR
J_3GEMPVORNR	Operation/Activity Number	VORNR

Master Data Relations	Join Conditions
Equipment Type	`J_3GVBRP.MANDT == T370K.MANDT` `J_3GVBRP.EQART == T370K.EQART`
Equipment Number Equipment Number Client	`J_3GVBRP.EQUNR == EQUI.EQUNR` `J_3GVBRP.MANDT == EQUI.MANDT`
Network Number for Account Assignment Network Number for Account Assignment Client	`J_3GVBRP.J_3GABSNPLNR == AUFK.AUFNR` `J_3GVBRP.MANDT == AUFK.MANDT`
Debited Company Code	`J_3GVBRP.MANDT == T001.MANDT` `J_3GVBRP.J_3GBBUKRS == T001.BUKRS`
Debited Business Area	`J_3GVBRP.MANDT == TGSB.MANDT` `J_3GVBRP.J_3GBGSBER == TGSB.GSBER`
Debited Controlling Area	`J_3GVBRP.MANDT == TKA01.MANDT` `J_3GVBRP.J_3GBKOKRS == TKA01.KOKRS`
Debited Profit Center 01 From Date Providing Controlling Area Debited Profit Center 01	`J_3GVBRP.MANDT == CEPC.MANDT` `J_3GVBRP.J_3GDATVO == CEPC.DATBI` `J_3GVBRP.J_3GLKOKRS == CEPC.KOKRS` `J_3GVBRP.J_3GBPRC01 == CEPC.PRCTR`
Debited Plant	`J_3GVBRP.MANDT == T001W.MANDT` `J_3GVBRP.J_3GBWERKS == T001W.WERKS`
Calendar ID	`J_3GVBRP.J_3GCALID == TFACD.IDENT`
Dummy Recipient	`J_3GVBRP.MANDT == KNA1.MANDT` `J_3GVBRP.J_3GDEMPST == KNA1.KUNNR`
Owner	`J_3GVBRP.MANDT == J_3GEIVERS.MANDT` `J_3GVBRP.J_3GEIGNER == J_3GEIVERS.J_3GEIGVER`
Network Number for Account Assignment Network Number for Account Assignment Client	`J_3GVBRP.J_3GEMPNPLNR == AUFK.AUFNR` `J_3GVBRP.MANDT == AUFK.MANDT`
Procurement Type Procurement Type for External Equipment Client	`J_3GVBRP.J_3GEQART == J_3GFEQUI.J_3GEQART` `J_3GVBRP.MANDT == J_3GFEQUI.MANDT`
Equipment Material Number Equipment Material Number Client	`J_3GVBRP.J_3GEQMATNR == MARA.MATNR` `J_3GVBRP.MANDT == MARA.MANDT`
Number in Catalog Number in Catalog Client Catalog Code	`J_3GVBRP.J_3GKATNRC == J_3GKATAL.J_3GKATNRC` `J_3GVBRP.MANDT == J_3GKATAL.MANDT` `J_3GVBRP.J_3GTPLKZ == J_3GKATAL.J_3GTPLKZ`
"Relevancy to Loading Costs" Indicator	`J_3GVBRP.MANDT == J_3GLADEKE.MANDT` `J_3GVBRP.J_3GKZLADG == J_3GLADEKE.J_3GKZLADG`
Providing Company Code	`J_3GVBRP.MANDT == T001.MANDT` `J_3GVBRP.J_3GLBUKRS == T001.BUKRS`
Providing Business Area	`J_3GVBRP.MANDT == TGSB.MANDT` `J_3GVBRP.J_3GLGSBER == TGSB.GSBER`
Providing Controlling Area	`J_3GVBRP.MANDT == TKA01.MANDT` `J_3GVBRP.J_3GLKOKRS == TKA01.KOKRS`
Providing Profit Center 01 From Date Providing Controlling Area Providing Profit Center 01	`J_3GVBRP.MANDT == CEPC.MANDT` `J_3GVBRP.J_3GDATVO == CEPC.DATBI` `J_3GVBRP.J_3GLKOKRS == CEPC.KOKRS` `J_3GVBRP.J_3GLPRC01 == CEPC.PRCTR`
Activity Type Activity Type Client	`J_3GVBRP.J_3GLVART == J_3GLEIART.J_3GLVART` `J_3GVBRP.MANDT == J_3GLEIART.MANDT`
Providing Plant	`J_3GVBRP.MANDT == T001W.MANDT` `J_3GVBRP.J_3GLWERKS == T001W.WERKS`
Settlement Package	`J_3GVBRP.MANDT == J_3GPAKK.MANDT` `J_3GVBRP.J_3GPAKET == J_3GPAKK.J_3GPAKET`
Price Determiner	`J_3GVBRP.MANDT == KNA1.MANDT` `J_3GVBRP.J_3GPEMPST == KNA1.KUNNR`
Price Group for Equipment Price Group for Equipment Client	`J_3GVBRP.J_3GPRGRPE == T188.KONDA` `J_3GVBRP.MANDT == T188.MANDT`
Standard Recipient	`J_3GVBRP.MANDT == KNA1.MANDT` `J_3GVBRP.J_3GSEMPST == KNA1.KUNNR`
Catalog Code	`J_3GVBRP.MANDT == J_3GT370S.MANDT` `J_3GVBRP.J_3GTPLKZ == J_3GT370S.J_3GTPLKZ`
Administrator	`J_3GVBRP.MANDT == J_3GEIVERS.MANDT` `J_3GVBRP.J_3GVERWAL == J_3GEIVERS.J_3GEIGVER`
Client	`J_3GVBRP.MANDT == T000.MANDT`