OIFSPBL

Physical Location - Master Data

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

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

SAP-tabel OIFSPBL heeft 2 primaire sleutelvelden: MANDT,PBLNR.

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.

OIFSPBL velden.

27 velden
VeldOmschrijvingDatatypeLengteDecimalenChecktabelData-element
Sleutel MANDT ClientCLNT30 T000 MANDT
Sleutel PBLNR Business location identifier (IS-Oil MRN)CHAR100 OIF_PBLNR
NAME1 Internal name fieldCHAR350 OIF_PBNAM1
PBLTYP Business Location Type (IS-Oil MRN)CHAR40 OIFSPBLT OIF_PBLTYP
ADDRNUM Address No. in ADRCCHAR100 OIFSMCADDR OIF_ADNUM
ERDAT Date Record Created on (Date)DATS80 OIF_ERDAT
ERZEIT Time Record Created at (Time)TIMS60 OIF_ERZEIT
ERNAM User who Created RecordCHAR120 OIF_ERNAM
AEDAT Date Record Changed on (Date)DATS80 OIF_AEDAT
AEZEIT Time when Record Was ChangedTIMS60 OIF_AEZEIT
AENAM User who Changed RecordCHAR120 OIF_AENAM
BLOIND Block IndicatorCHAR10 OIF_BLOIND
DELIND Deletion indicatorCHAR10 OIF_DELIND
BLCODE Business Location Blocking Indicator (IS-Oil MRN)CHAR20 OIFSBLCD OIF_BLCD
OBJNR Object numberCHAR220 * J_OBJNR
BRAND Location brandCHAR50 OIRBBRAND OIRB_BRAND
LOCVALUE Relative location valueCHAR20 OIRBPBLVAL OIRB_VAL
LOCVDIFF Location value differentiatorCHAR20 OIRBPBLVALD OIRB_LOCVDIFF
LOCAA Location area assignmentCHAR50 OIRBLAA OIRB_LAA
LOCMP SSR Pricing - Margins procedure assigned to this locationCHAR10 OIRCTVKD OIRC_KALKS
PCGROUP Process control groupCHAR100 OIRAPCG OIRA_PCG
AUTGR Authorization groupCHAR40 OIRB_AUTGR
VALGP SSR PC: Upload validation groupCHAR20 OIREVALGP OIREVALGROUP
BUKRS Company CodeCHAR40 T001 BUKRS
OIRIPGRP SSR SD/FI Invoice posting groupCHAR20 OIRI_PGRP
CONVGR SSR Interface conversion group definition (IS-Oil, SSR)CHAR40 OIRHCVGRDEFC OIRH_CONVGR
LOGSYS Logical system for EDICHAR100 TBDLS OIRH_LOGSYS

OIFSPBL relaties.

23 relaties
TabelVeldChecktabelOmschrijvingCheckveld
OIFSPBLADDRNUMOIFSMCADDRLink Table Between OIFSPBL and ADRC for MatchcodeMANDT
OIFSPBLADDRNUMOIFSMCADDRLink Table Between OIFSPBL and ADRC for MatchcodePBLNR
OIFSPBLBLCODEOIFSBLCDBlocking Indicator for Business LocationsMANDT
OIFSPBLBLCODEOIFSBLCDBlocking Indicator for Business LocationsBLCODE
OIFSPBLBRANDOIRBBRANDLocation Brand (IS-OIL SSR)MANDT
OIFSPBLBUKRST001Company CodesBUKRS
OIFSPBLCONVGROIRHCVGRDEFCConversion Group Definitions(IS-Oil, SSR)MANDT
OIFSPBLCONVGROIRHCVGRDEFCConversion Group Definitions(IS-Oil, SSR)CONVGR
OIFSPBLLOCAAOIRBLAALocation area assignment (IS-OIL SSR)MANDT
OIFSPBLLOCAAOIRBLAALocation area assignment (IS-OIL SSR)RNBT
OIFSPBLLOCAAOIRBLAALocation area assignment (IS-OIL SSR)LOCAACTRY
OIFSPBLLOCMPOIRCTVKDSSR Pricing - Location Margin ProcedureMANDT
OIFSPBLLOCVALUEOIRBPBLVALRelative Location Value (IS-OIL SSR)MANDT
OIFSPBLLOCVALUEOIRBPBLVALRelative Location Value (IS-OIL SSR)LOCVALUE
OIFSPBLLOCVDIFFOIRBPBLVALDLocation Value differentiator (IS-OIL SSR)MANDT
OIFSPBLLOCVDIFFOIRBPBLVALDLocation Value differentiator (IS-OIL SSR)LOCVDIFF
OIFSPBLLOGSYSTBDLSLogical systemLOGSYS
OIFSPBLMANDTT000ClientsMANDT
OIFSPBLPBLTYPOIFSPBLTPhysical Business Location TypeMANDT
OIFSPBLPBLTYPOIFSPBLTPhysical Business Location TypePBLTYP
OIFSPBLPCGROUPOIRAPCGProcess Control Group (IS-OIL SSR)PCGROUP
OIFSPBLVALGPOIREVALGPSSR PC: Upload Validation GroupMANDT
OIFSPBLVALGPOIREVALGPSSR PC: Upload Validation GroupVALGP