SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

SAP AFFH (PRT assignment data for the work order) Table & Fields

AFFH is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of AFFH in SAP.

  • Table description : PRT assignment data for the work order
  • Module : CRM
  • Parent Module : CRM
  • Package : CF
  • Software Component : BBPCRM

Here is some free PDF files that you can download free for your reference.
Download Now

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP AFFH Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
AUFPLRouting number of operations in the orderCO_AUFPLAUFPL
PZLFHItem counter for production resources/toolsPZLFHPZLFH
.INCLUDEPRT assignment data for the work order    
LOEKZDeletion IndicatorLKENZXFELD
PARKZIndicator: inactive changesPARKZXFELD
DATUIDate Record Created onANDATDATUM
USERIUser Who Created RecordANNAMUSNAM
DATUCLast Changed OnAEDATDATUM
USERCName of Person Who Changed ObjectAENAMUSNAM
OBJTYObject types of the CIM resourceCR_OBJTYCR_OBJTY
OBJIDObject ID of the resourceCR_OBJIDCR_OBJID
PLNTY_KEYTask List TypePLNTYPLNTY
PLNNR_KEYKey for Task List GroupPLNNRPLNNR
PZLFH_KEYItem counter for production resources/toolsPZLFHPZLFH
ZAEHL_KEYInternal counterCIM_COUNTCIM_COUNT
OBJCTObject of a task listOBJCT_DOBJKT
APLZLInternal counterCIM_COUNTCIM_COUNT
PSNFHItem Number for Production Resource/ToolPSNFHPSNFH
OBJNRObject numberJ_OBJNRJ_OBJNR
STEUFControl key for management of production resources/toolsSTEUFSTEUF
KZKBLIndicator: Create load records for prod. resources/toolsKZKBLXFELD
BZOFFBReference date to start of production resource/tool usageBZOFFBCP_BZOFF
OFFSTBOffset to start of production resource/tool usageOFFSTBVNZTV
EHOFFBOffset unit for start of prod. resource/tool usageEHOFFBMEINS
BZOFFEReference date for end of production resource/tool usageBZOFFECP_BZOFF
OFFSTEOffset to finish of production resource/tool usageOFFSTEVNZTV
EHOFFEOffset unit for end of production resource/tool usageEHOFFEMEINS
FSFHDEarliest scheduled start (date) for PRT usageCF_FSFHDDATUM
FSFHZEarliest scheduled start (time) for PRT usageCF_FSFHZUZEIT
FEFHDEarliest scheduled finish (date) of PRT usageCF_FEFHDDATUM
FEFHZEarliest scheduled end (time) of PRT usageCF_FEFHZUZEIT
SSFHDLatest scheduled start (date) for PRT usageCF_SSFHDDATUM
SSFHZLatest scheduled start (time) for PRT usageCF_SSFHZUZEIT
SEFHDLatest scheduled finish (date) of PRT usageCF_SEFHDDATUM
SEFHZLatest scheduled end (time) for PRT usageCF_SEFHZUZEIT
ISFHDActual start (date) of PRT usageCF_ISFHDDATUM
ISFHZActual start (time) of PRT usageCF_ISFHZUZEIT
IEFHDActual finish (date) of PRT usageCF_IEFHDDATUM
IEFHZActual finish (time) of PRT usageCF_IEFHZUZEIT
DAUFLDuration of PRT usageCF_DAUFLCX_ZEIT
DAUEHTime unit for duration of PRT usageCF_DAUEHMEINS
MGEINHQuantity unit of production resource/toolMGEINHMEINS
MGVGWStandard value for the PRT quantityMGVGWMENG9
MGSOLEHQuantity unit of production resource/toolMGEINHMEINS
MGSOLTotal planned quantity of production resource/toolMGSOLMENG9
MGISTEHQuantity unit of production resource/toolMGEINHMEINS
MGISTConfirmed quantity of production resource/toolMGISTMENG9
MGRSTEHQuantity unit of production resource/toolMGEINHMEINS
MGRSTRemaining quantity of the production resource/toolMGRSTMENG9
MGAUSEHQuantity unit of production resource/toolMGEINHMEINS
MGAUSQuantity of checked-out production resources/toolsMGAUSMENG9
MGFORMFormula for calculating the total quantity of PRTCF_MGFORMAP_FORMEL
EWEINHUsage value unit of the production resource/toolEWEINHMEINS
EWVGWStandard usage value for production resources/toolsEWVGWMENG9
EWSOLEHUsage value unit of the production resource/toolEWEINHMEINS
EWSOLTotal planned usage value of production resource/toolEWSOLMENG9
EWISTEHUsage value unit of the production resource/toolEWEINHMEINS
EWISTActual usage value for production resource/toolEWISTMENG9
EWRSTEHUsage value unit of the production resource/toolEWEINHMEINS
EWRSTRemaining usage value of the production resource/toolEWRSTMENG9
EWFORMFormula for calculating the total usage value of PRTCF_EWFORMAP_FORMEL
TXTSPLanguage KeySPRASSPRAS
KTSCHStandard text key for production resources/toolsCF_KTSCHKTSCH
TXTZ1First line of text for production resources/toolsTXTZ1TEXT40
OBJTYPEChange indicatorOCM_OBJ_TYPEOCM_OBJ_TYPE
CH_PROCProcess that has lead to the change of an objectOCM_CH_PROCOCM_CH_PROC
AENNRChange NumberAENNRAENNR

AFFH related tables

TableNote
AFFHPRT assignment data for the work order
CRFHCIM production resource/tool master data
CRVD_ALink of PRT to Document
CRVD_BLink of Document to PRT
CRVE_AAssignment PRT data - equipment
CRVE_BAssignment equipment - PRT data
CRVM_ALink of PRT data to a material
CRVM_BLink of material to a production resource/tool
CRVP_ALinkage of PRT Data - Measuring Point
CRVP_BLinkage of Measuring Point - PRT Data
CRVS_ARelationship of PRT internal number to PRT external number
CRVS_BRelationship of PRT external number to PRT internal number
TCF02PRT categories
TCF03Texts for the production resources/tools category
TCF04Status of the PRT master
TCF05Language-dependent text table for PRT status
TCF06Field groups in the PRT master for reference
TCF07Language-dependent texts for field groups in PRT master
TCF08Assignment of PRT master fields to field groups
TCF10PRT control key

SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2021 sapstack.com