SAP-tabelreferentie

J_3GBELK

Document File - Header Data

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

Bekijk de structuur, velden en relaties van SAP-tabel J_3GBELK.

SAP-tabel J_3GBELK heeft 2 primaire sleutelvelden: MANDT,J_3GBELNRI.

Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.

/ Velden

J_3GBELK velden.

121 velden
VeldOmschrijvingDatatypeLengteDecimalenChecktabelData-element
Sleutel MANDT ClientCLNT30 T000 MANDT
Sleutel J_3GBELNRI Document NumberCHAR100 J_3GBELNRI
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
ERZET Entry timeTIMS60 ERZET
ERDAT Date on which the record was createdDATS80 ERDAT
UNAME Name of Person Who Changed ObjectCHAR120 AENAM
AEZET Time last change was madeTIMS60 AEZET
AEDTM Last Changed OnDATS80 AEDAT
J_3GABSEND SenderCHAR100 KNA1 J_3GABSEND
J_3GABSREF Reference Type SenderCHAR20 J_3GABSREF
J_3GABSPSP WBS Element SenderNUMC80 PRPS J_3GABSPSP
J_3GABSPRO Project Number SenderNUMC80 PROJ J_3GABSPRO
J_3GABSKOS Cost Center SenderCHAR100 CSKS J_3GABSKOS
J_3GABSKOK Controlling Area SenderCHAR40 TKA01 J_3GABSKOK
J_3GABSACO Sender of CO OrderCHAR120 AUFK J_3GABSACO
J_3GABSAPM Sender of PM OrderCHAR120 AUFK J_3GABSAPM
J_3GABSWRK Plant SenderCHAR40 T001W J_3GABSWRK
J_3GABSLAG Storage Location/Warehouse SenderCHAR40 T001L J_3GABSLAG
J_3GABSEXT External Ship-to Party - SenderCHAR100 KNA1 J_3GABSEXT
J_3GABSDEB Debtor of SenderCHAR100 KNA1 J_3GABSDEB
J_3GEMPFAE RecipientCHAR100 KNA1 J_3GEMPFAE
J_3GEMPREF Receiving Reference TypeCHAR20 J_3GEMPREF
J_3GEMPPSP Receiving WBS ElementNUMC80 PRPS J_3GEMPPSP
J_3GEMPPRO Receiving Project NumberNUMC80 PROJ J_3GEMPPRO
J_3GEMPKOS Receiving Cost CenterCHAR100 CSKS J_3GEMPKOS
J_3GEMPKOK Receiving Controlling AreaCHAR40 TKA01 J_3GEMPKOK
J_3GEMPACO CO Order RecipientCHAR120 AUFK J_3GEMPACO
J_3GEMPAPM PM Order RecipientCHAR120 AUFK J_3GEMPAPM
J_3GEMPWRK Receiving PlantCHAR40 T001W J_3GEMPWRK
J_3GEMPLAG Receiving Storage LocationCHAR40 T001L J_3GEMPLAG
J_3GEMPEXT External Ship-To Party - RecipientCHAR100 KNA1 J_3GEMPEXT
J_3GEMPDEB Debtor of RecipientCHAR100 KNA1 J_3GEMPDEB
J_3GMITTLE Intermediate RecipientCHAR100 KNA1 J_3GMITTLE
J_3GMITREF Reference Type - Intermediate RecipientCHAR20 J_3GMITREF
J_3GMITPSP WBS Element - Intermediate RecipientNUMC80 PRPS J_3GMITPSP
J_3GMITPRO Project Number - Intermediate RecipientNUMC80 PROJ J_3GMITPRO
J_3GMITKOS Cost Center - Intermediate RecipientCHAR100 CSKS J_3GMITKOS
J_3GMITKOK Controlling Area - Intermediate RecipientCHAR40 TKA01 J_3GMITKOK
J_3GMITACO CO Order - Intermediate RecipientCHAR120 AUFK J_3GMITACO
J_3GMITAPM PM Order RecipientCHAR120 AUFK J_3GMITAPM
J_3GMITWRK Plant - Intermediate RecipientCHAR40 T001W J_3GMITWRK
J_3GMITLAG Storage Location - Intermediate RecipientCHAR40 T001L J_3GMITLAG
J_3GFREMDP Indicator for External EmployeesCHAR10 J_3GFREMDP
PERNR Personal NumberNUMC80 * J_3GPERNR
NACHN Last NameCHAR250 NACHN
J_3GEMPPER Receiving Cost Center for PersonnelCHAR100 KNA1 J_3GEMPPER
J_3GBELSTA Internal Document StatusCHAR10 J_3GBELSTA
J_3GPIABS Document Flat Rate Indicator (Internal) - SenderCHAR10 J_3GPIABS
J_3GPEABS Document Flat Rate Indicator (External) - SenderCHAR10 J_3GPEABS
J_3GPIEMPF Document Flat Rate Indicator (Internal) - RecipientCHAR10 J_3GPIEMPS
J_3GPEEMPS Document Flat Rate Indicator (External) - RecipientCHAR10 J_3GPEEMPS
J_3GBETR1 Internal Flat Rate - SenderCURR152 J_3GBETR1
J_3GBETR2 External Flat Rate - SenderCURR152 J_3GBETR2
J_3GBETR3 Internal Flat Rate - RecipientCURR152 J_3GBETR3
J_3GBETR4 External Flat Rate - RecipientCURR152 J_3GBETR4
J_3GWAERS1 Currency Flat Rate Amount (Internal) - SenderCUKY50 TCURC J_3GWAERS1
J_3GWAERS2 Currency Flat Rate Amount (External) - SenderCUKY50 TCURC J_3GWAERS2
J_3GWAERS3 Currency Flat Rate Amount (Internal) - RecipientCUKY50 TCURC J_3GWAERS3
J_3GWAERS4 Currency Flat Rate Amount (External) - RecipientCUKY50 TCURC J_3GWAERS4
J_3GFAKTAB Billing Indicator - SenderCHAR10 J_3GFAKTAB
J_3GFAKTEM Billing Indicator - RecipientCHAR10 J_3GFAKTEM
EQUNR Equipment NumberCHAR180 EQUI EQUNR
J_3GTPLKZ Catalog CodeCHAR50 J_3GT370S J_3GTPLKZ
J_3GKATNRC Number in CatalogCHAR300 J_3GKATAL J_3GKATNRC
LFDNR Sequence NumberNUMC40 J_3GLFDNR4
J_3GDOMLMB Pricing Dominancy (Provider/Intermediate Recipient/Debtor)CHAR10 J_3GDOMLMB
J_3GDOMMB Pricing Dominancy (Intermediate Recipient/Debtor)CHAR10 J_3GDOMMB
J_3GBELNR External Document NumberCHAR100 J_3GBELNR
J_3GBLART Document TypeCHAR40 J_3GBELART J_3GBLART
J_3GBLTYP CEM Document CategoryCHAR10 J_3GBLTYP
J_3GBELDAT CEM Document DateDATS80 J_3GBELDAT
VKORG Sales Organization, but ObsoleteCHAR40 TVKO /SAPCEM/VKORG
VTWEG Distribution Channel, but ObsoleteCHAR20 TVTW /SAPCEM/VTWEG
SPART Division, but ObsoleteCHAR20 TSPA /SAPCEM/SPART
INCO1 Incoterms (Part 1)CHAR30 TINC INCO1
J_3GBEWEG Internal Indicator for Transaction TypeCHAR10 J_3GBEWEG
J_3GBELSTE External Document StatusCHAR10 J_3GBELSTE
SLWID Key word ID for user-defined fieldsCHAR70 TCN00 SLWID
USR00 User field with 20 charactersCHAR200 USRCHAR20
USR01 User field with 20 charactersCHAR200 USRCHAR20
USR02 User Field with 10 CharactersCHAR100 USRCHAR10
USR03 User Field with 10 CharactersCHAR100 USRCHAR10
USR04 User field for quantity (length 10.3)QUAN133 USRQUAN13
USE04 User field: Unit for quantity fieldsUNIT30 T006 USRUNIT
USR05 User field for quantity (length 10.3)QUAN133 USRQUAN13
USE05 User field: Unit for quantity fieldsUNIT30 T006 USRUNIT
USR06 User-defined field for values (length 10,3)CURR133 USRCURR13
USE06 User field: Unit for value fieldsCUKY50 TCURC USRCUKY
USR07 User-defined field for values (length 10,3)CURR133 USRCURR13
USE07 User field: Unit for value fieldsCUKY50 TCURC USRCUKY
USR08 User field for dateDATS80 USRDATE
USR09 User field for dateDATS80 USRDATE
USR10 User-defined field: Indicator for reportsCHAR10 USRFLAG
USR11 User-defined field: Indicator for reportsCHAR10 USRFLAG
VNAME Joint ventureCHAR60 T8JV JV_NAME
RECID Recovery IndicatorCHAR20 T8JJ JV_RECIND
ETYPE Equity typeCHAR30 T8JG JV_ETYPE
JV_OTYPE Joint Venture Object TypeCHAR40 JV_OTYPE
JV_JIBCL JIB/JIBE ClassCHAR30 T8J6A JV_JIBCL
JV_JIBSA JIB/JIBE Subclass ACHAR50 T8J6C JV_JIBSA
JV_OCO JV original cost objectCHAR10 JV_OR_CO
DUMMY_AFVU_INCL_EEW_PS Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
SPARAMETER1 Scheduling Parameters for External SchedulingCHAR40 SPARAMETER
SPARAMETER2 Scheduling Parameters for External SchedulingCHAR40 SPARAMETER
SPARAMETER3 Scheduling Parameters for External SchedulingCHAR40 SPARAMETER
ILART_OP Maintenance activity typeCHAR30 ILA
FERC_IND Regulatory indicatorCHAR40 FERC_C7 FE_IND
J_3GVVCOM1 CommentCHAR400 J_3GVVCOM
J_3GVVCOM2 CommentCHAR400 J_3GVVCOM
GSGEW Total WeightQUAN153 GSGEW
GEWEI Weight UnitUNIT30 GEWEI
J_3GABS_BUKRS Company CodeCHAR40 BUKRS
J_3GABS_GSBER Business AreaCHAR40 GSBER
MBLNR Number of Material DocumentCHAR100 MBLNR
MJAHR Material Document YearNUMC40 MJAHR
J_3GEMP_BUKRS Company CodeCHAR40 BUKRS
J_3GEMP_GSBER Business AreaCHAR40 GSBER
J_3GABSNPLNR Network Number for Account AssignmentCHAR120 NPLNR
J_3GABSVORNR Operation/Activity NumberCHAR40 VORNR
J_3GEMPNPLNR Network Number for Account AssignmentCHAR120 NPLNR
J_3GEMPVORNR Operation/Activity NumberCHAR40 VORNR
/ Relaties

J_3GBELK relaties.

100 relaties
TabelVeldChecktabelOmschrijvingCheckveld
J_3GBELKEQUNREQUIEquipment master dataMANDT
J_3GBELKETYPET8JGValid Investment GroupMANDT
J_3GBELKETYPET8JGValid Investment GroupBUKRS
J_3GBELKETYPET8JGValid Investment GroupVNAME
J_3GBELKETYPET8JGValid Investment GroupFDATE
J_3GBELKFERC_INDFERC_C7Regulatory indicatorsMANDT
J_3GBELKFERC_INDFERC_C7Regulatory indicatorsIND
J_3GBELKINCO1TINCCustomers: IncotermsINCO1
J_3GBELKJV_JIBCLT8J6AJIB/JIBE ClassMANDT
J_3GBELKJV_JIBCLT8J6AJIB/JIBE ClassBUKRS
J_3GBELKJV_JIBCLT8J6AJIB/JIBE ClassCLASS
J_3GBELKJV_JIBSAT8J6CJIB/JIBE SubclassMANDT
J_3GBELKJV_JIBSAT8J6CJIB/JIBE SubclassBUKRS
J_3GBELKJ_3GABSACOAUFKOrder master dataAUFNR
J_3GBELKJ_3GABSAPMAUFKOrder master dataAUFNR
J_3GBELKJ_3GABSDEBKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GABSDEBKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GABSENDKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GABSENDKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GABSEXTKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GABSEXTKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GABSKOKTKA01Controlling AreasMANDT
J_3GBELKJ_3GABSKOSCSKSCost Center Master RecordMANDT
J_3GBELKJ_3GABSKOSCSKSCost Center Master RecordKOKRS
J_3GBELKJ_3GABSKOSCSKSCost Center Master RecordKOSTL
J_3GBELKJ_3GABSKOSCSKSCost Center Master RecordDATBI
J_3GBELKJ_3GABSLAGT001LStorage LocationsMANDT
J_3GBELKJ_3GABSLAGT001LStorage LocationsWERKS
J_3GBELKJ_3GABSPROPROJProject definitionMANDT
J_3GBELKJ_3GABSPROPROJProject definitionPSPNR
J_3GBELKJ_3GABSPSPPRPSWBS (Work Breakdown Structure) Element Master DataMANDT
J_3GBELKJ_3GABSPSPPRPSWBS (Work Breakdown Structure) Element Master DataPSPNR
J_3GBELKJ_3GABSWRKT001WPlants/BranchesMANDT
J_3GBELKJ_3GABSWRKT001WPlants/BranchesWERKS
J_3GBELKJ_3GEMPACOAUFKOrder master dataAUFNR
J_3GBELKJ_3GEMPAPMAUFKOrder master dataAUFNR
J_3GBELKJ_3GEMPDEBKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GEMPDEBKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GEMPEXTKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GEMPEXTKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GEMPFAEKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GEMPFAEKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GEMPKOKTKA01Controlling AreasMANDT
J_3GBELKJ_3GEMPKOSCSKSCost Center Master RecordMANDT
J_3GBELKJ_3GEMPKOSCSKSCost Center Master RecordKOKRS
J_3GBELKJ_3GEMPKOSCSKSCost Center Master RecordDATBI
J_3GBELKJ_3GEMPLAGT001LStorage LocationsMANDT
J_3GBELKJ_3GEMPLAGT001LStorage LocationsWERKS
J_3GBELKJ_3GEMPPERKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GEMPPERKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GEMPPROPROJProject definitionMANDT
J_3GBELKJ_3GEMPPROPROJProject definitionPSPNR
J_3GBELKJ_3GEMPPSPPRPSWBS (Work Breakdown Structure) Element Master DataMANDT
J_3GBELKJ_3GEMPPSPPRPSWBS (Work Breakdown Structure) Element Master DataPSPNR
J_3GBELKJ_3GEMPWRKT001WPlants/BranchesWERKS
J_3GBELKJ_3GKATNRCJ_3GKATALCatalogJ_3GKATNRC
J_3GBELKJ_3GMITACOAUFKOrder master dataAUFNR
J_3GBELKJ_3GMITAPMAUFKOrder master dataAUFNR
J_3GBELKJ_3GMITKOKTKA01Controlling AreasMANDT
J_3GBELKJ_3GMITKOSCSKSCost Center Master RecordMANDT
J_3GBELKJ_3GMITKOSCSKSCost Center Master RecordKOKRS
J_3GBELKJ_3GMITKOSCSKSCost Center Master RecordKOSTL
J_3GBELKJ_3GMITKOSCSKSCost Center Master RecordDATBI
J_3GBELKJ_3GMITLAGT001LStorage LocationsMANDT
J_3GBELKJ_3GMITLAGT001LStorage LocationsWERKS
J_3GBELKJ_3GMITPROPROJProject definitionMANDT
J_3GBELKJ_3GMITPROPROJProject definitionPSPNR
J_3GBELKJ_3GMITPSPPRPSWBS (Work Breakdown Structure) Element Master DataMANDT
J_3GBELKJ_3GMITPSPPRPSWBS (Work Breakdown Structure) Element Master DataPSPNR
J_3GBELKJ_3GMITTLEKNA1General Data in Customer MasterMANDT
J_3GBELKJ_3GMITTLEKNA1General Data in Customer MasterKUNNR
J_3GBELKJ_3GMITWRKT001WPlants/BranchesWERKS
J_3GBELKJ_3GTPLKZJ_3GT370SStructure Indicator for CatalogJ_3GTPLKZ
J_3GBELKJ_3GWAERS1TCURCCurrency CodesMANDT
J_3GBELKJ_3GWAERS1TCURCCurrency CodesWAERS
J_3GBELKJ_3GWAERS2TCURCCurrency CodesMANDT
J_3GBELKJ_3GWAERS2TCURCCurrency CodesWAERS
J_3GBELKJ_3GWAERS3TCURCCurrency CodesMANDT
J_3GBELKJ_3GWAERS3TCURCCurrency CodesWAERS
J_3GBELKJ_3GWAERS4TCURCCurrency CodesMANDT
J_3GBELKJ_3GWAERS4TCURCCurrency CodesWAERS
J_3GBELKMANDTT000ClientsMANDT
J_3GBELKRECIDT8JJRecovery IndicatorMANDT
J_3GBELKRECIDT8JJRecovery IndicatorBUKRS
J_3GBELKSLWIDTCN00Key Word ID for PS User FieldsMANDT
J_3GBELKSPARTTSPAOrganizational Unit: Sales DivisionsMANDT
J_3GBELKSPARTTSPAOrganizational Unit: Sales DivisionsSPART
J_3GBELKUSE04T006Units of MeasurementMANDT
J_3GBELKUSE05T006Units of MeasurementMANDT
J_3GBELKUSE06TCURCCurrency CodesMANDT
J_3GBELKUSE06TCURCCurrency CodesWAERS
J_3GBELKUSE07TCURCCurrency CodesMANDT
J_3GBELKUSE07TCURCCurrency CodesWAERS
J_3GBELKVKORGTVKOOrganizational Unit: Sales OrganizationsMANDT
J_3GBELKVKORGTVKOOrganizational Unit: Sales OrganizationsVKORG
J_3GBELKVNAMET8JVJoint VentureMANDT
J_3GBELKVNAMET8JVJoint VentureBUKRS
J_3GBELKVNAMET8JVJoint VentureVNAME
J_3GBELKVTWEGTVTWOrganizational Unit: Distribution ChannelsMANDT
J_3GBELKVTWEGTVTWOrganizational Unit: Distribution ChannelsVTWEG